internal SqlDataReader GetCheckTransListByCheck(CheckInfo check)
{
string strSql = string.Empty;
strSql = string.Format("SELECT * FROM T_CheckTrans WHERE CheckID = {0}", check.ID);
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
internal SqlDataReader GetAllMenuList(bool IsChecked)
{
string strSql = string.Empty;
strSql = string.Format("SELECT {0} AS IsChecked,T_Menu.* FROM T_Menu WHERE ISDEL <> 2 ", IsChecked.ToInt32());
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
public SqlDataReader GetUserGroupByID(UserGroupInfo model)
{
string strSql = string.Empty;
strSql = string.Format("SELECT * FROM T_UserGroup WHERE ID = {0}", model.ID);
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
internal SqlDataReader GetCheckDetailsListByCheckID(int checkID)
{
string strSql = string.Empty;
strSql = string.Format("SELECT * FROM V_CheckDetails WHERE CheckID = {0}", checkID);
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
internal SqlDataReader GetCheckMaterialListByCheckID(int checkID)
{
string strSql = string.Empty;
strSql = string.Format("SELECT materialno,MATERIALDESC,materialstd,SUM(ACCOUNTQTY) AccountQty FROM V_CheckDetails WHERE CheckID = {0} group by materialno,materialstd,MATERIALDESC", checkID);
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
public SqlDataReader IsAreaChecking(AreaInfo model)
{
string strSql = string.Empty;
strSql = string.Format("select areastatus,CheckID from T_AREA where areano='{0}'", model.AreaNo);
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
internal SqlDataReader GetAppVersionByVersion(AppVersionInfo model)
{
string strSql = string.Empty;
strSql = string.Format("SELECT * FROM T_AppVersionLog WHERE AppName = '{0}' AND AppVersion = '{1}' ", model.AppName, model.AppVersion);
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
internal SqlDataReader GetAreaByNo(string strAreaNo)
{
string strSql = string.Empty;
strSql = string.Format("SELECT * FROM V_Area WHERE AreaNo = '{0}'", strAreaNo);
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
public SqlDataReader GetTaskTransByID(TaskTransInfo model)
{
string strSql = string.Empty;
strSql = string.Format("SELECT * FROM TTaskTrans WHERE ID = {0}", model.ID);
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
public SqlDataReader GetWarehouseByID(WarehouseInfo model)
{
string strSql = string.Empty;
strSql = string.Format("SELECT * FROM V_Warehouse WHERE ID = {0} or WarehouseNo='{1}'", model.ID, model.WarehouseNo);
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
public SqlDataReader GetTempMaterialByNo(TempMaterialInfo model)
{
string strSql = string.Empty;
strSql = string.Format("SELECT * FROM V_TempMaterial WHERE TempMaterialNo = '{0}'", string.IsNullOrEmpty(model.MaterialNo) ? model.TempMaterialNo : model.MaterialNo);
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
public SqlDataReader GetKeeperList()
{
string strSql = string.Empty;
strSql = string.Format("SELECT * FROM V_User WHERE USERNAME in (select distinct keeper from t_keeperinfo)");
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
public SqlDataReader GetCheckDetailsByID(CheckDetailsInfo model)
{
string strSql = string.Empty;
strSql = string.Format("SELECT * FROM V_CheckDetails WHERE ID = {0}", model.ID);
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
public SqlDataReader GetSpecialList(string fieldName)
{
string strSql = string.Empty;
strSql = string.Format("SELECT {0} FROM T_SpecialReturnMaterial WHERE IsDel = 1", fieldName);
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
public SqlDataReader GetSpecialReturnMaterialByID(SpecialReturnMaterial model)
{
string strSql = string.Empty;
strSql = string.Format("SELECT * FROM T_SpecialReturnMaterial WHERE ID = {0}", model.ID);
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
public SqlDataReader GetAreaByAreaNo(AreaInfo model)
{
string strSql = string.Empty;
strSql = string.Format("SELECT * FROM V_Area WHERE AreaNo = '{0}'", model.AreaNo);
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
public SqlDataReader GetPreparationByID(Preparation model)
{
string strSql = string.Empty;
strSql = string.Format("SELECT * FROM V_Preparation WHERE ID = {0}", model.ID);
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
internal SqlDataReader GetKeeperList(string keeperno)
{
string strSql = string.Empty;
strSql = string.Format("SELECT UserNo, UserName FROM v_User where userno like '%{0}%' or username like '%{0}%' Order By ID Desc ", keeperno);
strSql = string.Format("SELECT UserNo, UserName FROM v_User where userno = '{0}' or username = '******' Order By ID Desc ", keeperno);
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
public bool QueryStockSumByArraySerialNo(out List <StockHead_Model> list, string strArraySerialNo, out string strErrMsg)
{
string strSerialNo = "";
string[] ArrayMaterialNo = strArraySerialNo.Split(',');
foreach (var item in ArrayMaterialNo)
{
if (string.IsNullOrEmpty(strSerialNo))
{
strSerialNo = "N'" + item + "'";
}
else
{
strSerialNo += (",N'" + item + "'");
}
}
try
{
string sql = @"select materialno,batchno,Descr,CHDesc,dMDate,dVDate,shelflife,qty ,num,serialno from T_BARCODE where 1=1 AND serialno IN (" + strSerialNo + ")";
list = new List <StockHead_Model>();
using (SqlDataReader dr = OperationSql.ExecuteReader(System.Data.CommandType.Text, sql))
{
while (dr.Read())
{
Stock_Model model = new Stock_Model();
model.MaterialNo = dr["materialno"].ToDBString();
model.MaterialENDesc = dr["materialdesc"].ToDBString();
model.MaterialCHDesc = dr["MaterialCHDesc"].ToCHString();
model.Qty = dr["qty"].ToDecimal();
model.Num = dr["num"].ToInt32();
model.BatchNo = dr["batchno"].ToDBString();
model.SerialNo = dr["serialno"].ToDBString();
StockHead_Model head = list.Find(s => s.MaterialNo.Equals(model.MaterialNo) && s.BatchNo.Equals(model.BatchNo));
if (head == null)
{
head = new StockHead_Model(model);
list.Add(head);
}
else
{
head.iQuantity += model.Qty;
head.iNum += model.Num;
head.lstStockInfo.Add(model);
}
}
}
strErrMsg = "";
return(true);
}
catch (Exception ex)
{
list = null;
strErrMsg = ex.Message;
return(false);
}
}
public List <Stock_Model> GetStockByArrayMaterialNo(string VoucherNo, string strArrayMaterialNo)
{
string strMaterialNo = "";
string[] ArrayMaterialNo = strArrayMaterialNo.Split(',');
foreach (var item in ArrayMaterialNo)
{
if (string.IsNullOrEmpty(strMaterialNo))
{
strMaterialNo = "N'" + item + "'";
}
else
{
strMaterialNo += (",N'" + item + "'");
}
}
try
{
List <Stock_Model> lstStock = new List <Stock_Model>();
string strSql = "";
if (string.IsNullOrEmpty(VoucherNo))
{
strSql = @"select * from v_getstockbymaterialno where 1=1 and materialno in (" + strMaterialNo + ")";
}
else
{
strSql = @"select a.materialno,a.materialdesc,b.materialstd,warehouseno,areano,b.voucherno,ISNULL(sum(a.qty),0) qty from T_STOCK a join T_OUTBARCODE b on a.serialno=b.serialno
where a.materialno in (" + strMaterialNo + ") and b.voucherno='" + VoucherNo + "' group by a.materialno,a.materialdesc,b.materialstd,warehouseno,areano,b.voucherno";
}
using (SqlDataReader dr = OperationSql.ExecuteReader(System.Data.CommandType.Text, strSql))
{
while (dr.Read())
{
Stock_Model stockModel = new Stock_Model();
stockModel.MaterialNo = dr["materialno"].ToDBString();
stockModel.AreaNo = dr["areano"].ToDBString();
stockModel.MaterialENDesc = dr["materialdesc"].ToDBString();
stockModel.MaterialStd = dr["materialstd"].ToDBString();
stockModel.Qty = dr["qty"].ToDecimal();
if (!string.IsNullOrEmpty(VoucherNo))
{
stockModel.VoucherNo = dr["VoucherNo"].ToDBString();
}
lstStock.Add(stockModel);
}
}
return(lstStock);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取上架任务
/// </summary>
/// <returns></returns>
public List <Task_Model> GetTaskInfo(UserInfo userModel, Barcode_Model barcodeMdl)
{
try
{
List <Task_Model> lstTask = new List <Task_Model>();
string strSql = string.Empty;
if (string.IsNullOrEmpty(barcodeMdl.SERIALNO))
{
strSql = string.Format("select * from V_GETTASKINFO where F_USERINWAREHOUSE(warehouse_id,'{0}')>0", userModel.WarehouseCode);
}
else
{
if (barcodeMdl.VOUCHERTYPE == "50" || barcodeMdl.VOUCHERTYPE == "60")
{
strSql = string.Format("select * from V_GETTASKINFO a where F_USERINWAREHOUSE(a.warehouse_id,'{0}')>0 and taskno = '{1}'", userModel.WarehouseCode, barcodeMdl.DELIVERYNO);
}
else
{
//strSql = string.Format("select * from V_GETTASKINFO a where F_USERINWAREHOUSE(a.warehouse_id,'{0}')>0 and deliveryno = '{1}'", userModel.WarehouseCode, barcodeMdl.DELIVERYNO);
strSql = string.Format(@"SELECT ID,TaskNo,'生产订单' VoucherTypeName
, IsShelvePost, IsQuality, CreateDateTime, DeliveryNo MaterialDoc
, VoucherType, DeliveryNo, (select top 1 username from T_USER where T_USER.userno =[T_TASK].receiveuserno and isdel = 1) ReceiveUserName
FROM[T_TASK] where deliveryno = '{0}'", barcodeMdl.DELIVERYNO);
}
}
using (SqlDataReader dr = OperationSql.ExecuteReader(System.Data.CommandType.Text, strSql))
{
while (dr.Read())
{
Task_Model TM = new Task_Model();
TM.ID = Convert.ToInt32(dr["ID"]);
TM.TaskNo = dr["taskno"].ToDBString();
TM.ReceiveUserName = dr["receiveusername"].ToDBString();
TM.VoucherTypeName = dr["vouchertypename"].ToDBString();
TM.IsShelvePost = dr["isshelvepost"].ToInt32();
TM.IsQuality = dr["IsQuality"].ToInt32();
TM.CreateDateTime = dr["CreateDateTime"].ToDateTime();
TM.MaterialDoc = dr["materialdoc"].ToDBString();
TM.VoucherType = dr["VoucherType"].ToInt32();
TM.DeliveryNo = dr["deliveryno"].ToDBString();
lstTask.Add(TM);
}
}
return(lstTask);
}
catch (Exception ex)
{
throw ex;
}
}
public Barcode_Model GetBarCodeInfo(string strSerialNo)
{
try
{
string strSql = string.Format("select supcode,SUPNAME,ID,VOUCHERTYPE,DELIVERYNO,VOUCHERNO,ROWNO,QTY, OUTPACKQTY,BARCODE,BARCODETYPE,SERIALNO,MATERIALNO,MATERIALDESC,MATERIALSTD,BATCHNO,ROWNO,TrayID,ISNULL(iFlag,0) iFlag,[ProductLineNo] cProductLineCode,SoCode,ArrivalCode from t_outbarcode where serialno = '{0}'", strSerialNo);
Barcode_Model barcodeMdl = new Barcode_Model();
using (SqlDataReader dr = OperationSql.ExecuteReader(System.Data.CommandType.Text, strSql))
{
if (dr.Read())
{
barcodeMdl.ID = dr["id"].ToDecimal();
barcodeMdl.DELIVERYNO = dr["DELIVERYNO"].ToDBString();
barcodeMdl.VOUCHERNO = dr["VOUCHERNO"].ToDBString();
barcodeMdl.ROWNO = dr["ROWNO"].ToDBString();
barcodeMdl.OUTPACKQTY = dr["OUTPACKQTY"].ToDecimal();
barcodeMdl.labeltype = dr["BARCODETYPE"].ToDBString();
barcodeMdl.QTY = dr["QTY"].ToDecimal();
barcodeMdl.BARCODE = dr["barcode"].ToDBString();
barcodeMdl.SERIALNO = dr["serialno"].ToDBString();
barcodeMdl.MATERIALNO = dr["materialno"].ToDBString();
barcodeMdl.MATERIALDESC = dr["materialdesc"].ToDBString();
barcodeMdl.MATERIALSTD = dr["materialstd"].ToDBString();//规格型号
barcodeMdl.BATCHNO = dr["batchno"].ToDBString();
//barcodeMdl.ROWNO = dr["rowno"].ToDBString();
barcodeMdl.VOUCHERTYPE = dr["VOUCHERTYPE"].ToDBString();
barcodeMdl.TrayID = dr["TrayID"].ToInt32();
barcodeMdl.iFlag = dr["iFlag"].ToInt32();
barcodeMdl.cProductLineCode = dr["cProductLineCode"].ToDBString();//产线
barcodeMdl.SoCode = dr["SoCode"].ToDBString();
barcodeMdl.ArrivalCode = dr["ArrivalCode"].ToDBString();
barcodeMdl.SUPCODE = dr["SUPCODE"].ToDBString();
barcodeMdl.SUPNAME = dr["SUPNAME"].ToDBString();
}
}
if (barcodeMdl.TrayID != 0)
{
Tray_Func tf = new Tray_Func();
Tray_Model tray = new Tray_Model();
if (tf.GetTrayInfoByTrayID(barcodeMdl, ref tray))
{
barcodeMdl.tray_Model = tray;
}
}
return(barcodeMdl);
}
catch (Exception ex)
{
throw ex;
}
}
public bool GetOldSaleBillVouch(SaleBillDetails_Model detail, out List <SaleBillDetails_Model> list, out string strErrMsg)
{
try
{
string strSql = @"select * from T_temptrans where ssbvcode = '" + detail.ssbvcode + "' and ssbvrowno = '" + detail.ssbvrowno + "'";
list = new List <SaleBillDetails_Model>();
using (SqlDataReader dr = OperationSql.ExecuteReader(System.Data.CommandType.Text, strSql))
{
while (dr.Read())
{
SaleBillDetails_Model SM = new SaleBillDetails_Model();
SM.cinvcode = dr["cinvcode"].ToDBString();
SM.cinvname = dr["cinvname"].ToDBString();
SM.cinvstd = dr["cinvstd"].ToDBString();
SM.ssorowno = dr["ssorowno"].ToDBString();
SM.ssbvrowno = dr["ssbvrowno"].ToDBString();
SM.ssoqty = dr["ssoqty"].ToDecimal();
SM.ssbvqty = dr["ssbvqty"].ToDecimal();
SM.ssocode = dr["ssocode"].ToDBString();
SM.ssbvcode = dr["ssbvcode"].ToDBString();
SM.creater = dr["creater"].ToString();
SM.createdate = dr["createdate"].ToString();
SM.verifydate = dr["verifydate"].ToString();
SM.qty = dr["qty"].ToDecimal();
SM.dsocode = dr["dsocode"].ToDBString();
SM.dsorowno = dr["dsorowno"].ToDBString();
SM.dsoqty = dr["dsoqty"].ToDecimal();
SM.RealQty = dr["RealQty"].ToDecimal();
//获取autoid
SM.autoid = OperationSql.ExecuteScalarForERP(System.Data.CommandType.Text, @"Select SaleBillVouchZW.autoid
From SaleBillVouchZW
left join (select cbdefine1 as cbdefine1,cbdefine5 as cbdefine5,cbdefine6 as cbdefine6,autoid as keyextend_b_autoid_salebillvouchs_extradefine_autoid
from salebillvouchs_extradefine) extend_b_autoid_salebillvouchs_extradefine on
keyextend_b_autoid_salebillvouchs_extradefine_autoid=salebillvouchzw.autoid
join SaleBillVouchZT on SaleBillVouchZT.sbvid=SaleBillVouchZW.sbvid
left join SO_SODetails on (SaleBillVouchZW.cSOCode = SO_SODetails.cSOCode and SaleBillVouchZW.iorderrowno = SO_SODetails.iRowNo)
where cSource=N'销售' and csbvcode = '" + SM.ssbvcode + "' and SaleBillVouchZW.cinvcode ='" + SM.cinvcode + "'").ToString();
list.Add(SM);
}
}
strErrMsg = "";
return(true);
}
catch (Exception ex)
{
strErrMsg = ex.Message;
list = null;
return(false);
}
}
public Task_Model GetTaskDetailsInfo(string strTaskNo)
{
try
{
Task_Model TM = new Task_Model();
TM.lstTaskDetails = new List <TaskDetails_Model>();
string strSql = string.Format("select * from V_GETTASKDETAILSINFO where taskno = '{0}'", strTaskNo);
using (SqlDataReader dr = OperationSql.ExecuteReader(System.Data.CommandType.Text, strSql))
{
while (dr.Read())
{
TM.ID = dr["task_id"].ToInt32();
TM.TaskNo = dr["taskno"].ToDBString();
TM.TaskStatus = dr["taskstatus"].ToInt32();
TM.IsShelvePost = dr["isshelvepost"].ToInt32();
TM.IsQuality = dr["isquality"].ToInt32();
TM.VoucherType = dr["VoucherType"].ToInt32();
TM.Plant = dr["plant"].ToDBString();
TM.DeliveryNo = dr["deliveryno"].ToDBString();
TaskDetails_Model TDM = new TaskDetails_Model();
TDM.ID = dr["id"].ToInt32();
TDM.MaterialNo = dr["materialno"].ToDBString();
TDM.MaterialDesc = dr["materialdesc"].ToDBString();
TDM.MaterialStd = dr["MaterialStd"].ToDBString();
TDM.TaskQty = dr["taskqty"].ToDecimal();
TDM.QuanlityQty = dr["qualityqty"].ToDecimal();
TDM.RemainQty = dr["remainqty"].ToDecimal();
TDM.ShelveQty = dr["shelveqty"].ToDecimal();
TDM.RowNo = dr["RowNo"].ToDBString();
TDM.VoucherNo = dr["VoucherNo"].ToDBString();
TDM.PackCount = dr["PackCount"].ToDecimal();
TDM.ShelvePackCount = dr["ShelvePackCount"].ToDecimal();
TDM.RemainPackCount = dr["RemainPackCount"].ToDecimal();
TM.lstTaskDetails.Add(TDM);
}
}
strSql = string.Format(@"SELECT A.warehouseno FROM T_WAREHOUSE A JOIN T_TASKWAREHOUSE B ON A.id=B.warehouse_id JOIN T_TASK C ON B.task_id=C.id
WHERE C.taskno = '{0}'", strTaskNo);
TM.WareHouseNo = OperationSql.ExecuteScalar(CommandType.Text, strSql, null).ToString();
return(TM);
}
catch (Exception ex)
{
throw ex;
}
}
//查询当前的物料号是否在临时物料表里
public bool ExistsTempMaterialByMaterialNo(string materialNo)
{
string sql = "select * from T_TEMPMATERIAL where TEMPMATERIALNO='" + materialNo + "'";
using (SqlDataReader dr = OperationSql.ExecuteReader(CommandType.Text, sql))
{
if (dr.Read())
{
return(true);
}
else
{
return(false);
}
}
}
public bool UpdateLoginTime(UserInfo user)
{
string strSql;
user.LoginTime = DateTime.Now;
UserInfo model = new UserInfo();
if (user.ID >= 1 && user.UserType == 1)
{
strSql = string.Format("SELECT LoginIP, LoginDevice FROM T_User WHERE ID = {0}", user.ID);
using (SqlDataReader dr = OperationSql.ExecuteReader(CommandType.Text, strSql))
{
if (dr.Read())
{
model.LoginIP = dr["LoginIP"].ToDBString();
model.LoginDevice = dr["LoginDevice"].ToDBString();
if (!string.IsNullOrEmpty(model.LoginIP))
{
if (!string.IsNullOrEmpty(user.LoginIP) && model.LoginIP.IndexOf(user.LoginIP) <= -1)
{
model.LoginIP = string.Format("{0};{1}", model.LoginIP, user.LoginIP).Trim(';');
model.LoginDevice = string.Format("{0};{1}", model.LoginDevice, user.LoginDevice).Trim(';');
}
}
else
{
model.LoginIP = user.LoginIP;
model.LoginDevice = user.LoginDevice;
}
}
else
{
model.LoginIP = user.LoginIP;
model.LoginDevice = user.LoginDevice;
}
}
}
else
{
model.LoginIP = user.LoginIP;
model.LoginDevice = user.LoginDevice;
}
strSql = string.Format("UPDATE T_User SET LoginIP = '{0}', LoginTime = GETDATE(), LoginDevice = '{1}' WHERE ID = {2} ", model.LoginIP, model.LoginDevice, user.ID);
int i = OperationSql.ExecuteNonQuery2(CommandType.Text, strSql);
return(i >= 1);
}
public static List <ComboBoxItem> GetComboBoxItem(string strSql)
{
List <ComboBoxItem> items = new List <ComboBoxItem>();
using (SqlDataReader dr = OperationSql.ExecuteReader(CommandType.Text, strSql))
{
while (dr.Read())
{
ComboBoxItem item = new ComboBoxItem();
item.ID = int.Parse(dr["ID"].ToString());
item.Name = dr["Name"].ToString();
items.Add(item);
}
}
return(items);
}
internal SqlDataReader GetParentSelectMenu(MenuInfo model)
{
string strSql = string.Empty;
if (model.MenuType <= 2)
{
strSql = string.Format("SELECT ID, MenuName FROM (SELECT * FROM (SELECT 0 as ID, TO_CHAR('根节点') as MenuName, 0 as MenuType, 1 as NodeLevel FROM DUAL) UNION SELECT ID, TO_CHAR(MenuName) MenuName, MenuType, NodeLevel FROM T_MENU where ISDEL <> 2 ) T where menutype = {0} or (menutype = {1} and nodelevel < {2}) ", model.MenuType - 1, model.MenuType, model.NodeLevel);
}
else if (model.MenuType == 3)
{
strSql = string.Format("SELECT ID, MenuName FROM (SELECT * FROM (SELECT 0 as ID, TO_CHAR('根节点') as MenuName, 0 as MenuType, 1 as NodeLevel FROM DUAL) UNION SELECT ID, TO_CHAR(MenuName) MenuName, MenuType, NodeLevel FROM T_MENU where ISDEL <> 2 ) T where menutype = 2) ");
}
else
{
strSql = "SELECT 0 as ID, TO_CHAR('根节点') as MenuName FROM DUAL ";
}
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
internal bool IsChecking(Barcode_Model barcodeMdl, ref string strErrorMsg)
{
string strSql = "";
if (barcodeMdl.iFlag != 0 && barcodeMdl.iFlag != 10)
{
if (barcodeMdl.labeltype.Equals("10") || barcodeMdl.labeltype.Equals("14"))
{
strSql = string.Format("select a.serialno from T_OUTBARCODE a join T_INNERBARCODE b on a.id=b.outbox_id where b.serialno = '{0}'", barcodeMdl.SERIALNO);
string oSerialno = OperationSql.ExecuteScalar(CommandType.Text, strSql, null).ToDBString();
if (string.IsNullOrEmpty(oSerialno))
{
return(false);
}
barcodeMdl.SERIALNO = oSerialno;
}
strSql = string.Format("select b.areastatus,b.CheckID [ACheckID],a.status,a.CheckID [SCheckID] from t_stock a join T_AREA b on a.areano=b.areano where serialno='{0}'", barcodeMdl.SERIALNO);
using (SqlDataReader sdr = OperationSql.ExecuteReader(CommandType.Text, strSql, null))
{
if (sdr.Read())
{
if (sdr[0].ToInt32() != 1 && !string.IsNullOrEmpty(sdr[1].ToString()))
{
strErrorMsg = "该条码所在货位正在盘点！";
return(true);
}
if (sdr[2].ToInt32() != 1 && !string.IsNullOrEmpty(sdr[3].ToString()))
{
strErrorMsg = "该物料正在盘点！";
return(true);
}
}
else
{
if (barcodeMdl.iFlag != 4 && barcodeMdl.iFlag != 5)
{
strErrorMsg = "该条码库存有误！";
return(true);
}
}
}
}
return(false);
}
/// <summary>
/// 获取物料总库存(按仓库及物料汇总)
/// </summary>
/// <param name="list"></param>
/// <param name="strArrayMaterialNo">物料员，以“，”分隔</param>
/// <param name="strErrMsg"></param>
/// <returns></returns>
public bool QueryStockSumForTransfer(out List <StockHead_Model> list, string strArrayMaterialNo, out string strErrMsg)
{
string strMaterialNo = "";
string[] ArrayMaterialNo = strArrayMaterialNo.Split(',');
foreach (var item in ArrayMaterialNo)
{
if (string.IsNullOrEmpty(strMaterialNo))
{
strMaterialNo = "N'" + item + "'";
}
else
{
strMaterialNo += (",N'" + item + "'");
}
}
try
{
string sql = @"select materialno,Descr,CHDesc,warehouseno,SUM(iquantity) as sumqty,sum(inum) as sumnum from T_CURRENTSTOCK where 1=1 AND MATERIALNO IN (" + strMaterialNo + ") group by materialno,Descr,CHDesc,warehouseno";
list = new List <StockHead_Model>();
using (SqlDataReader dr = OperationSql.ExecuteReader(System.Data.CommandType.Text, sql))
{
while (dr.Read())
{
StockHead_Model model = new StockHead_Model();
model.MaterialNo = dr["materialno"].ToDBString();
model.MaterialENDesc = dr["materialdesc"].ToDBString();
model.MaterialCHDesc = dr["MaterialCHDesc"].ToCHString();
model.iQuantity = dr["sumqty"].ToDecimal();
model.iNum = dr["sumnum"].ToInt32();
model.WarehouseNo = dr["WarehouseNo"].ToDBString();
list.Add(model);
}
}
strErrMsg = "";
return(true);
}
catch (Exception ex)
{
list = null;
strErrMsg = ex.Message;
return(false);
}
}