public static bool GetBill(string PLUID, out DBJhBill bill, out string msg) { SQLiteDataReader rd; if (!DBTool.Select("PluID=@PluID", new DBJhBill() { PluID = PLUID }, string.Empty, out rd, out msg)) { bill = null; return(false); } ICollection <DBJhBill> list = ObjTool.BuildObject <DBJhBill>(rd); rd.Close(); if (list.Count > 0) { bill = list.First(); return(true); } else { msg = "未查询到采购信息"; bill = null; return(false); } }
/// <summary> /// 获取付款流水 /// </summary> /// <param name="payList"></param> /// <param name="msg"></param> /// <returns></returns> public static bool GetSalSalePay(out List <TSalSalePay> payList, out string msg) { SQLiteDataReader rd; if (!DBTool.Select(string.Empty, new DBSalSalePay(), string.Empty, out rd, out msg)) { payList = null; return(false); } payList = new List <TSalSalePay>(); while (rd.Read()) { TSalSalePay pay = new TSalSalePay(); pay.ORGCODE = Convert.ToString(rd["OrgCode"]); pay.SALENO = Convert.ToString(rd["SaleNo"]); pay.SERIALNO = Convert.IsDBNull(rd["SerialNo"]) ? "0" : rd["SerialNo"].ToString(); pay.SSTOTAL = Convert.IsDBNull(rd["SsTotal"]) ? "0" : rd["SsTotal"].ToString(); pay.VIPNO = Convert.ToString(rd["VipNo"]); pay.ZFCODE = Convert.ToString(rd["ZfCode"]); pay.ZFNO = Convert.ToString(rd["ZfNo"]); pay.ZFTOTAL = string.IsNullOrEmpty(rd["ZfTotal"].ToString()) ? "0" : rd["ZfTotal"].ToString(); payList.Add(pay); } rd.Close(); return(true); }
///// <summary> ///// 获取指定采购单明细 ///// </summary> ///// <param name="code"></param> ///// <param name="PackUnit"></param> ///// <param name="PackQty"></param> ///// <param name="bill"></param> ///// <param name="msg"></param> ///// <returns></returns> //public static bool GetBill(int ToSerialNo, out DBJhBill bill, out string msg) //{ // SQLiteDataReader rd; // if (!DBTool.Select(" ToSerialNo=@ToSerialNo ", new DBJhBill() { ToSerialNo = ToSerialNo }, string.Empty, out rd, out msg)) // { // bill = null; // return false; // } // if (rd.Read()) // { // int i; // if(!GetMaxSerialNo(out i,out msg)) // { // //取SerialNo失败 // rd.Close(); // bill = null; // return false; // } // bill = new DBJhBill(); // bill.ID = new Guid(Convert.ToString(rd["ID"])); // bill.Barcode = Convert.ToString(rd["Barcode"]); // bill.BillNo = Convert.ToString(rd["BillNo"]); // bill.CgCount = Convert.ToDecimal(rd["CgCount"]); // bill.Checked = Convert.ToString(rd["Checked"]); // bill.LrDate = Convert.ToDateTime(rd["LrDate"]); // bill.LrUser = Convert.ToString(rd["LrUser"]); // bill.CgPackCount = Convert.ToDecimal(rd["CgPackCount"]); // bill.SsPackCount = Convert.ToDecimal(rd["SsPackCount"]); // bill.PackQty = Convert.ToDecimal(rd["PackQty"]); // bill.PackUnit = Convert.ToString(rd["PackUnit"]); // bill.PluCode = Convert.ToString(rd["PluCode"]); // bill.PluID = Convert.ToString(rd["PluID"]); // bill.PluName = Convert.ToString(rd["PluName"]); // bill.SerialNo = i++; // bill.ToSerialNo = Convert.ToInt16(rd["ToSerialNo"]); // bill.CgSGLCount = Convert.ToDecimal(rd["CgSGLCount"]); // bill.SsSGLCount = Convert.ToDecimal(rd["SsSGLCount"]); // bill.Spec = Convert.ToString(rd["Spec"]); // bill.SsCount = Convert.ToDecimal(rd["SsCount"]); // bill.Unit = Convert.ToString(rd["Unit"]); // return true; // } // else // { // msg = "未查询到采购信息"; // bill = null; // return false; // } //} /// <summary> /// 获取指定采购单明细 /// </summary> /// <param name="packet"></param> /// <param name="bill"></param> /// <param name="msg"></param> /// <returns></returns> public static bool GetBill(string Code, TPacket packet, out DBJhBill bill, out string msg) { SQLiteDataReader rd; if (!DBTool.Select("PluCode=@PluCode And PackQty=@PackQty And PackUnit=@PackUnit", new DBJhBill() { PluCode = Code, PackQty = decimal.Parse(packet.PACKQTY), PackUnit = packet.PACKUNIT }, string.Empty, out rd, out msg)) { bill = null; return(false); } ICollection <DBJhBill> list = ObjTool.BuildObject <DBJhBill>(rd); rd.Close(); if (list.Count > 0) { bill = list.First(); return(true); } else { msg = "未查询到采购信息"; bill = null; return(false); } }
/// <summary> /// 列表验收单 /// </summary> /// <param name="jhBill"></param> /// <param name="msg"></param> /// <returns></returns> public static bool ListBill(out List <DBJhBill> jhBill, out string msg) { SQLiteDataReader rd; if (!DBTool.Select(string.Empty, new DBJhBill(), "Checked Desc", out rd, out msg)) { jhBill = null; return(false); } jhBill = new List <DBJhBill>(); jhBill.AddRange(ObjTool.BuildObject <DBJhBill>(rd)); rd.Close(); return(true); }
/// <summary> /// 从单据中获取Plu信息 /// </summary> /// <param name="code"></param> /// <param name="plus"></param> /// <param name="msg"></param> /// <returns></returns> public static bool QueryPluFromBill(string code, out List <TRFQueryPlu> plus, out string msg) { SQLiteDataReader rd; if (!DBTool.Select(" Barcode=@Barcode Or PluCode=@PluCode ", new DBJhBill() { Barcode = code, PluCode = code }, string.Empty, out rd, out msg)) { plus = null; return(false); } plus = new List <TRFQueryPlu>(); while (rd.Read()) { if (plus.Count == 0) { //添加当前商品 TRFQueryPlu plu = new TRFQueryPlu(); plu.BARCODE = Convert.ToString(rd["Barcode"]); plu.PLUCODE = Convert.ToString(rd["PluCode"]); plu.PLUID = Convert.ToString(rd["PluID"]);; plu.PLUNAME = Convert.ToString(rd["PluName"]); plu.SPEC = Convert.ToString(rd["Spec"]); plu.UNIT = Convert.ToString(rd["Unit"]); plu.Packets = new List <TPacket>(); plus.Add(plu); } if (Convert.ToDecimal(rd["PackQty"]) != 0) { TPacket packet = new TPacket(); packet.PACKETID = Convert.ToInt16(rd["ToSerialNo"]).ToString();//将SerialNo当作包装ID packet.PACKQTY = Convert.ToDecimal(rd["PackQty"]).ToString("F2"); packet.PACKUNIT = Convert.ToString(rd["PackUnit"]); plus[0].Packets.Add(packet); } } rd.Close(); if (plus.Count > 0) { return(true); } else { msg = "采购单中未找到该商品。"; plus = null; return(false); } }
/// <summary> /// 读取省份表 /// </summary> /// <param name="provinceMap"></param> /// <param name="msg"></param> /// <returns></returns> public static bool LoadProvince(out Hashtable provinceMap, out string msg) { provinceMap = new Hashtable(); SQLiteDataReader rd; if (!DBTool.Select(string.Empty, new DBProvince(), string.Empty, out rd, out msg)) { return(false); } else { while (rd.Read()) { provinceMap.Add(rd["Index"], rd["Province"]); } rd.Close(); return(true); } }
/// <summary> /// 获取下一个流水号 /// </summary> /// <param name="ObjName"></param> /// <param name="no"></param> /// <param name="msg"></param> /// <returns></returns> public static bool GetNextNo <T>(out int no, out string msg) { string _ObjName = typeof(T).Name; SQLiteDataReader rd; switch (_ObjName) { case "DBPdData": if (!DBTool.Select("ObjName=@ObjName And LastDate=@LastDate", new DBNextNo() { ObjName = _ObjName, LastDate = DateTime.Today }, string.Empty, out rd, out msg)) { no = -1; return(false); } else { if (rd.Read()) { no = Convert.ToInt16(rd["LastNo"]) + 1; } else { no = 1; } rd.Close(); return(true); } default: no = -1; msg = "错误:不存在对象"; return(false); } }