/// <summary>
/// 修改状态
/// </summary>
/// <param name="dicPar"></param>
private void UpdateStatus(Dictionary <string, object> dicPar)
{
///要检测的参数信息
List <string> pra = new List <string>()
{
"GUID", "userid", "ids", "tstatus"
};
//检测方法需要的参数
if (!CheckActionParameters(dicPar, pra))
{
return;
}
//获取参数信息
string GUID = dicPar["GUID"].ToString();
string userid = dicPar["userid"].ToString();
string ids = dicPar["ids"].ToString();
string status = dicPar["tstatus"].ToString();
string Id = dicPar["ids"].ToString().Trim(',');
TB_RolesEntity UEntity = bll.GetEntitySigInfo(" where id=" + Id);
UEntity.TStatus = status;
bll.Update(GUID, userid, UEntity, "");
ReturnResultJson(bll.oResult.Code, bll.oResult.Msg);
}
/// <summary>
/// 检验表单数据
/// </summary>
/// <returns></returns>
public bool CheckPageInfo(string type, string Id, string BusCode, string StoCode, string CCname, string TStatus, string UCname, string SCope, string RoleName, string RoleParent, string RoleDescr, string RoleDisCount, string RoleEnable, string MaxDiffPrice, string MaxPrefePrice, string IsSig, string Sigcredit, string RoleType, string TerminalType, string CCode, string UCode)
{
bool rel = false;
try
{
Entity = new TB_RolesEntity();
Entity.Id = StringHelper.StringToLong(Id);
Entity.BusCode = BusCode;
Entity.StoCode = StoCode;
Entity.CCode = CCode;
Entity.CCname = CCname;
Entity.TStatus = TStatus;
Entity.RoleName = RoleName;
Entity.RoleParent = StringHelper.StringToInt(RoleParent);
Entity.RoleDescr = RoleDescr;
Entity.RoleEnable = RoleEnable;
Entity.RoleType = RoleType;
rel = true;
}
catch (System.Exception)
{
}
return(false);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(string GUID, string UID, TB_RolesEntity UEntity, string FunctionIds)
{
//获取更新前的数据对象
string[] FunList = null;
if (!string.IsNullOrEmpty(FunctionIds))
{
FunList = FunctionIds.Split(',');
}
//更新数据
int result = dal.Update(UEntity, FunList);
//检测执行结果
CheckResult(result, "");
}
/// <summary>
/// 单行数据转实体对象
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private TB_RolesEntity SetEntityInfo(DataRow dr)
{
TB_RolesEntity Entity = new TB_RolesEntity();
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.TStatus = dr["TStatus"].ToString();
Entity.RoleName = dr["RoleName"].ToString();
Entity.RoleParent = StringHelper.StringToInt(dr["RoleParent"].ToString());
Entity.RoleDescr = dr["RoleDescr"].ToString();
Entity.RoleEnable = dr["RoleEnable"].ToString();
Entity.RoleType = dr["RoleType"].ToString();
return(Entity);
}
private void Update(Dictionary <string, object> dicPar)
{
//要检测的参数信息
List <string> pra = new List <string>()
{
"GUID", "userid", "Id", "BusCode", "RoleName", "RoleDescr", "RoleEnable", "RoleType", "FunctionIds"
};
//检测方法需要的参数
if (!CheckActionParameters(dicPar, pra))
{
return;
}
//获取参数信息
string GUID = dicPar["GUID"].ToString();
string userid = dicPar["userid"].ToString();
string id = dicPar["Id"].ToString();
string RoleName = dicPar["RoleName"].ToString();
string RoleDescr = dicPar["RoleDescr"].ToString();
string RoleEnable = dicPar["RoleEnable"].ToString();
string RoleType = dicPar["RoleType"].ToString();
string FunctionIds = string.Empty;
if (dicPar["FunctionIds"] != null)
{
FunctionIds = dicPar["FunctionIds"].ToString().TrimEnd(',');
}
TB_RolesEntity UEntity = bll.GetEntitySigInfo(" where id=" + id);
UEntity.RoleName = RoleName;
UEntity.RoleEnable = RoleEnable;
UEntity.RoleType = RoleType;
UEntity.RoleDescr = RoleDescr;
//调用逻辑
bll.Update(GUID, userid, UEntity, FunctionIds);
ReturnResultJson(bll.oResult.Code, bll.oResult.Msg);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref TB_RolesEntity Entity, string[] FunList)
{
intReturn = 0;
StringBuilder Builder = new StringBuilder();
DataTable dtStructure = DBHelper.ExecuteDataTable("select top 0 * from TB_Roles ");
string InsertSql = string.Empty;
Builder.Append(" BEGIN TRAN tan1");
Builder.Append(" declare @roleid int;");
int rel = CheckRoleName(Entity.Id.ToString(), Entity.RoleName);
if (rel <= 0)
{
List <string> lstExcludeFilds = new List <string>(); //构造sql语句排除的字段
Dictionary <string, string> dicAttachFilds = new Dictionary <string, string>(); //构造语句（格式是：<字段名，字段值>）
Builder.AppendLine(" DECLARE @buscode varchar(16); DECLARE @stocode varchar(16); ");
Builder.AppendLine(" SET @buscode='" + Entity.BusCode + "';");
Builder.AppendLine(" SET @stocode='" + Entity.StoCode + "';");
Builder.AppendLine(" DECLARE @ID VARCHAR(20); SET @ID='';");
if (Entity.Id == 0)
{//添加
#region 添加
lstExcludeFilds.Clear();
lstExcludeFilds.Add("Id"); //methodsmid字段不在构造插入语句内
InsertSql = EntityHelper.GenerateSqlByDE <TB_RolesEntity>(dtStructure, Entity, lstExcludeFilds, dicAttachFilds, EntityHelper.eSqlType.insert); //构造sql语句
Builder.AppendFormat(" INSERT INTO TB_Roles " + InsertSql);
Builder.Append(" set @roleid=SCOPE_IDENTITY();");
Builder.AppendLine(" SET @ID=CONVERT(VARCHAR(20),@roleid); ");
Builder.AppendLine(" exec dbo.p_uploaddata_isSync @buscode,@stocode,'TB_Roles','id',@ID,'add'; ");
#endregion
}
else
{//修改
#region 修改
lstExcludeFilds.Clear();
lstExcludeFilds.Add("Id"); //methodsmid字段不在构造插入语句内
InsertSql = EntityHelper.GenerateSqlByDE <TB_RolesEntity>(dtStructure, Entity, lstExcludeFilds, dicAttachFilds, EntityHelper.eSqlType.update); //构造sql语句
Builder.AppendFormat(" update TB_Roles set " + InsertSql + " where id=" + Entity.Id.ToString());
Builder.Append(" set @roleid=" + Entity.Id.ToString() + ";");
Builder.AppendLine(" SET @ID=CONVERT(VARCHAR(20),@roleid); ");
Builder.AppendLine(" exec dbo.p_uploaddata_isSync @buscode,@stocode,'TB_Roles','id',@ID,'update'; ");
#endregion
}
#region 权限
Builder.Append(" delete TB_RoleFunction where roleid=@roleid;");
if (FunList != null && FunList.Length > 0)
{
for (int i = 0; i < FunList.Length; i++)
{
Builder.Append(string.Format(" insert into TB_RoleFunction (buscode,stocode,ccode,ccname,ctime,roleid,functionid) values ('{0}','{1}','{2}','{3}','{4}',@roleid,'{5}') ;", Entity.BusCode, Entity.StoCode, Entity.CCode, Entity.CCname, Entity.CTime, FunList[i].ToString()));
Builder.AppendLine(" SET @ID=CONVERT(VARCHAR(20),SCOPE_IDENTITY()); ");
Builder.AppendLine(" exec dbo.p_uploaddata_isSync @buscode,@stocode,'TB_RoleFunctio','id',@ID,'add'; ");
}
}
#endregion
Builder.Append(" if(@@error=0) begin commit tran tan1 end else begin rollback tran tran1 end");
return(DBHelper.ExecuteNonQuery(Builder.ToString()));
}
else
{
return(1);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(TB_RolesEntity Entity, string[] FunList)
{
return(Add(ref Entity, FunList));
}
