/// <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));
}