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