莱科Api
blame | 历史 | 补丁 | 提交 | 提交对比 | 忽略空白
yl
2023-01-31 f21eadc526d728d65a46e0b7d172c21307cc4d18 
 VueWebApi/DLL/DAL/ProductModelDAL.cs


@@ -465,7 +465,7 @@


                var total = 0; //总条数


                var sql = @"select A.id,A.partcode,A.partname,A.partspec,A.uom_code,B.name as uom_name,D.code as stocktypecode,D.name as stocktypename,


                            C.code as materialtypecode,C.name as materialtypename,A.stck_code,T.name as stck_name,A.maxqty,A.minqty,U.username as lm_user,A.default_route,


                            A.lm_date,A.proute_id


                            A.lm_date,A.proute_id,A.is_batchno,A.is_fifo,A.is_incheck,A.is_outcheck


                            from TMateriel_Info A


                            left join TUom B on A.uom_code=B.code


                            left join TMateriel_Type C on A.materieltype_code=C.code


@@ -491,7 +491,7 @@


        #endregion




        #region[存货档案新增编辑]


        public static ToMessage AddUpdateInventoryFile(string materialid, string materialcode, string materialname, string materialspec, string uomcode, string warehousecode, string stocktypecode, string materialtypecode, string minstockqty, string maxstockqty, string username, string operType)


        public static ToMessage AddUpdateInventoryFile(string materialid, string materialcode, string materialname, string materialspec, string uomcode, string warehousecode, string stocktypecode, string materialtypecode, string minstockqty, string maxstockqty,string is_batchno,string is_fifo,string is_incheck,string is_outcheck, string username, string operType)


        {


            var dynamicParams = new DynamicParameters();


            try


@@ -509,8 +509,8 @@


                        mes.data = null;


                        return mes;


                    }


                    var sql = @"insert into TMateriel_Info(partcode,partname,partspec,uom_code,stocktype_code,materieltype_code,stck_code,maxqty,minqty,lm_user,lm_date) 


                            values(@materialcode,@materialname,@materialspec,@uomcode,@stocktypecode,@materialtypecode,@warehousecode,@maxstockqty,@minstockqty,@username,@CreateDate)";


                    var sql = @"insert into TMateriel_Info(partcode,partname,partspec,uom_code,stocktype_code,materieltype_code,stck_code,maxqty,minqty,lm_user,lm_date,is_batchno,is_fifo,is_incheck,is_outcheck) 


                            values(@materialcode,@materialname,@materialspec,@uomcode,@stocktypecode,@materialtypecode,@warehousecode,@maxstockqty,@minstockqty,@username,@CreateDate,@is_batchno,@is_fifo,@is_incheck,@is_outcheck)";


                    dynamicParams.Add("@materialcode", materialcode);


                    dynamicParams.Add("@materialname", materialname);


                    dynamicParams.Add("@materialspec", materialspec);


@@ -522,6 +522,10 @@


                    dynamicParams.Add("@maxstockqty", maxstockqty);


                    dynamicParams.Add("@username", username);


                    dynamicParams.Add("@CreateDate", DateTime.Now.ToString());


                    dynamicParams.Add("@is_batchno", is_batchno);


                    dynamicParams.Add("@is_fifo", is_fifo);


                    dynamicParams.Add("@is_incheck", is_incheck);


                    dynamicParams.Add("@is_outcheck", is_outcheck);


                    int cont = DapperHelper.SQL(sql, dynamicParams);


                    if (cont > 0)


                    {


@@ -541,7 +545,8 @@


                if (operType == "Update")


                {


                    var sql = @"update TMateriel_Info set partname=@materialname,partspec=@materialspec,uom_code=@uomcode,stocktype_code=@stocktypecode,materieltype_code=@materialtypecode,stck_code=@warehousecode,


                                maxqty=@maxstockqty,minqty=@minstockqty,lm_user=@username,lm_date=@CreateDate where id=@materialid";


                                maxqty=@maxstockqty,minqty=@minstockqty,lm_user=@username,lm_date=@CreateDate,is_batchno=@is_batchno,is_fifo=@is_fifo,


                                is_incheck=@is_incheck,is_outcheck=@is_outcheck where id=@materialid";


                    dynamicParams.Add("@materialid", materialid);


                    dynamicParams.Add("@materialname", materialname);


                    dynamicParams.Add("@materialspec", materialspec);


@@ -553,6 +558,10 @@


                    dynamicParams.Add("@maxstockqty", maxstockqty);


                    dynamicParams.Add("@username", username);


                    dynamicParams.Add("@CreateDate", DateTime.Now.ToString());


                    dynamicParams.Add("@is_batchno", is_batchno);


                    dynamicParams.Add("@is_fifo", is_fifo);


                    dynamicParams.Add("@is_incheck", is_incheck);


                    dynamicParams.Add("@is_outcheck", is_outcheck);


                    int cont = DapperHelper.SQL(sql, dynamicParams);


                    if (cont > 0)


                    {


@@ -1935,7 +1944,6 @@


            return mes;


        }


        #endregion