protected override SqlParameterDictionary GetParamsCollection(Right_Module m) { SqlParameterDictionary p = new SqlParameterDictionary(); p.Add("ID", SQLDatabase.MakeInParam("@ID", SqlDbType.Int, 4, m.ID)); p.Add("Name", SQLDatabase.MakeInParam("@Name", SqlDbType.VarChar, 50, m.Name)); p.Add("Remark", SQLDatabase.MakeInParam("@Remark", SqlDbType.VarChar, 200, m.Remark)); p.Add("SuperID", SQLDatabase.MakeInParam("@SuperID", SqlDbType.Int, 4, m.SuperID)); p.Add("SortValue", SQLDatabase.MakeInParam("@SortValue", SqlDbType.Int, 4, m.SortValue)); p.Add("EnableFlag", SQLDatabase.MakeInParam("@EnableFlag", SqlDbType.Char, 1, m.EnableFlag)); p.Add("Ico", SQLDatabase.MakeInParam("@Ico", SqlDbType.VarChar, 20, m.Ico)); return(p); }
protected override SqlParameterDictionary GetParamsCollection(Org_Position m) { SqlParameterDictionary p = new SqlParameterDictionary(); #region 定义数据表的列集合 p.Add("ID", SQLDatabase.MakeInParam("@ID", SqlDbType.Int, 4, m.ID)); p.Add("Name", SQLDatabase.MakeInParam("@Name", SqlDbType.VarChar, 50, m.Name)); p.Add("SuperID", SQLDatabase.MakeInParam("@SuperID", SqlDbType.Int, 4, m.SuperID)); p.Add("IsHeadOffice", SQLDatabase.MakeInParam("@IsHeadOffice", SqlDbType.Char, 1, m.IsHeadOffice)); p.Add("Remark", SQLDatabase.MakeInParam("@Remark", SqlDbType.VarChar, 200, m.Remark)); p.Add("Department", SQLDatabase.MakeInParam("@Department", SqlDbType.Int, 4, m.Department)); p.Add("Enabled", SQLDatabase.MakeInParam("@Enabled", SqlDbType.Char, 1, m.Enabled)); #endregion return(p); }
public override int Add(Org_Position m) { SqlParameterDictionary p = GetParamsCollection(m); SqlParameter[] parameters = { p["Name"], p["SuperID"], p["IsHeadOffice"], p["Remark"], p["Department"], p["Enabled"] }; return(SQLDatabase.RunProc(_ProcePrefix + "_Add", parameters)); }
public override int Update(Right_Module m) { SqlParameterDictionary p = GetParamsCollection(m); SqlParameter[] parms = { p["ID"], p["Name"], p["Remark"], p["SuperID"], p["SortValue"], p["EnableFlag"], p["Ico"] }; return(SQLDatabase.RunProc(_ProcePrefix + "_Update", parms)); }
/// <summary> /// 更新字典项目 /// </summary> /// <param name="m"></param> /// <returns></returns> public override int Update(Dictionary_Data m) { SqlParameterDictionary p = GetParamsCollection(m); SqlParameter[] prams = { p["ID"], p["Code"], p["Name"], p["Type"], p["Enabled"], p["Description"], p["UpdateStaff"] }; return(SQLDatabase.RunProc(_ProcePrefix + "_Update", prams)); }
protected override SqlParameterDictionary GetParamsCollection(Dictionary_Data m) { SqlParameterDictionary p = new SqlParameterDictionary(); p.Add("ID", SQLDatabase.MakeInParam("@ID", SqlDbType.UniqueIdentifier, 4, m.ID)); p.Add("Code", SQLDatabase.MakeInParam("@Code", SqlDbType.VarChar, 20, m.Code)); p.Add("Name", SQLDatabase.MakeInParam("@Name", SqlDbType.NVarChar, 50, m.Name)); p.Add("Type", SQLDatabase.MakeInParam("@Type", SqlDbType.Int, 4, m.Type)); p.Add("Enabled", SQLDatabase.MakeInParam("@Enabled", SqlDbType.Char, 1, m.Enabled)); p.Add("Description", SQLDatabase.MakeInParam("@Description", SqlDbType.NVarChar, 50, m.Description)); p.Add("InsertTime", SQLDatabase.MakeInParam("@InsertTime", SqlDbType.DateTime, 8, m.InsertTime)); p.Add("InsertStaff", SQLDatabase.MakeInParam("@InsertStaff", SqlDbType.NVarChar, 256, m.InsertStaff)); p.Add("UpdateTime", SQLDatabase.MakeInParam("@UpdateTime", SqlDbType.DateTime, 8, m.UpdateTime)); p.Add("UpdateStaff", SQLDatabase.MakeInParam("@UpdateStaff", SqlDbType.NVarChar, 256, m.UpdateStaff)); return(p); }