/// <summary> /// 添加数据 /// </summary> /// <param name="Item">model</param> /// <returns>"0101"表示成功,"0"表示失败</returns> public static string Insert(D_BaseModel Item) { DataBase db = new DataBase(); DataBaseVisitor visitor = new D_BaseVisitor(); bool bSuc = false; int nEffectRows = 0; SqlParameter[] prams ={ db.MakeInParam("@ID", SqlDbType.BigInt,50, PublicFun.PublicFun.MaxId("D_Base")), db.MakeInParam("@Code", SqlDbType.VarChar,50, Item.ParentCode+Item.CodeID), db.MakeInParam("@CodeID", SqlDbType.VarChar,50, Item.CodeID), db.MakeInParam("@Name", SqlDbType.VarChar,50, Item.Name), db.MakeInParam("@Rem", SqlDbType.VarChar,50, Item.Rem), db.MakeInParam("@ParentCode", SqlDbType.VarChar,50, Item.ParentCode), }; try { bSuc = db.TransactSql(visitor, "Insert", prams, out nEffectRows); } catch (Exception ex) { throw new Exception(ex.Message); } finally { db.Dispose(); } if (bSuc && nEffectRows > 0) return "0101"; else return "0"; }
//绑定基础信息类 private void BindBasicItem() { Item = new D_BaseModel(); Item.ID = this.Id; Item.CodeID = this.Tb_Code.Text.Trim(); Item.Name = this.Tb_Name.Text.Trim(); Item.ParentCode = this.Lb_BaseInfo.SelectedValue.ToString(); Item.Rem = this.Tb_Rem.Text.Trim(); }
//清除所有绑定 private void ClearBind() { this.Tb_Code.ReadOnly = false; this.Tb_Code.Text = ""; this.Tb_Name.Text = ""; this.Tb_Rem.Text = ""; this.Id = 0; Item = new D_BaseModel(); }