public void Reply_OnClick(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(tbReply.Text))
            {
                FailMessage("回复失败,必须填写答复内容");
                return;
            }
            try
            {
                DataProvider.GovPublicApplyReplyDao.DeleteByApplyId(applyInfo.Id);
                var fileUrl   = string.Empty;
                var replyInfo = new GovPublicApplyReplyInfo(0, PublishmentSystemId, applyInfo.Id, tbReply.Text, fileUrl, Body.AdministratorInfo.DepartmentId, Body.AdministratorName, DateTime.Now);
                DataProvider.GovPublicApplyReplyDao.Insert(replyInfo);

                GovPublicApplyManager.Log(PublishmentSystemId, applyInfo.Id, EGovPublicApplyLogType.Reply, Body.AdministratorName, Body.AdministratorInfo.DepartmentId);
                DataProvider.GovPublicApplyDao.UpdateState(applyInfo.Id, EGovPublicApplyState.Replied);

                SuccessMessage("申请回复成功");

                AddWaitAndRedirectScript(ListPageUrl);
            }
            catch (Exception ex)
            {
                FailMessage(ex, ex.Message);
            }
        }
Example #2
0
        public void Insert(GovPublicApplyReplyInfo replyInfo)
        {
            var sqlString = "INSERT INTO wcm_GovPublicApplyReply(PublishmentSystemID, ApplyID, Reply, FileUrl, DepartmentID, UserName, AddDate) VALUES (@PublishmentSystemID, @ApplyID, @Reply, @FileUrl, @DepartmentID, @UserName, @AddDate)";

            var parms = new IDataParameter[]
            {
                GetParameter(ParmPublishmentsystemid, EDataType.Integer, replyInfo.PublishmentSystemID),
                GetParameter(ParmApplyId, EDataType.Integer, replyInfo.ApplyID),
                GetParameter(ParmReply, EDataType.NText, replyInfo.Reply),
                GetParameter(ParmFileUrl, EDataType.NVarChar, 255, replyInfo.FileUrl),
                GetParameter(ParmDepartmentId, EDataType.Integer, replyInfo.DepartmentID),
                GetParameter(ParmUserName, EDataType.VarChar, 50, replyInfo.UserName),
                GetParameter(ParmAddDate, EDataType.DateTime, replyInfo.AddDate)
            };

            ExecuteNonQuery(sqlString, parms);
        }
Example #3
0
        public GovPublicApplyReplyInfo GetReplyInfoByApplyId(int applyId)
        {
            GovPublicApplyReplyInfo replyInfo = null;

            var parms = new IDataParameter[]
            {
                GetParameter(ParmApplyId, EDataType.Integer, applyId)
            };

            using (var rdr = ExecuteReader(SqlSelectByApplyId, parms))
            {
                if (rdr.Read())
                {
                    var i = 0;
                    replyInfo = new GovPublicApplyReplyInfo(GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), GetString(rdr, i++), GetString(rdr, i++), GetInt(rdr, i++), GetString(rdr, i++), GetDateTime(rdr, i));
                }
                rdr.Close();
            }

            return(replyInfo);
        }