DAL/TCWL_D_Product.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_Product
    {
        public string Add(TCWL_M_Product model)
        {
            if (DBHelper.GetDataTable(string.Format("select * from TCWL_Product where productName='{0}' and ServiceID like '%{1}%' ", model.productName, model.ServiceID)).Rows.Count > 0)
            {
                return "exist";
            }
            string str = string.Format("delete from TCWL_ProSize where ProId='{0}'", model.ID);
            string str2 = "";
            string str3 = "";
            for (int i = 0; i < model.standard.Count; i++)
            {
                str2 = str2 + string.Format("insert into TCWL_ProSize (ID,ProId,ProSize) values ('{0}','{1}','{2}') ;", model.standard[i].ID, model.standard[i].ProId, model.standard[i].ProSize);
                str3 = str3 + model.standard[i].ProId + ",";
            }
            if (str2.Length > 0)
            {
                str2 = str2.Substring(0, str2.Length - 1);
                str3 = str3.Substring(0, str3.Length - 1);
            }
            string str4 = string.Format("insert into TCWL_Product(productName,standard,belongto,productType,unit,price,priceUnit,ServiceID,lprice,state,memo,Pronum,ID) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}')", new object[] { model.productName, str3, model.belongto, model.productType, model.unit, model.price, model.priceUnit, model.ServiceID, model.lprice, model.state, model.Demon, model.Pronum, model.ID });
            if (DBHelper.ExecuteSQL(new string[] { str4, str, str2 }))
            {
                return "success";
            }
            return "error";
        }

        public string addCategory(string name, string srvid, string v)
        {
            string sqlString = "";
            try
            {
                if (v == "0")
                {
                    if (DBHelper.GetDataTable("select Familiar from TCWL_All_Dic_ProductCategories where Belong='0' and Familiar='" + name + "' union all select Familiar from TCWL_All_Dic_ProductCategories where ServerID='" + srvid + "' and Familiar='" + name + "'").Rows.Count > 0)
                    {
                        return "exist";
                    }
                }
                else if (DBHelper.GetDataTable("select Familiar from TCWL_All_Dic_ProductCategories where Familiar='" + name + "'").Rows.Count > 0)
                {
                    return "exist";
                }
                if (v == "0")
                {
                    sqlString = string.Format("insert into TCWL_All_Dic_ProductCategories (Familiar,ServerID,Belong) values ('{0}','{1}','1')", name, srvid);
                }
                else