public override void Submit_OnClick(object sender, EventArgs e) { var isChanged = false; try { if (string.IsNullOrEmpty(tbCommentRemark.Text)) { FailMessage("批示失败,必须填写意见"); return; } foreach (int applyID in _idArrayList) { var remarkInfo = new GovPublicApplyRemarkInfo(0, PublishmentSystemId, applyID, EGovPublicApplyRemarkType.Comment, tbCommentRemark.Text, Body.AdministratorInfo.DepartmentId, Body.AdministratorName, DateTime.Now); DataProvider.GovPublicApplyRemarkDao.Insert(remarkInfo); GovPublicApplyManager.Log(PublishmentSystemId, applyID, EGovPublicApplyLogType.Comment, Body.AdministratorName, Body.AdministratorInfo.DepartmentId); } isChanged = true; } catch (Exception ex) { FailMessage(ex, ex.Message); isChanged = false; } if (isChanged) { PageUtils.CloseModalPage(Page, "alert(\'批示成功!\');"); } }
public void SwitchTo_OnClick(object sender, EventArgs e) { var switchToDepartmentID = TranslateUtils.ToInt(Request.Form["switchToDepartmentID"]); if (switchToDepartmentID == 0) { FailMessage("转办失败,必须选择转办部门"); return; } var switchToDepartmentName = DepartmentManager.GetDepartmentName(switchToDepartmentID); try { DataProvider.GovPublicApplyDao.UpdateDepartmentId(applyInfo.Id, switchToDepartmentID); var remarkInfo = new GovPublicApplyRemarkInfo(0, PublishmentSystemId, applyInfo.Id, EGovPublicApplyRemarkType.SwitchTo, tbSwitchToRemark.Text, Body.AdministratorInfo.DepartmentId, Body.AdministratorName, DateTime.Now); DataProvider.GovPublicApplyRemarkDao.Insert(remarkInfo); GovPublicApplyManager.LogSwitchTo(PublishmentSystemId, applyInfo.Id, switchToDepartmentName, Body.AdministratorName, Body.AdministratorInfo.DepartmentId); SuccessMessage("申请转办成功"); AddWaitAndRedirectScript(ListPageUrl); } catch (Exception ex) { FailMessage(ex, ex.Message); } }
public void Insert(GovPublicApplyRemarkInfo remarkInfo) { var sqlString = "INSERT INTO wcm_GovPublicApplyRemark(PublishmentSystemID, ApplyID, RemarkType, Remark, DepartmentID, UserName, AddDate) VALUES (@PublishmentSystemID, @ApplyID, @RemarkType, @Remark, @DepartmentID, @UserName, @AddDate)"; var parms = new IDataParameter[] { GetParameter(ParmPublishmentsystemid, EDataType.Integer, remarkInfo.PublishmentSystemID), GetParameter(ParmApplyId, EDataType.Integer, remarkInfo.ApplyID), GetParameter(ParmRemarkType, EDataType.VarChar, 50, EGovPublicApplyRemarkTypeUtils.GetValue(remarkInfo.RemarkType)), GetParameter(ParmRemark, EDataType.NVarChar, 255, remarkInfo.Remark), GetParameter(ParmDepartmentId, EDataType.Integer, remarkInfo.DepartmentID), GetParameter(ParmUserName, EDataType.VarChar, 50, remarkInfo.UserName), GetParameter(ParmAddDate, EDataType.DateTime, remarkInfo.AddDate) }; ExecuteNonQuery(sqlString, parms); }
public void Accept_OnClick(object sender, EventArgs e) { try { var remarkInfo = new GovPublicApplyRemarkInfo(0, PublishmentSystemId, applyInfo.Id, EGovPublicApplyRemarkType.Accept, tbAcceptRemark.Text, Body.AdministratorInfo.DepartmentId, Body.AdministratorName, DateTime.Now); DataProvider.GovPublicApplyRemarkDao.Insert(remarkInfo); GovPublicApplyManager.Log(PublishmentSystemId, applyInfo.Id, EGovPublicApplyLogType.Accept, Body.AdministratorName, Body.AdministratorInfo.DepartmentId); DataProvider.GovPublicApplyDao.UpdateState(applyInfo.Id, EGovPublicApplyState.Accepted); SuccessMessage("申请受理成功"); AddWaitAndRedirectScript(ListPageUrl); } catch (Exception ex) { FailMessage(ex, ex.Message); } }
public override void Submit_OnClick(object sender, EventArgs e) { var isChanged = false; try { var switchToDepartmentID = TranslateUtils.ToInt(Request.Form["switchToDepartmentID"]); if (switchToDepartmentID == 0) { FailMessage("转办失败,必须选择转办部门"); return; } var switchToDepartmentName = DepartmentManager.GetDepartmentName(switchToDepartmentID); foreach (int applyID in _idArrayList) { var state = DataProvider.GovPublicApplyDao.GetState(applyID); if (state != EGovPublicApplyState.Denied && state != EGovPublicApplyState.Checked) { DataProvider.GovPublicApplyDao.UpdateDepartmentId(applyID, switchToDepartmentID); var remarkInfo = new GovPublicApplyRemarkInfo(0, PublishmentSystemId, applyID, EGovPublicApplyRemarkType.SwitchTo, tbSwitchToRemark.Text, Body.AdministratorInfo.DepartmentId, Body.AdministratorName, DateTime.Now); DataProvider.GovPublicApplyRemarkDao.Insert(remarkInfo); GovPublicApplyManager.LogSwitchTo(PublishmentSystemId, applyID, switchToDepartmentName, Body.AdministratorName, Body.AdministratorInfo.DepartmentId); } } isChanged = true; } catch (Exception ex) { FailMessage(ex, ex.Message); isChanged = false; } if (isChanged) { PageUtils.CloseModalPage(Page, "alert(\'申请转办成功!\');"); } }
public GovPublicApplyRemarkInfo GetRemarkInfo(int remarkId) { GovPublicApplyRemarkInfo remarkInfo = null; var parms = new IDataParameter[] { GetParameter(ParmRemarkId, EDataType.Integer, remarkId) }; using (var rdr = ExecuteReader(SqlSelect, parms)) { if (rdr.Read()) { var i = 0; remarkInfo = new GovPublicApplyRemarkInfo(GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), EGovPublicApplyRemarkTypeUtils.GetEnumType(GetString(rdr, i++)), GetString(rdr, i++), GetInt(rdr, i++), GetString(rdr, i++), GetDateTime(rdr, i)); } rdr.Close(); } return(remarkInfo); }
public ArrayList GetRemarkInfoArrayList(int applyId) { var arraylist = new ArrayList(); var parms = new IDataParameter[] { GetParameter(ParmApplyId, EDataType.Integer, applyId) }; using (var rdr = ExecuteReader(SqlSelectAll, parms)) { while (rdr.Read()) { var i = 0; var remarkInfo = new GovPublicApplyRemarkInfo(GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), EGovPublicApplyRemarkTypeUtils.GetEnumType(GetString(rdr, i++)), GetString(rdr, i++), GetInt(rdr, i++), GetString(rdr, i++), GetDateTime(rdr, i)); arraylist.Add(remarkInfo); } rdr.Close(); } return(arraylist); }
public void Redo_OnClick(object sender, EventArgs e) { if (string.IsNullOrEmpty(tbRedoRemark.Text)) { FailMessage("要求返工失败,必须填写意见"); return; } try { var remarkInfo = new GovPublicApplyRemarkInfo(0, PublishmentSystemId, applyInfo.Id, EGovPublicApplyRemarkType.Redo, tbRedoRemark.Text, Body.AdministratorInfo.DepartmentId, Body.AdministratorName, DateTime.Now); DataProvider.GovPublicApplyRemarkDao.Insert(remarkInfo); GovPublicApplyManager.Log(PublishmentSystemId, applyInfo.Id, EGovPublicApplyLogType.Redo, Body.AdministratorName, Body.AdministratorInfo.DepartmentId); DataProvider.GovPublicApplyDao.UpdateState(applyInfo.Id, EGovPublicApplyState.Redo); SuccessMessage("要求返工成功"); AddWaitAndRedirectScript(ListPageUrl); } catch (Exception ex) { FailMessage(ex, ex.Message); } }