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