protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { #region 车辆绑定 if (GroupId.Length > 0) { DataTable dt = PlatFormBusiness.GetVechiles(GroupId); ControlHelper.BindListControl(cblVehicles, dt, "TARGET_ID", "MAC_ID"); } //修改时包含的车辆进行选中 if (CompanyGroupId > 0) { foreach (ListItem item in cblVehicles.Items) { if (CompanyGroupBusiness.IsGroupContainVehicel(CompanyGroupId, item.Value)) { item.Selected = true; } } USER_SHARE_GROUPMODEL group = CompanyGroupBusiness.GetGroupModel(CompanyGroupId); if (group != null) { txtGroupName.Text = group.GROUPNAME; txtGroupDesc.Text = CommonMethod.FinalString(group.GROUPDESC); } } #endregion } }
/// <summary> /// 得到一个对象实体 /// </summary> public static USER_SHARE_GROUPMODEL GetGroupModel(int groupid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,COMPANYCODE,GROUPNAME,PARENTID,STATE,GRADE,GROUPDESC FROM USER_SHARE_GROUP "); strSql.Append(" where ID=:ID AND STATE=:STATE"); ParamList param = new ParamList(); param["ID"] = groupid; param["STATE"] = ShareEnum.CompanyGroupStatus.Normal.ToString("d"); USER_SHARE_GROUPMODEL model = null; DataTable dt = StaticConnectionProvider.ExecuteDataTable(strSql.ToString(), param); if (dt != null && dt.Rows.Count > 0) { model = ReaderBind(dt.Rows[0]); } return(model); }
protected void btnSave_Click(object sender, EventArgs e) { #region 务端验证 if (txtGroupName.Text.Trim().Length == 0) { Alert("请输入分组名称!"); Select(txtGroupName); return; } List <USER_SHARE_VEHICLE_GROUPMODEL> lstVgModel = new List <USER_SHARE_VEHICLE_GROUPMODEL>(); USER_SHARE_VEHICLE_GROUPMODEL vgmodel = null; foreach (ListItem item in cblVehicles.Items) { if (item.Selected) { vgmodel = new USER_SHARE_VEHICLE_GROUPMODEL(); vgmodel.SHAREGROUPID = 0; vgmodel.MACID = item.Value; vgmodel.TARGETID = item.Text; lstVgModel.Add(vgmodel); } } if (lstVgModel.Count == 0) { Alert("请选择分组包含车辆!"); return; } #endregion #region 分组信息保存 USER_SHARE_GROUPMODEL groupModel = null; //日志信息 USER_SHARE_LOGMODEL logModel = new USER_SHARE_LOGMODEL(); logModel.LOGID = CommonBusiness.GetSeqID("S_USER_SHARE_LOG"); logModel.OPERATEDATE = DateTime.Now; logModel.OPERATORID = AccountId; logModel.PROJECTID = ProjectId; logModel.COMPANYID = CompanyId; if (CompanyGroupId > 0) { groupModel = CompanyGroupBusiness.GetGroupModel(CompanyGroupId); logModel.OPERATETYPE = int.Parse(ShareEnum.LogType.EditCompanyGroup.ToString("d")); logModel.OPERATECONTENT = string.Format("修改分组信息,修改后分组名称:{0}, 分组Id:{1} ", txtGroupName.Text.Trim(), CompanyGroupId); } else { groupModel = new USER_SHARE_GROUPMODEL(); groupModel.ID = CommonBusiness.GetSeqID("S_USER_SHARE_GROUP"); groupModel.COMPANYCODE = CompanyCode; groupModel.PARENTID = Request.QueryString["pid"] == null ? 0 : ValidatorHelper.ToInt(Enc.Decrypt(Request.QueryString["pid"], UrlEncKey), 0); groupModel.STATE = int.Parse(ShareEnum.CompanyGroupStatus.Normal.ToString("d")); groupModel.GRADE = CompanyGroupBusiness.GetGroupGrade(CompanyCode, groupModel.PARENTID); logModel.OPERATETYPE = int.Parse(ShareEnum.LogType.AddCompanyGroup.ToString("d")); logModel.OPERATECONTENT = string.Format("新增分组信息,分组名称:{0},公司编码:{1} ", txtGroupName.Text.Trim(), CompanyCode); } groupModel.GROUPNAME = txtGroupName.Text.Trim(); groupModel.VEHICLENUM = lstVgModel.Count; groupModel.GROUPDESC = txtGroupDesc.Text.Trim(); bool blSuccess = false; string strRoleFuns = Request.Form["fun"]; if (CompanyGroupId == 0) { blSuccess = CompanyGroupBusiness.AddCompanyGroup(groupModel, lstVgModel, logModel); } else { blSuccess = CompanyGroupBusiness.EditCompanyGroup(groupModel, lstVgModel, logModel); } Alert((CompanyGroupId > 0 ? "修改" : "新增") + "分组" + (blSuccess ? "成功" : "失败,请重试!")); //刷新父页面 ExecStartScript(string.Format("parent.location='CompanyGroupManage.aspx?s={0}';", new Random(10000).Next())); #endregion }
/// <summary> /// 修改公司分组信息 /// </summary> /// <param name="groupModel"></param> /// <returns></returns> public static bool EditCompanyGroup(USER_SHARE_GROUPMODEL groupModel, List <USER_SHARE_VEHICLE_GROUPMODEL> lstVgModel, USER_SHARE_LOGMODEL log) { bool blSuccess = false; StringBuilder strSql = new StringBuilder(); strSql.Append("update USER_SHARE_GROUP set "); strSql.Append("COMPANYCODE=:COMPANYCODE,"); strSql.Append("GROUPNAME=:GROUPNAME,"); strSql.Append("PARENTID=:PARENTID,"); strSql.Append("STATE=:STATE,"); strSql.Append("GRADE=:GRADE,"); strSql.Append("VEHICLENUM=:VEHICLENUM,"); strSql.Append("GROUPDESC=:GROUPDESC"); strSql.Append(" where ID=:ID "); ParamList param = new ParamList(); param["ID"] = groupModel.ID; param["COMPANYCODE"] = groupModel.COMPANYCODE; param["GROUPNAME"] = groupModel.GROUPNAME; param["PARENTID"] = groupModel.PARENTID; param["STATE"] = groupModel.STATE; param["GRADE"] = groupModel.GRADE; param["VEHICLENUM"] = groupModel.VEHICLENUM; param["GROUPDESC"] = groupModel.GROUPDESC; IConnectionProvider connection = ConnectionProviderBuilder.CreateConnectionProvider(); try { using (connection) { connection.BeginTranscation(); //修改公司分组信息 connection.ExecuteNonQuery(strSql.ToString(), param); param.Clear(); //删除原来分组下的车辆信息 string strSqlFun = "DELETE FROM USER_SHARE_VEHICLE_GROUP WHERE SHAREGROUPID=" + groupModel.ID; StaticConnectionProvider.ExecuteNonQuery(strSqlFun); //分组车辆信息添加 foreach (USER_SHARE_VEHICLE_GROUPMODEL vgModel in lstVgModel) { strSqlFun = @"insert into USER_SHARE_VEHICLE_GROUP(SHAREGROUPID,TARGETID,MACID) values (:SHAREGROUPID,:TARGETID,:MACID)"; param.Clear(); param["SHAREGROUPID"] = groupModel.ID; param["TARGETID"] = vgModel.TARGETID; param["MACID"] = vgModel.MACID; connection.ExecuteNonQuery(strSqlFun, param); } param.Clear(); //操作日志 strSql = new StringBuilder(); strSql.Append("insert into USER_SHARE_LOG("); strSql.Append("LOGID,OPERATETYPE,OPERATORID,PROJECTID,COMPANYID,OPERATECONTENT,OPERATEDATE)"); strSql.Append(" values ("); strSql.Append(":LOGID,:OPERATETYPE,:OPERATORID,:PROJECTID,:COMPANYID,:OPERATECONTENT,:OPERATEDATE)"); param["LOGID"] = log.LOGID; param["OPERATETYPE"] = log.OPERATETYPE; param["OPERATORID"] = log.OPERATORID; param["PROJECTID"] = log.PROJECTID; param["COMPANYID"] = log.COMPANYID; param["OPERATECONTENT"] = log.OPERATECONTENT; param["OPERATEDATE"] = log.OPERATEDATE; connection.ExecuteNonQuery(strSql.ToString(), param); connection.CommitTranscation(); blSuccess = true; } } catch (Exception ex) { connection.RollbackTranscation(); LogHelper.WriteErr("修改公司分组信息时发生错误,分组Id:" + groupModel.ID, ex); } return(blSuccess); }
/// <summary> /// 新增公司分组信息 /// </summary> /// <param name="groupModel"></param> /// <returns></returns> public static bool AddCompanyGroup(USER_SHARE_GROUPMODEL groupModel, List <USER_SHARE_VEHICLE_GROUPMODEL> lstVgModel, USER_SHARE_LOGMODEL log) { bool blSuccess = false; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into USER_SHARE_GROUP("); strSql.Append("ID,COMPANYCODE,GROUPNAME,PARENTID,STATE,GRADE,VEHICLENUM,GROUPDESC)"); strSql.Append(" values ("); strSql.Append(":ID,:COMPANYCODE,:GROUPNAME,:PARENTID,:STATE,:GRADE,:VEHICLENUM,:GROUPDESC)"); ParamList param = new ParamList(); param["ID"] = groupModel.ID; param["COMPANYCODE"] = groupModel.COMPANYCODE; param["GROUPNAME"] = groupModel.GROUPNAME; param["PARENTID"] = groupModel.PARENTID; param["STATE"] = groupModel.STATE; param["GRADE"] = groupModel.GRADE; param["VEHICLENUM"] = groupModel.VEHICLENUM; param["GROUPDESC"] = groupModel.GROUPDESC; IConnectionProvider connection = ConnectionProviderBuilder.CreateConnectionProvider(); try { using (connection) { connection.BeginTranscation(); //增加分组信息 connection.ExecuteNonQuery(strSql.ToString(), param); param.Clear(); string strSqlFun = string.Empty; //分组车辆 foreach (USER_SHARE_VEHICLE_GROUPMODEL vgModel in lstVgModel) { strSqlFun = string.Format("insert into USER_SHARE_VEHICLE_GROUP(SHAREGROUPID,TARGETID,MACID)values(:SHAREGROUPID,:TARGETID,:MACID)"); param.Clear(); param["SHAREGROUPID"] = groupModel.ID; param["TARGETID"] = vgModel.TARGETID; param["MACID"] = vgModel.MACID; connection.ExecuteNonQuery(strSqlFun, param); } //操作日志 strSql = new StringBuilder(); strSql.Append("insert into USER_SHARE_LOG("); strSql.Append("LOGID,OPERATETYPE,OPERATORID,PROJECTID,COMPANYID,OPERATECONTENT,OPERATEDATE)"); strSql.Append(" values ("); strSql.Append(":LOGID,:OPERATETYPE,:OPERATORID,:PROJECTID,:COMPANYID,:OPERATECONTENT,:OPERATEDATE)"); param.Clear(); param["LOGID"] = log.LOGID; param["OPERATETYPE"] = log.OPERATETYPE; param["OPERATORID"] = log.OPERATORID; param["PROJECTID"] = log.PROJECTID; param["COMPANYID"] = log.COMPANYID; param["OPERATECONTENT"] = log.OPERATECONTENT; param["OPERATEDATE"] = log.OPERATEDATE; connection.ExecuteNonQuery(strSql.ToString(), param); connection.CommitTranscation(); blSuccess = true; } } catch (Exception ex) { connection.RollbackTranscation(); LogHelper.WriteErr("新增公司车辆分组信息时发生错误,分组名称:" + groupModel.GROUPNAME, ex); } return(blSuccess); }