/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.SysCodeRelation DataRowToModel(DataRow row)
{
Model.SysCodeRelation model=new Model.SysCodeRelation();
if (row != null)
{
if(row["AutoID"]!=null && row["AutoID"].ToString()!="")
{
model.AutoID=long.Parse(row["AutoID"].ToString());
}
if(row["SysCodeDetialID"]!=null)
{
model.SysCodeDetialID=row["SysCodeDetialID"].ToString();
}
if(row["SysCodeDetialIDEx"]!=null)
{
model.SysCodeDetialIDEx=row["SysCodeDetialIDEx"].ToString();
}
}
return model;
}
/// <summary>
/// 得到代码关联实体(顺序无关)
/// </summary>
/// <param name="SysCodeDetialID">小类编号1</param>
/// <param name="SysCodeDetialIDEx">小类编号2</param>
public Model.SysCodeRelation GetModel(string SysCodeDetialID, string SysCodeDetialIDEx)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select AutoID,SysCodeDetialID,SysCodeDetialIDEx from SysCodeRelation");
strSql.Append(" where (SysCodeDetialID=@SysCodeDetialID and SysCodeDetialIDEx=@SysCodeDetialIDEx) or " +
" (SysCodeDetialID=@SysCodeDetialIDEx and SysCodeDetialIDEx=@SysCodeDetialID) limit 1");
MySqlParameter[] parameters = {
new MySqlParameter("@SysCodeDetialID", MySqlDbType.VarChar, 50),
new MySqlParameter("@SysCodeDetialIDEx", MySqlDbType.VarChar, 50)
};
parameters[0].Value = SysCodeDetialID;
parameters[1].Value = SysCodeDetialIDEx;
Model.SysCodeRelation model = new Model.SysCodeRelation();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.SysCodeRelation GetModel(long AutoID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select AutoID,SysCodeDetialID,SysCodeDetialIDEx from SysCodeRelation");
strSql.Append(" where AutoID=@AutoID limit 1");
MySqlParameter[] parameters = {
new MySqlParameter("@AutoID", MySqlDbType.Int64)
};
parameters[0].Value = AutoID;
Model.SysCodeRelation model=new Model.SysCodeRelation();
DataSet ds=DbHelperMySQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
protected void Bt_Add_Click(object sender, EventArgs e)
{
string loginName = TB_LoginName.Text.Trim();
string password = TB_Password.Text.Trim();
string pwdCheck = TB_PwdCheck.Text.Trim();
string userName = TB_UserName.Text.Trim();
string employeeID = TB_EmployeeID.Text.Trim();
string matchPass_LoginName = @"^[a-z0-9A-Z_-]{1,20}$";
string matchPass_Password = @"^[a-z0-9A-Z_-]{7,20}$";
if (loginName == "" || !(Regex.IsMatch(loginName, matchPass_LoginName)))
{
RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c1", "OpenAlert('登录名必须为1-10个字符(可以包含英文、数字和下划线)！');", true);
return;
}
if (password == "" || !(Regex.IsMatch(password, matchPass_Password)))
{
RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c2", "OpenAlert('密码必须为7-20个字符(可以包含英文、数字和下划线)！');", true);
return;
}
if (password != pwdCheck)
{
RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c3", "OpenAlert('两次密码输入不一致！');", true);
return;
}
if (userName == "")
{
RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c4", "OpenAlert('姓名必须为1-50个字符！');", true);
return;
}
string roleId = RCB_Role.SelectedValue;
bool enable = RCB_Enable.SelectedItem.Value == "1" ? true : false;
Model.SysUser suModel = new Model.SysUser();
suModel.UserID = loginName;
suModel.Password = password;
suModel.UserName = userName;
suModel.EmployeeID = employeeID;
suModel.IsValid = enable;
SysUser su = new SysUser();
bool isAdd = false;
long scrAdd = 0;
Model.Log logModel = new Model.Log();
try
{
logModel.OperationItem = "添加用户";
logModel.Operator = user.UserInfo.UserID;
logModel.OperationTime = DateTime.Now;
logModel.OperationDetail = "登录名：" + loginName + " - 用户名：" + userName + " - 角色:" + RCB_Role.SelectedItem.Text;
isAdd = su.Add(suModel);
Model.SysCodeRelation scrModel = new Model.SysCodeRelation();
if (isAdd)
{
scrModel.SysCodeDetialID = loginName;
scrModel.SysCodeDetialIDEx = roleId;
scrAdd = scr.Add(scrModel);
}
if (isAdd && scrAdd!=0)
{
logModel.Memo = "成功";
}
else if (!isAdd)
{
logModel.Memo = "失败！";
}
else
{
logModel.Memo = "角色设置失败！";
}
}
catch (Exception ex)
{
logModel.Memo = "异常：" + ex.Message;
}
finally
{
log.Add(logModel);
if (isAdd && scrAdd!=0)
{
RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c5", "OpenAlert('恭喜！操作员\"" + loginName + "\"添加成功！');", true);
}
else if (!isAdd)
{
RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c6", "OpenAlert('抱歉！操作员\"" + loginName + "\"添加失败！');", true);
}
else
{
RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c6", "OpenAlert('操作员\"" + loginName + "\"添加成功！但是角色设置失败,请到系统代码中重新关联该用户角色！！');", true);
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (!scd.Exists(subSysCodeId))
{
RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c3", "OpenAlert('抱歉！该代码已不存在！！');", true);
return;
}
int totalCount = RGrid_SubSysCode.SelectedItems.Count;
StringBuilder notExists = new StringBuilder();
StringBuilder sb2 = new StringBuilder("【");
int sucCount = 0;
int errCount = 0;
if (totalCount == 0)
{
RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c3", "OpenAlert('抱歉！您未选择关联项！！');", true);
return;
}
Model.Log logM = new Model.Log();
logM.OperationItem = "批量子类关联";
logM.OperationTime = DateTime.Now;
logM.Operator = user.UserInfo.UserID;
try
{
StringBuilder sb = new StringBuilder("【");
long isUpdate = 0;
foreach (GridDataItem item in RGrid_SubSysCode.MasterTableView.Items)
{
if ((item["CheckboxSelectColumn"].Controls[0] as CheckBox).Checked)
{
String sysCodeDetialID = item["SYSCodeDetialID"].Text;
if (!scd.Exists(sysCodeDetialID))
{
errCount++;
notExists.Append(sysCodeDetialID + " ");
continue;
}
sb.Append(sysCodeDetialID + " ");
Model.SysCodeRelation scrModel = new Model.SysCodeRelation();
scrModel.SysCodeDetialID = subSysCodeId;
scrModel.SysCodeDetialIDEx = sysCodeDetialID;
isUpdate = scr.Add(scrModel);
if (isUpdate != 0)
{
sucCount++;
sb2.Append(sysCodeDetialID + " ");
}
}
}
sb.Append("】");
sb2.Append("】");
logM.OperationDetail = "子类关联主项:"+subSysCodeId+"; 子类关联提交列表[" + totalCount + "]：" + sb.ToString() + "子类关联成功列表[" + sucCount + "]:" + sb2.ToString();
}
catch (Exception ex)
{
logM.Memo = "异常：" + ex.Message;
}
finally
{
if (totalCount == (sucCount + errCount) && totalCount > 0)
{
logM.Memo = "成功";
if (errCount == 0)
{
RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c2", "OpenAlert('恭喜！子类关联成功！');", true);
}
else
{
RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c2", "OpenAlert('恭喜！子类关联成功！但是子类【" + notExists.ToString() + "】已不存在,未关联。');", true);
}
List<Model.SysCodeDetail> syscodeDetialList = (List<Model.SysCodeDetail>)ViewState["SyscodeDetialTypeList"];
syscodeDetialList.RemoveAll(item => sb2.ToString().Contains(item.SYSCodeDetialID));
RGrid_SubSysCode.DataSource = syscodeDetialList;
RGrid_SubSysCode.DataBind();
}
else
{
logM.Memo = "失败";
RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c3", "OpenAlert('抱歉！子类关联未成功！（请查询关联查看结果！）');", true);
}
log.Add(logM);
}
}
protected void RGrid_SubSysCode_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "AddRelation")
{
string anotherSubCodeId = Convert.ToString(e.CommandArgument);
Model.SysCodeRelation scrModel = new Model.SysCodeRelation();
scrModel.SysCodeDetialID = subSysCodeId;
scrModel.SysCodeDetialIDEx = anotherSubCodeId;
long result = 0;
Model.Log logModel = new Model.Log();
try
{
logModel.OperationItem = "添加子类关联";
logModel.Operator = user.UserInfo.UserID;
logModel.OperationTime = DateTime.Now;
logModel.OperationDetail = "子类编号：" + subSysCodeId + " & 子类编号：" + anotherSubCodeId;
result = scr.Add(scrModel);
if (result != 0)
{
logModel.Memo = "成功";
}
else
{
logModel.Memo = "失败！";
}
}
catch (Exception ex)
{
logModel.Memo = "异常：" + ex.Message;
}
finally
{
log.Add(logModel);
if (result != 0)
{
RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c2", "OpenAlert('恭喜！关联成功！');", true);
List<Model.SysCodeDetail> syscodeDetialList = (List<Model.SysCodeDetail>)ViewState["SyscodeDetialTypeList"];
syscodeDetialList.RemoveAll(item => item.SYSCodeDetialID.Equals(anotherSubCodeId));
RGrid_SubSysCode.DataSource = syscodeDetialList;
RGrid_SubSysCode.DataBind();
}
else
{
RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c3", "OpenAlert('抱歉！关联失败！');", true);
}
}
}
}
