DAL/TCWL_D_PriceDataProductList.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

namespace DAL
{
    using Common;
    using Model;
    using System;
    using System.Data;
    using System.Data.SqlClient;
    using System.Runtime.InteropServices;
    using System.Text;

    public class TCWL_D_PriceDataProductList
    {
        public bool Add(TCWL_M_PriceDataProductList model)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("insert into TCWL_PriceReference_ProductList(");
            builder.Append("parentID,price,ProductID)");
            builder.Append(" values (");
            builder.Append("@parentID,@price,@ProductID)");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@parentID", SqlDbType.NVarChar, 0x24), new SqlParameter("@price", SqlDbType.Float, 8), new SqlParameter("@ProductID", SqlDbType.NVarChar, 0x24) };
            cmdParms[0].Value = model.parentID;
            cmdParms[1].Value = model.price;
            cmdParms[2].Value = model.ProductID;
            return (DBHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }

        public bool Delete(string ID)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("delete from TCWL_PriceReference_ProductList ");
            builder.Append(" where ID=@ID ");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.NVarChar, 0x24) };
            cmdParms[0].Value = ID;
            return (DBHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }

        public bool DeleteList(string IDlist)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("delete from TCWL_PriceReference_ProductList ");
            builder.Append(" where ID in (" + IDlist + ")  ");
            return (DBHelper.ExecuteSql(builder.ToString(), new SqlParameter[0]) > 0);
        }

        public DataTable GetJMBChanPinListByPage(string strWhere, string orderby, int startIndex, int endIndex, out int total)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("SELECT * FROM ( ");
            builder.Append(" SELECT ROW_NUMBER() OVER (");
            if (!string.IsNullOrEmpty(orderby.Trim()))
            {
                builder.Append("order by T." + orderby);
            }
            else
            {
                builder.Append("order by T.ID desc");
            }
            builder.Append(")AS Row, T.ID,T.parentID,T.price,U.productName as MingCheng,T.ProductID  from TCWL_PriceReference_ProductList T inner join TCWL_Product u on T.ProductID=u.ID ");
            if (!string.IsNullOrEmpty(strWhere.Trim()))
            {