private void btnAdd_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txtItem.Text))
{
MessageBox.Show("请先输入物料的特征码!");
}
else
{
var ss = this.txtItem.Text.Split("\r\n".ToCharArray(),StringSplitOptions.RemoveEmptyEntries);
foreach (var s in ss)
{
var sa = s.Split("\t".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
if (this.Items.Exists(item => item.ItemName.Equals(sa[0].Trim(), StringComparison.OrdinalIgnoreCase)))
{
// MessageBox.Show("输入的物料特征码已经存在了！");
}
else
{
var obj = new ItemInfo();
obj.ItemName = sa[0].Trim();
obj.OldItemName = obj.ItemName;
if(sa.Length>2)
{
obj.d = int.Parse(sa[1]);
obj.c = int.Parse(sa[2]);
}
else
{
obj.d = 0;
}
if (DataRepository.ItemProvider.Insert(obj, null))
{
this.Items.Add(obj);
if (obj.c == 1)
this.lbItem.Items.Add(string.Format("{0}|{1}", obj.ItemName, obj.d));
else if (obj.c == 2)
this.lbBCL.Items.Add(string.Format("{0}|{1}", obj.ItemName, obj.d));
}
}
}
}
}
/// <summary>
/// 将dr转变到保险理赔单实体。
/// </summary>
/// <param name="dr"></param>
/// <returns>保险理赔单实体。</returns>
private static ItemInfo ConvertToItemInfo(IDataRecord dr)
{
var obj = new ItemInfo();
obj.OldItemName = obj.ItemName = dr["ItemName"].ToString();
obj.d = dr["d"] == DBNull.Value ? 0 : decimal.Parse(dr["d"].ToString());
obj.c = dr["c"] == DBNull.Value ? 0 : int.Parse(dr["c"].ToString());
return obj;
}
public override bool Update(ItemInfo obj, TransactionManager trans)
{
var sqlStatement = "Update Item Set ItemName = @ItemName,d=@d,c=@c Where ItemName = @OldItemName";
var parms = new[] {
new OleDbParameter("@ItemName",OleDbType.VarWChar,50){Value = obj.ItemName},
new OleDbParameter("@OldItemName",OleDbType.VarWChar,50){Value = obj.OldItemName},
new OleDbParameter("@d",OleDbType.Decimal){Value = obj.d ==0?DBNull.Value:(object)obj.d},
new OleDbParameter("@c",OleDbType.Integer){Value = obj.c==0?DBNull.Value:(object)obj.c},
};
try
{
if (trans == null)
AccessHelper.ExecuteNonQuery(this.ConnectionString, sqlStatement, parms);
else
AccessHelper.ExecuteNonQuery(trans.TransactionObject as OleDbTransaction, sqlStatement, parms);
return true;
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
return false;
}
}
