金拓API
blame | 历史 | 补丁 | 提交 | 提交对比 | 忽略空白
yl
2023-02-13 eddeff0b81ea84c3b66ab1b8b7943146f953b0e1 
 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)


                    {


@@ -1679,13 +1688,13 @@


                        where A.step_code=@stepcode and A.is_delete<>'1' and B.is_delete<>'1'


                        ) B on T.org_code=B.wksp_code where T.description='W' and is_delete<>'1'


                        UNION ALL


                        select distinct T.btype as wksp_code,(case T.btype  when 'WX' then '外协供方' end ) as wksp_name,'W' as type,(case when B.btype is null then 'N' else 'Y' end) flag 


                        select distinct T.type as wksp_code,(case when T.type='211' then '供应商' when T.type='228' then '客户/供应商' end ) as wksp_name,'W' as type,(case when B.type is null then 'N' else 'Y' end) flag 


                        from TCustomer T


                        left join(


                        select distinct A.eqp_code,B.btype  from TFlw_Rteqp A 


                        select distinct A.eqp_code,B.type  from TFlw_Rteqp A 


                        inner join TCustomer B on A.eqp_code=B.code 


                        where A.step_code=@stepcode and A.is_delete<>'1' and B.is_delete<>'1'


                        ) B on T.btype=B.btype where T.btype='WX' and T.is_delete<>'1'";


                        where A.step_code=@stepcode  and A.is_delete<>'1' and B.is_delete<>'1'


                        ) B on T.type=B.type where T.type in('211','228') and T.is_delete<>'1'"; //226(客户)


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


                var data = DapperHelper.selectdata(sql, dynamicParams);


                for (int i = 0; i < data.Rows.Count; i++)


@@ -1696,7 +1705,7 @@


                    rout.type = data.Rows[i]["TYPE"].ToString();


                    rout.flag = data.Rows[i]["FLAG"].ToString();


                    rout.children = new List<StepEqpCn>();


                    if (rout.code == "WX") //外协供方


                    if (rout.code == "211"|| rout.code == "228") //外协供方


                    {


                        //根据外协供方标识编码查找外协供方信息(包含已关联标识)


                        sql = @"select A.code,A.name,'W' as type,(case when B.eqp_code is null then 'N' else 'Y' end) flag


@@ -1704,8 +1713,9 @@


                                left join(


                                select distinct A.eqp_code  from TFlw_Rteqp A 


                                inner join TCustomer B on A.eqp_code=B.code 


                                where B.btype=@wxcode and A.is_delete<>'1' and B.is_delete<>'1'


                                ) B on A.code=B.eqp_code where A.btype=@wxcode and A.is_delete<>'1'";


                                where A.step_code=@stepcode and B.type=@wxcode and A.is_delete<>'1' and B.is_delete<>'1'


                                ) B on A.code=B.eqp_code where A.type=@wxcode and A.is_delete<>'1'";


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


                        dynamicParams.Add("@wxcode", rout.code);


                        var data0 = DapperHelper.selectdata(sql, dynamicParams);


                        for (int k = 0; k < data0.Rows.Count; k++)


@@ -1935,7 +1945,6 @@


            return mes;


        }


        #endregion