/// <summary>
/// 更新一条数据
/// </summary>
public void Update(string GUID, string UID, TB_RoleFunctionEntity UEntity)
{
//更新数据
int result = dal.Update(UEntity);
//检测执行结果
CheckResult(result, "");
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(TB_RoleFunctionEntity Entity)
{
SqlParameter[] sqlParameters =
{
new SqlParameter("@Id", Entity.Id),
new SqlParameter("@BusCode", Entity.BusCode),
new SqlParameter("@StoCode", Entity.StoCode),
new SqlParameter("@CCode", Entity.CCode),
new SqlParameter("@CCname", Entity.CCname),
new SqlParameter("@RoleId", Entity.RoleId),
new SqlParameter("@FunctionId", Entity.FunctionId),
};
return(DBHelper.ExecuteNonQuery("dbo.p_TB_RoleFunction_Update", CommandType.StoredProcedure, sqlParameters));
}
/// <summary>
/// 单行数据转实体对象
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private TB_RoleFunctionEntity SetEntityInfo(DataRow dr)
{
TB_RoleFunctionEntity Entity = new TB_RoleFunctionEntity();
Entity.Id = StringHelper.StringToLong(dr["Id"].ToString());
Entity.BusCode = dr["BusCode"].ToString();
Entity.StoCode = dr["StoCode"].ToString();
Entity.CCode = dr["CCode"].ToString();
Entity.CCname = dr["CCname"].ToString();
Entity.RoleId = StringHelper.StringToLong(dr["RoleId"].ToString());
Entity.FunctionId = StringHelper.StringToLong(dr["FunctionId"].ToString());
return(Entity);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref TB_RoleFunctionEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@Id", Entity.Id),
new SqlParameter("@BusCode", Entity.BusCode),
new SqlParameter("@StoCode", Entity.StoCode),
new SqlParameter("@CCode", Entity.CCode),
new SqlParameter("@CCname", Entity.CCname),
new SqlParameter("@RoleId", Entity.RoleId),
new SqlParameter("@FunctionId", Entity.FunctionId),
};
sqlParameters[0].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_TB_RoleFunction_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.Id = int.Parse(sqlParameters[0].Value.ToString());
}
return(intReturn);
}
/// <summary>
/// 检验表单数据
/// </summary>
/// <returns></returns>
public bool CheckPageInfo(string type, string Id, string BusCode, string StoCode, string CCname, string RoleId, string FunctionId, string CCode)
{
bool rel = false;
try
{
Entity = new TB_RoleFunctionEntity();
Entity.Id = StringHelper.StringToLong(Id);
Entity.BusCode = BusCode;
Entity.StoCode = StoCode;
Entity.CCode = CCode;
Entity.CCname = CCname;
Entity.RoleId = StringHelper.StringToLong(RoleId);
Entity.FunctionId = StringHelper.StringToLong(FunctionId);
rel = true;
}
catch (System.Exception)
{
}
return(rel);
}
