private void Update(Dictionary <string, object> dicPar)
{
//要检测的参数信息
List <string> pra = new List <string>()
{
"GUID", "USER_ID", "Id", "BusCode", "StoCode", "RoleId", "UserId", "RealName", "EmpCode", "RoleDisCount"
};
//检测方法需要的参数
if (!CheckActionParameters(dicPar, pra))
{
return;
}
//获取参数信息
string GUID = dicPar["GUID"].ToString();
string USER_ID = dicPar["USER_ID"].ToString();
string Id = dicPar["Id"].ToString();
string BusCode = dicPar["BusCode"].ToString();
string StoCode = dicPar["StoCode"].ToString();
string RoleId = dicPar["RoleId"].ToString();
string UserId = dicPar["UserId"].ToString();
string RealName = dicPar["RealName"].ToString();
//调用逻辑
TB_UserRoleEntity UEntity = bll.GetEntitySigInfo(" where id=" + Id);
UEntity.RealName = RealName;
bll.Update(GUID, USER_ID, UEntity);
ReturnResultJson(bll.oResult.Code, bll.oResult.Msg);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(string GUID, string UID, TB_UserRoleEntity UEntity)
{
//更新数据
int result = dal.Update(UEntity);
//检测执行结果
CheckResult(result, "");
}
/// <summary>
/// 单行数据转实体对象
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private TB_UserRoleEntity SetEntityInfo(DataRow dr)
{
TB_UserRoleEntity Entity = new TB_UserRoleEntity();
Entity.Id = StringHelper.StringToLong(dr["Id"].ToString());
Entity.BusCode = dr["BusCode"].ToString();
Entity.StoCode = dr["StoCode"].ToString();
Entity.RoleId = StringHelper.StringToLong(dr["RoleId"].ToString());
Entity.UserId = StringHelper.StringToLong(dr["UserId"].ToString());
Entity.RealName = dr["RealName"].ToString();
return(Entity);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(TB_UserRoleEntity Entity)
{
StringBuilder sql = new StringBuilder();
sql.Append(" declare @returnval int;");
sql.Append(" set @returnval=0;");
sql.Append("declare @BusCode varchar(16);");
sql.Append("declare @StoCode varchar(8);");
sql.Append("declare @RoleId varchar(1024);");
sql.Append("declare @UserId bigint;");
sql.Append("declare @RealName nvarchar(32);");
sql.Append("declare @EmpCode varchar(16);");
sql.Append(" set @BusCode='" + Entity.BusCode + "';");
sql.Append(" set @StoCode='" + Entity.StoCode + "';");
sql.Append(" set @RoleId='" + Entity.RoleId + "';");
sql.Append(" set @UserId=" + Entity.UserId + ";");
sql.Append(" set @RealName='" + Entity.RealName + "';");
sql.Append(" IF NOT EXISTS(Select 1 from [dbo].TB_UserRole Where userid=@UserId)");
sql.Append(" BEGIN ");
sql.Append(" BEGIN TRANSACTION tran1");
sql.Append(" exec dbo.p_uploaddata_isSync @BusCode,@StoCode,'TB_UserRole','userid',@UserId,'add';");
sql.Append(" insert into TB_UserRole ([buscode],[stocode],userid,roleid,realname,empcode,CTime)SELECT @BusCode,@StoCode,@UserId,col,@RealName,@EmpCode,getdate() FROM [dbo].[fn_StringSplit](@RoleId,',');");
sql.Append(" IF(@@ERROR=0) BEGIN COMMIT TRAN tran1;set @returnval=0;END ELSE BEGIN ROLLBACK TRAN tran1; set @returnval=1; END ");
sql.Append(" END");
sql.Append(" else ");
sql.Append(" BEGIN ");
sql.Append(" BEGIN TRANSACTION tran1");
sql.Append(" exec dbo.p_uploaddata_isSync @BusCode,@StoCode,'TB_UserRole','userid',@UserId,'update';");
sql.Append(" DELETE FROM TB_UserRole where userid=@UserId; delete TB_UserSigScheme where buscode=@buscode and stocode=@stocode and usercode=@UserId;");
sql.Append(" insert into TB_UserRole ([buscode],[stocode],userid,roleid,realname,empcode,CTime)SELECT @BusCode,@StoCode,@UserId,col,@RealName,@EmpCode,getdate() FROM [dbo].[fn_StringSplit](@RoleId,',');");
sql.Append(" IF(@@ERROR=0) BEGIN COMMIT TRAN tran1;set @returnval=0;END ELSE BEGIN ROLLBACK TRAN tran1; set @returnval=1; END ");
sql.Append(" END ");
sql.Append(" select @returnval;");
DataTable dt = DBHelper.ExecuteDataTable(sql.ToString());
if (dt != null && dt.Rows.Count > 0)
{
return(StringHelper.StringToInt(dt.Rows[0][0].ToString()));
}
else
{
return(2);
}
}
/// <summary>
/// 检验表单数据
/// </summary>
/// <returns></returns>
public bool CheckPageInfo(string type, string Id, string BusCode, string StoCode, string StrRoleId, string UserId, string RealName, string EmpCode, string RoleDisCount)
{
bool rel = false;
try
{
Entity = new TB_UserRoleEntity();
Entity.Id = StringHelper.StringToLong(Id);
Entity.BusCode = BusCode;
Entity.StoCode = StoCode;
Entity.StrRoleId = StringHelper.ReplaceString(StrRoleId);
Entity.UserId = StringHelper.StringToLong(UserId);
Entity.RealName = RealName;
rel = true;
}
catch (System.Exception)
{
}
return(rel);
}
