public static int GetInvcodeInfo(string connectionString, string strInvCode, out CodebarLabel cl, out string errMsg) { cl = null; errMsg = ""; try { string SQL = "select a.cInvCode,a.cInvName,a.cInvStd,a.cInvDefine1,b.cComUnitName, a.cInvDefine11, a.cInvDefine2, a.cInvDefine13, a.iInvSCost, a.fRetailPrice, a.cAddress " + " from inventory a left join ComputationUnit b" + " on a.cComUnitCode = b.cComUnitCode" + " where cInvCode='" + strInvCode + "'"; DataSet Ds_Inv = new DataSet(); int i = OperationSql.GetDataset(SQL, connectionString, out Ds_Inv, out errMsg); if (i != 0) { return -2; } else { if (Ds_Inv.Tables[0].Rows.Count == 0) { errMsg = "存货编码错误"; return -2; } else { cl = new CodebarLabel(); cl.CInvCode = Ds_Inv.Tables[0].Rows[0][0].ToString(); cl.CInvName = Ds_Inv.Tables[0].Rows[0][1].ToString(); cl.Cstandard = Ds_Inv.Tables[0].Rows[0][2].ToString(); //cl.Ccolor = Ds_Inv.Tables[0].Rows[0][3].ToString(); cl.Comunitname = Ds_Inv.Tables[0].Rows[0][4].ToString(); //cl.Qty = Ds_Inv.Tables[0].Rows[0][5].Equals(DBNull.Value) ? 0 : Convert.ToInt32(Ds_Inv.Tables[0].Rows[0][5]); //cl.Cartonsize = Ds_Inv.Tables[0].Rows[0][6].Equals(DBNull.Value) ? string.Empty : Ds_Inv.Tables[0].Rows[0][6].ToString(); cl.Weight = Ds_Inv.Tables[0].Rows[0][7].Equals(DBNull.Value) ? 0.0 : Convert.ToDouble(Ds_Inv.Tables[0].Rows[0][7]); cl.IInvSCost = Ds_Inv.Tables[0].Rows[0][8].Equals(DBNull.Value) ? 0.0 : Convert.ToDouble(Ds_Inv.Tables[0].Rows[0][8]); cl.IInvSaleCost = Ds_Inv.Tables[0].Rows[0][9].Equals(DBNull.Value) ? 0.0 : Convert.ToDouble(Ds_Inv.Tables[0].Rows[0][9]); cl.CAddress = Ds_Inv.Tables[0].Rows[0][10].Equals(DBNull.Value) ? string.Empty : Ds_Inv.Tables[0].Rows[0][10].ToString(); return 0; } } } catch (Exception ex) { errMsg = ex.Message; return -1; } }
public static int GetArvInv(string connectionString, string arrivalCode, out List<CodebarLabel> cllist, out string errMsg) { cllist = null; errMsg = ""; try { string SQL = "select a.cInvCode,a.cInvName,a.cInvStd,a.cInvDefine1,b.iQuantity, d.cComUnitName, a.cInvDefine11, a.cInvDefine2, a.cInvDefine13, a.iInvSCost, a.fRetailPrice, a.cAddress " + " from inventory a" + " left join pu_arrivalvouchs b on a.cInvCode = b.cInvCode" + " left join pu_arrivalvouch c on b.id = c.id" + " left join ComputationUnit d on a.cComUnitCode = d.cComUnitCode" + " where c.ccode = '" + arrivalCode + "'"; DataSet Ds_Inv = new DataSet(); int r = OperationSql.GetDataset(SQL, connectionString, out Ds_Inv, out errMsg); if (r != 0) { return -2; } else { if (Ds_Inv.Tables[0].Rows.Count == 0) { errMsg = "数据错误"; return -2; } else { cllist = new List<CodebarLabel>(); for(int i = 0;i<Ds_Inv.Tables[0].Rows.Count; i++) { CodebarLabel cl = new CodebarLabel(); cl.CInvCode = Ds_Inv.Tables[0].Rows[i][0].ToString(); cl.CInvName = Ds_Inv.Tables[0].Rows[i][1].ToString(); cl.Cstandard = Ds_Inv.Tables[0].Rows[i][2].ToString(); //cl.Ccolor = Ds_Inv.Tables[0].Rows[i][3].ToString(); cl.Cquantity = Convert.ToInt32(Ds_Inv.Tables[0].Rows[i][4]); cl.Comunitname = Ds_Inv.Tables[0].Rows[i][5].ToString(); //cl.Qty = Ds_Inv.Tables[0].Rows[i][6].Equals(DBNull.Value) ? 0 : Convert.ToInt32(Ds_Inv.Tables[0].Rows[i][6]); //cl.Cartonsize = Ds_Inv.Tables[0].Rows[i][7].Equals(DBNull.Value) ? string.Empty : Ds_Inv.Tables[0].Rows[i][7].ToString(); cl.Weight = Ds_Inv.Tables[0].Rows[i][8].Equals(DBNull.Value) ? 0.0 : Convert.ToDouble(Ds_Inv.Tables[0].Rows[i][8]); cl.IInvSCost = Ds_Inv.Tables[0].Rows[i][9].Equals(DBNull.Value) ? 0.0 : Convert.ToDouble(Ds_Inv.Tables[0].Rows[i][9]); cl.IInvSaleCost = Ds_Inv.Tables[0].Rows[i][10].Equals(DBNull.Value) ? 0.0 : Convert.ToDouble(Ds_Inv.Tables[0].Rows[i][10]); cl.CAddress = Ds_Inv.Tables[0].Rows[i][11].Equals(DBNull.Value) ? string.Empty : Ds_Inv.Tables[0].Rows[i][11].ToString(); cllist.Add(cl); } return 0; } } } catch (Exception ex) { errMsg = ex.Message; return -1; } }
public static int GetClsInv(string connectionString, string cInvCode, string cInvName, string cBarCode, out List<CodebarLabel> clist, out string errMsg) { clist = new List<CodebarLabel>(); errMsg = string.Empty; try { string SQL = @"select a.cInvCode,a.cInvName,a.cInvStd,a.cInvDefine1,b.cComUnitName, a.cInvDefine11, a.cInvDefine2, a.cInvDefine13, a.iInvSCost, a.fRetailPrice, a.cAddress,a.cBarCode,a.cMassUnit,a.iMassDate from inventory a left join ComputationUnit b on a.cComUnitCode = b.cComUnitCode where 1=1 "; //判断存货编码是否为空 if (!string.IsNullOrEmpty(cInvCode)) { SQL += string.Format(" and a.cInvCode like '{0}%' ",cInvCode); } if (!string.IsNullOrEmpty(cInvName)) { SQL += string.Format(" and a.cInvName like '%{0}%' ", cInvName); } if (!string.IsNullOrEmpty(cBarCode)) { SQL += string.Format(" and a.cBarCode like '{0}%' ", cBarCode); } DataSet ds = new DataSet (); int reuslt = OperationSql.GetDataset(SQL, connectionString,out ds, out errMsg); if (reuslt != 0) { return -2; } else { if (ds.Tables[0].Rows.Count == 0) { errMsg = "数据错误"; return -2; } else { clist = new List<CodebarLabel>(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { CodebarLabel cl = new CodebarLabel(); cl.CInvCode = ds.Tables[0].Rows[i][0].ToString(); cl.CInvName = ds.Tables[0].Rows[i][1].ToString(); cl.Cstandard = ds.Tables[0].Rows[i][2].ToString(); //cl.Ccolor = ds.Tables[0].Rows[i][3].ToString(); cl.Comunitname = ds.Tables[0].Rows[i][4].ToString(); //cl.Qty = ds.Tables[0].Rows[i][5].Equals(DBNull.Value) ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i][5]); //cl.Cartonsize = ds.Tables[0].Rows[i][6].Equals(DBNull.Value) ? string.Empty : ds.Tables[0].Rows[i][6].ToString(); cl.Weight = ds.Tables[0].Rows[i][7].Equals(DBNull.Value) ? 0.0 : Convert.ToDouble(ds.Tables[0].Rows[i][7]); cl.IInvSCost = ds.Tables[0].Rows[i][8].Equals(DBNull.Value) ? 0.0 : Convert.ToDouble(ds.Tables[0].Rows[i][8]); cl.IInvSaleCost = ds.Tables[0].Rows[i][9].Equals(DBNull.Value) ? 0.0 : Convert.ToDouble(ds.Tables[0].Rows[i][9]); cl.CAddress = ds.Tables[0].Rows[i][10].Equals(DBNull.Value) ? string.Empty : ds.Tables[0].Rows[i][10].ToString(); cl.CBarCode = ds.Tables[0].Rows[i][11].ToString(); cl.CMassUnit = ds.Tables[0].Rows[i][12] == DBNull.Value ? 2 : Convert.ToInt32(ds.Tables[0].Rows[i][12]);//保质期单位 cl.IMassDate = ds.Tables[0].Rows[i][13] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i][13]);//保质期天数 cl.Cquantity = 1; clist.Add(cl); } return 0; } } } catch (Exception ex) { errMsg = ex.Message; return -1; } }
public static int GetClsInv(string connectionString, string classCode, out List<CodebarLabel> cllist, out string errMsg) { cllist = null; errMsg = ""; try { string SQL = "select a.cInvCode,a.cInvName,a.cInvStd,a.cInvDefine1,b.cComUnitName, a.cInvDefine11, a.cInvDefine2, a.cInvDefine13, a.iInvSCost, a.fRetailPrice, a.cAddress,a.cBarCode,a.cMassUnit,a.iMassDate " + " from inventory a left join ComputationUnit b" + " on a.cComUnitCode = b.cComUnitCode" + " where a.cInvCCode = '" + classCode + "'"; DataSet Ds_Inv = new DataSet(); int r = OperationSql.GetDataset(SQL, connectionString, out Ds_Inv, out errMsg); if (r != 0) { return -2; } else { if (Ds_Inv.Tables[0].Rows.Count == 0) { errMsg = "数据错误"; return -2; } else { cllist = new List<CodebarLabel>(); for (int i = 0; i < Ds_Inv.Tables[0].Rows.Count; i++) { CodebarLabel cl = new CodebarLabel(); cl.CInvCode = Ds_Inv.Tables[0].Rows[i][0].ToString(); cl.CInvName = Ds_Inv.Tables[0].Rows[i][1].ToString(); cl.Cstandard = Ds_Inv.Tables[0].Rows[i][2].ToString(); //cl.Ccolor = Ds_Inv.Tables[0].Rows[i][3].ToString(); cl.Comunitname = Ds_Inv.Tables[0].Rows[i][4].ToString(); //cl.Qty = Ds_Inv.Tables[0].Rows[i][5].Equals(DBNull.Value) ? 0 : Convert.ToInt32(Ds_Inv.Tables[0].Rows[i][5]); //cl.Cartonsize = Ds_Inv.Tables[0].Rows[i][6].Equals(DBNull.Value) ? string.Empty : Ds_Inv.Tables[0].Rows[i][6].ToString(); cl.Weight = Ds_Inv.Tables[0].Rows[i][7].Equals(DBNull.Value) ? 0.0 : Convert.ToDouble(Ds_Inv.Tables[0].Rows[i][7]); cl.IInvSCost = Ds_Inv.Tables[0].Rows[i][8].Equals(DBNull.Value) ? 0.0 : Convert.ToDouble(Ds_Inv.Tables[0].Rows[i][8]); cl.IInvSaleCost = Ds_Inv.Tables[0].Rows[i][9].Equals(DBNull.Value) ? 0.0 : Convert.ToDouble(Ds_Inv.Tables[0].Rows[i][9]); cl.CAddress = Ds_Inv.Tables[0].Rows[i][10].Equals(DBNull.Value) ? string.Empty : Ds_Inv.Tables[0].Rows[i][10].ToString(); cl.CBarCode = Ds_Inv.Tables[0].Rows[i][11].ToString();//条码 cl.CMassUnit = Ds_Inv.Tables[0].Rows[i][12] == DBNull.Value ? 2 : Convert.ToInt32(Ds_Inv.Tables[0].Rows[i][12]);//保质期单位 cl.IMassDate = Ds_Inv.Tables[0].Rows[i][13] == DBNull.Value ? 0 : Convert.ToInt32(Ds_Inv.Tables[0].Rows[i][13]);//保质期天数 cl.Cquantity = 1; cllist.Add(cl); } return 0; } } } catch (Exception ex) { errMsg = ex.Message; return -1; } }