/// <summary>
/// 增加一条付款流水
/// </summary>
/// <param name="pay"></param>
/// <param name="msg"></param>
/// <returns></returns>
public static bool AddSalSalePay(List <TSalSalePay> payList, out string msg)
{
SQLiteTransaction tran;
int i;
if (!DBTool.BeginTransaction(out tran, out msg))
{
return(false);
}
foreach (TSalSalePay pay in payList)
{
DBSalSalePay DBPay = new DBSalSalePay();
DBPay.ID = Guid.NewGuid();
DBPay.LrDate = DateTime.Now;
DBPay.LrUser = PubGlobal.User.UserCode;
DBPay.OrgCode = PubGlobal.OrgCode;
DBPay.SaleNo = pay.SALENO;
DBPay.SerialNo = int.Parse(pay.SERIALNO);
DBPay.SsTotal = string.IsNullOrEmpty(pay.SSTOTAL) ? 0 : decimal.Parse(pay.SSTOTAL);
DBPay.VipNo = string.IsNullOrEmpty(pay.VIPNO) ? string.Empty : pay.VIPNO;
DBPay.ZfCode = pay.ZFCODE;
DBPay.ZfNo = string.IsNullOrEmpty(pay.ZFNO)?string.Empty:pay.ZFNO;
DBPay.ZfTotal = string.IsNullOrEmpty(pay.ZFTOTAL) ? 0 : decimal.Parse(pay.ZFTOTAL);
if (!DBTool.Insert(DBPay, tran, out i, out msg))
{
DBTool.RollbackTransaction(tran, out msg);//回滚
return(false);
}
}
return(DBTool.CommitTransaction(tran, out msg));
}
/// <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="bill"></param>
/// <param name="msg"></param>
/// <returns></returns>
public static bool InsertBill(DBJhBill bill, out string msg)
{
int i;
if (!GetMaxSerialNo(out i, out msg))
{
return(false);
}
bill.SerialNo = ++i;
bill.ID = Guid.NewGuid();
return(DBTool.Insert(bill, out i, out msg));
}
/// <summary>
/// 保存当前流水号
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="no"></param>
/// <param name="msg"></param>
/// <returns></returns>
public static bool SaveNextNo <T>(int no, out string msg)
{
string ObjName = typeof(T).Name;
DBNextNo nextNo = new DBNextNo();
nextNo.ObjName = ObjName;
nextNo.LastDate = DateTime.Today;
nextNo.LastNo = no;
int i;
DBTool.Delete(nextNo, out i, out msg);
return(DBTool.Insert(nextNo, out i, out msg));
}
/// <summary>
/// 插入采购单
/// </summary>
/// <param name="CgBill">采购单</param>
/// <param name="msg">返回的消息</param>
/// <returns>是否成功</returns>
public static bool AddBill(List <TRFQueryCgBill> CgBill, out string msg)
{
int i;
if (!RemoveJhBill(out msg))
{
msg = "移除验收单失败：" + msg;
return(false);
}
SQLiteTransaction tran;
if (!DBTool.BeginTransaction(out tran, out msg))
{
return(false);
}
foreach (TRFQueryCgBill bill in CgBill)
{
DBJhBill DBBill = new DBJhBill();
DBBill.ID = Guid.NewGuid();
DBBill.Barcode = bill.BARCODE;
DBBill.BillNo = string.Empty;
DBBill.CgCount = decimal.Parse(bill.CGCOUNT);
DBBill.Checked = "N";
DBBill.LrDate = DateTime.Now;
DBBill.LrUser = PubGlobal.User.UserCode;
DBBill.CgPackCount = decimal.Parse(bill.PACKCOUNT);
DBBill.PackQty = decimal.Parse(bill.PACKQTY);
DBBill.PackUnit = bill.PACKUNIT;
DBBill.PluCode = bill.PLUCODE;
DBBill.PluID = bill.PLUID;
DBBill.PluName = bill.PLUNAME;
DBBill.ToSerialNo = int.Parse(bill.SERIALNO);
DBBill.SerialNo = 0;
DBBill.CgSGLCount = decimal.Parse(bill.SGLCOUNT);
DBBill.Spec = bill.SPEC;
DBBill.SsCount = 0;
DBBill.Unit = bill.UNIT;
if (!DBTool.Insert(DBBill, tran, out i, out msg))
{
DBTool.RollbackTransaction(tran, out msg);
msg = "存储采购单失败。";
return(false);
}
}
return(DBTool.CommitTransaction(tran, out msg));
}