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