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