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="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="bill"></param>
/// <param name="msg"></param>
/// <returns></returns>
public static bool SaveBill(DBJhBill bill, out string msg)
{
if (bill.ID == Guid.Empty)
{
return(InsertBill(bill, out msg));
}
else
{
return(UpdateBill(bill, 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>
/// <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));
}
private void button_2_Click(object sender, EventArgs e)
{
if (dgBillMx.CurrentRowIndex >= 0)
{
DBJhBill bill = (DBJhBill)dBJhBillBindingSource.Current;
StringBuilder strBuilder = new StringBuilder();
strBuilder.AppendFormat("是否删除【{0}】{1}", new string[] { bill.Barcode, bill.PluName });
if (MessageBox.Show(strBuilder.ToString(), "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
string msg;
if (!JhBillDAL.DeleteBill(bill, out msg))
{
MessageBox.Show("删除失败：" + msg);
}
else
{
jhBill.RemoveAt(jhBill.FindIndex(a => a.ID == bill.ID));
dBJhBillBindingSource.ResetBindings(true);
}
}
}
}
/// <summary>
/// 更新验收单明细
/// </summary>
/// <param name="bill"></param>
/// <param name="msg"></param>
/// <returns></returns>
public static bool UpdateBill(DBJhBill bill, out string msg)
{
int i = 0;
if (bill.SerialNo == 0)
{
if (!GetMaxSerialNo(out i, out msg))
{
return(false);
}
else
{
bill.SerialNo = ++i;
}
}
if (!DBTool.Update(bill, out i, out msg))
{
return(false);
}
else
{
return(i > 0);
}
}
/// <summary>
/// 删除验收单明细
/// </summary>
/// <param name="bill"></param>
/// <param name="msg"></param>
/// <returns></returns>
public static bool DeleteBill(DBJhBill bill, out string msg)
{
int i;
return(DBTool.Delete(bill, out i, out msg));
}
private void button_4_Click(object sender, EventArgs e)
{
JhPlu = null;
this.DialogResult = DialogResult.OK;
}
