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