| | |
| | | #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 is_batchno,string is_fifo,string is_incheck,string is_outcheck, string username, string operType) |
| | | public static ToMessage AddUpdateInventoryFile(string materialid, string materialcode, string materialname, string materialspec, string uomcode, string warehousecode, string stocktypecode, 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 |
| | |
| | | dynamicParams.Add("@uomcode", uomcode); |
| | | dynamicParams.Add("@warehousecode", warehousecode); |
| | | dynamicParams.Add("@stocktypecode", stocktypecode); |
| | | dynamicParams.Add("@materialtypecode", materialtypecode); |
| | | dynamicParams.Add("@materialtypecode", ""); |
| | | dynamicParams.Add("@minstockqty", minstockqty); |
| | | dynamicParams.Add("@maxstockqty", maxstockqty); |
| | | dynamicParams.Add("@username", username); |
| | |
| | | dynamicParams.Add("@uomcode", uomcode); |
| | | dynamicParams.Add("@warehousecode", warehousecode); |
| | | dynamicParams.Add("@stocktypecode", stocktypecode); |
| | | dynamicParams.Add("@materialtypecode", materialtypecode); |
| | | dynamicParams.Add("@materialtypecode", ""); |
| | | dynamicParams.Add("@minstockqty", minstockqty); |
| | | dynamicParams.Add("@maxstockqty", maxstockqty); |
| | | dynamicParams.Add("@username", username); |
| | |
| | | try |
| | | { |
| | | list.Clear(); |
| | | //当前工序是否关联工艺路线 |
| | | //查询节拍工价表,当前产品、工艺路线、工序、设备是否设置节拍工价 |
| | | sql = @"select * from TPrteEqp_Stad |
| | | where materiel_code=@partcode and route_code=@routecode and step_code=@stepcode and eqp_code=@eqpcode"; |
| | | dynamicParams.Add("@partcode", partcode); |
| | |
| | | } |
| | | }); |
| | | } |
| | | |
| | | bool aa = DapperHelper.DoTransaction(list); |
| | | if (aa) |
| | | { |