/// <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);
}
}
/// <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="bill">明细</param>
/// <param name="msg">返回的消息</param>
/// <returns>是否成功</returns>
public static bool DeleteBill(DBCgBill bill, out string msg)
{
int i;
return(DBTool.Delete(bill, 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));
}
/// <summary>
/// 删除盘点数据
/// </summary>
/// <param name="pdData"></param>
/// <param name="msg"></param>
/// <returns></returns>
public static bool DeletePdData(DBPdData pdData, out string msg)
{
int num;
return(DBTool.Delete <DBPdData>(pdData, out num, out msg));
}
