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