/// <summary> /// 获取最大序号 /// </summary> /// <param name="i"></param> /// <param name="msg"></param> /// <returns></returns> public static bool GetMaxSerialNo(out int i, out string msg) { SQLiteDataReader rd; if (!DBTool.ExecSql("Select Max(SerialNo) Serial From tJhBill", out rd, out msg)) { i = -1; return(false); } if (rd.Read()) { if (Convert.IsDBNull(rd["Serial"])) { i = 0; } else { i = Convert.ToInt16(rd["Serial"]); } return(true); } else { i = 0; return(true); } }
/// <summary> /// 获取采购单最大编号 /// </summary> /// <param name="serialNo">获取的最大编号</param> /// <param name="msg">返回的消息</param> /// <returns>返回是否成功</returns> public static bool GetMasSerialNo(out int serialNo, out string msg) { SQLiteDataReader rd; if (!DBTool.ExecSql("Select Max(SerialNo) SerialNo From tCgBill", out rd, out msg)) { serialNo = -1; return(false); } else { if (rd.Read()) { if (Convert.IsDBNull(rd["SerialNo"])) { serialNo = 0; return(true); } serialNo = Convert.ToInt16(rd["SerialNo"]); rd.Close(); return(true); } else { serialNo = -1; rd.Close(); return(false); } } }
/// <summary> /// 获取要发送的采购明细 /// </summary> /// <param name="rst"></param> /// <param name="msg"></param> /// <returns></returns> public static bool GetSendCgBill(out DataSet rst, out string msg) { if (!DBTool.ExecSql("select BillNo,SerialNo,PLUID ,PACKUNIT,PACKQTY,PACKCOUNT , SGLCOUNT from tCgBill", out rst, out msg)) { rst = null; return(false); } return(true); }
/// <summary> /// 获取要发送的验收单明细 /// </summary> /// <param name="rst"></param> /// <param name="msg"></param> /// <returns></returns> public static bool GetSendJhBill(out DataSet rst, out string msg) { if (!DBTool.ExecSql("Select BILLNO,SERIALNO,TOSERIALNO,PLUID,PACKUNIT,PACKQTY, SsPACKCOUNT as PACKCOUNT, SsSGLCOUNT as SGLCOUNT ,ScDate as SCDATE From tJhBill Where Checked='Y'", out rst, out msg)) { rst = null; return(false); } return(true); }
/// <summary> /// 获取要发送的盘点单明细 /// </summary> /// <param name="rst"></param> /// <param name="msg"></param> /// <returns></returns> public static bool GetSendPdData(out DataSet rst, out string msg) { if (!DBTool.ExecSql("Select PDNO,SERIALNO,PLUID,SJCOUNT From tPdData", out rst, out msg)) { rst = null; return(false); } return(true); }
/// <summary> /// 开启验收单,保存验收单信息 /// </summary> /// <param name="billInfo"></param> /// <param name="msg"></param> /// <returns></returns> public static bool SaveJhBillInfo(DBJhBillInfo billInfo, out string msg) { int i; if (!DBTool.ExecSql(" Delete From tJhBillInfo ", out i, out msg)) { return(false); } return(DBTool.Insert(billInfo, out i, out msg)); }
/// <summary> /// 获取当前单据信息 /// </summary> /// <param name="msg">返回的消息</param> /// <returns>返回是否成功</returns> public static bool GetJhBillInfo(out DBJhBillInfo billInfo, out string msg) { SQLiteDataReader rd; if (!DBTool.ExecSql("Select * From tJhBillInfo ", out rd, out msg)) { billInfo = null; return(false); } ICollection <DBJhBillInfo> list = ObjTool.BuildObject <DBJhBillInfo>(rd); rd.Close(); if (list.Count > 0) { billInfo = list.First(); return(true); } else { msg = "未找到验收单信息。"; billInfo = null; return(false); } }
/// <summary> /// 移除流水 /// </summary> /// <param name="msg"></param> /// <returns></returns> public static bool RemoveSalSalePay(out string msg) { int i; return(DBTool.ExecSql("Delete From tSalSalePay", out i, out msg)); }
/// <summary> /// 清空采购明细 /// </summary> /// <param name="msg"></param> /// <returns></returns> public static bool RemoveCgBill(out string msg) { int i = 0; return(DBTool.ExecSql("Delete from tCgBill", out i, out msg)); }
/// <summary> /// 移除验收单 /// </summary> /// <param name="msg"></param> /// <returns></returns> public static bool RemoveJhBill(out string msg) { int i; return(DBTool.ExecSql("Delete From tJhBill;Delete From tJhBillInfo", out i, out msg)); }