/// <summary> /// 保存盘点数据 /// </summary> /// <param name="pdData"></param> /// <param name="msg"></param> /// <returns></returns> public static bool SavePdData(DBPdData pdData, out string msg) { if (pdData.ID == Guid.Empty) { return(InsertPdData(pdData, out msg)); } return(UpdatePdData(pdData, out msg)); }
/// <summary> /// 插入盘点数据 /// </summary> /// <param name="bill"></param> /// <param name="msg"></param> /// <returns></returns> private static bool InsertPdData(DBPdData bill, out string msg) { int num; if (!GetMaxSerialNo(out num, out msg)) { return(false); } bill.SerialNo = ++num; bill.ID = Guid.NewGuid(); if (!BaseDAL.DBTool.Insert <DBPdData>(bill, out num, out msg)) { return(false); } return(num > 0x0); }
/// <summary> /// 更新盘点数据 /// </summary> /// <param name="bill"></param> /// <param name="msg"></param> /// <returns></returns> public static bool UpdatePdData(DBPdData bill, out string msg) { int i = 0; if (bill.SerialNo == 0) { if (!GetMaxSerialNo(out i, out msg)) { return(false); } bill.SerialNo = ++i; } if (!BaseDAL.DBTool.Update <DBPdData>(bill, out i, out msg)) { return(false); } return(i > 0); }
private void button_2_Click(object sender, EventArgs e) { if (dgBillMx.CurrentRowIndex >= 0) { DBPdData pdData = (DBPdData)dBPdDataBindingSource.Current; StringBuilder strBuilder = new StringBuilder(); strBuilder.AppendFormat("是否删除【{0}】{1}", new string[] { pdData.Barcode, pdData.PluName }); if (MessageBox.Show(strBuilder.ToString(), "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { string msg; if (!PdDataDAL.DeletePdData(pdData, out msg)) { MessageBox.Show("删除失败:" + msg); } else { pdDatas.RemoveAt(pdDatas.FindIndex(a => a.ID == pdData.ID)); dBPdDataBindingSource.ResetBindings(true); } } } }
/// <summary> /// 查询盘点数据 /// </summary> /// <param name="PluID"></param> /// <param name="pdData"></param> /// <param name="msg"></param> /// <returns></returns> public static bool GetPdData(string pluID, out DBPdData pdData, out string msg) { SQLiteDataReader reader; if (!BaseDAL.DBTool.Select <DBPdData>("PluID=@PluID", new DBPdData() { PluID = pluID }, string.Empty, out reader, out msg)) { pdData = null; return(false); } ICollection <DBPdData> source = BaseDAL.ObjTool.BuildObject <DBPdData>(reader); reader.Close(); if (source.Count > 0) { pdData = source.First <DBPdData>(); return(true); } msg = "未查询到盘点信息"; pdData = null; return(false); }
/// <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)); }
private void button_4_Click(object sender, EventArgs e) { PdPlu = null; this.DialogResult = DialogResult.Cancel; }