protected void btnSaveRefresh_Click(object sender, EventArgs e) { if (Request.QueryString["Type"] == "1") { //编辑保存 zlzw.Model.JobKindListModel jobKindListModel = new zlzw.Model.JobKindListModel(); jobKindListModel.JobKindName = txbNJobKindName.Text; jobKindListModel.JobKindGUID = new Guid(ViewState["JobKindGUID"].ToString()); jobKindListModel.JobCategoryGUID = new Guid(drpJobCategory.SelectedValue); jobKindListModel.IsEnable = 1; if (ckbIsHot.Checked) { jobKindListModel.IsHot = 1; } else { jobKindListModel.IsHot = 0; } if (ckbIsShowDefaultPage.Checked) { jobKindListModel.IsShowDefaultPage = 1; } else { jobKindListModel.IsShowDefaultPage = 0; } jobKindListModel.PublishDate = DateTime.Parse(ViewState["PublishDate"].ToString()); jobKindListModel.JobKindID = int.Parse(Get_JobKindID(Request.QueryString["value"])); zlzw.BLL.JobKindListBLL jobKindListBLL = new zlzw.BLL.JobKindListBLL(); jobKindListBLL.Update(jobKindListModel); } else { //添加保存 zlzw.Model.JobKindListModel jobKindListModel = new zlzw.Model.JobKindListModel(); jobKindListModel.JobKindName = txbNJobKindName.Text; jobKindListModel.JobKindGUID = Guid.NewGuid(); jobKindListModel.JobCategoryGUID = new Guid(drpJobCategory.SelectedValue); jobKindListModel.IsEnable = 1; if (ckbIsHot.Checked) { jobKindListModel.IsHot = 1; } else { jobKindListModel.IsHot = 0; } if (ckbIsShowDefaultPage.Checked) { jobKindListModel.IsShowDefaultPage = 1; } else { jobKindListModel.IsShowDefaultPage = 0; } jobKindListModel.PublishDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss")); zlzw.BLL.JobKindListBLL jobKindListBLL = new zlzw.BLL.JobKindListBLL(); jobKindListBLL.Add(jobKindListModel); } // 2. Close this window and Refresh parent window PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); }
/// <summary> /// 关闭 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void ButtonClose_Click(object sender, EventArgs e) { PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); }
protected void btnSaveRefresh_Click(object sender, EventArgs e) { try { // 1. 这里放置保存窗体中数据的逻辑 string sql; string reqFlag = "0"; string strExpect_Time = ""; if (rbtnSecond.Checked) { reqFlag = "1"; } else if (rbtnFirst.Checked) { reqFlag = "2"; } sql = "INSERT INTO bug_main_info (bug_title,bug_type,sub_bug_count) "; sql += "VALUES ('" + BugTitle.Text + "', " + BugType.SelectedItem.Value + ", 1 ) "; //Alert.ShowInTop(sql); int rst = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sql); if (rst != 1) { Alert.ShowInTop("save error!"); } string sIsResolved = "0"; if (IsResolved.Checked) { sIsResolved = "1"; } sql = "select IDENT_CURRENT('bug_main_info') "; SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sql); string newId = "0"; while (reader.Read()) { newId = reader.GetValue(0).ToString(); } string resolveUser = "******"; if (DropDownList1.SelectedItem != null) { resolveUser = DropDownList1.SelectedItem.Value; } sql = "INSERT INTO bug_detail_info (bug_id,process_type,is_resolved,phenomenon,create_time,occur_time,create_user_id,bug_state, "; sql += "pj_id,PRI,rsolve_time,resolve_user_id,solution,cur_user_id,next_user_id,pd_id,req_flag,expect_time) "; sql += "VALUES (" + newId + "," + BugProcType.SelectedItem.Value + "," + sIsResolved + ",'" + Phenomenon.Text + "',GETDATE(), "; if (OccurTime.Text == "") { sql += "NULL, "; } else { sql += "cast('"; sql += OccurTime.SelectedDate; sql += "' as datetime),"; } // sql+="cast('" + OccurTime.SelectedDate + "' as datetime),"; sql += Page.Session["user_id"].ToString() + ",6001," + BugBelongPJ.SelectedItem.Value + "," + BugAuth.SelectedItem.Value + ", "; if (FixTime.Text == "") { sql += "NULL, "; } else { sql += "cast('"; sql += FixTime.SelectedDate; sql += "' as datetime),"; } // sql += "cast('" + FixTime.SelectedDate + "' as datetime),"; sql += resolveUser + ",'" + Solution.Text + "'," + Page.Session["user_id"].ToString() + "," + NextUser.SelectedItem.Value; sql += ", " + BugBelongPD.SelectedItem.Value + ", " + reqFlag + ", "; if (Expect_Time.Text == "") { sql += "NULL"; } else { sql += "cast('"; sql += Expect_Time.SelectedDate; sql += "' as datetime)"; } sql += ");"; // 2. 关闭本窗体,然后刷新父窗体 rst = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sql); if (rst != 1) { Alert.ShowInTop("save error !"); } sql = "select IDENT_CURRENT('bug_detail_info') "; reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sql); string newDetailId = "0"; while (reader.Read()) { newDetailId = reader.GetValue(0).ToString(); } AddBugRecord(newDetailId, "新增*预期解决日期:" + string.Format("{0:d}", Expect_Time.SelectedDate)); PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); //发送邮件 // int res= Utils.SendEmail(Utils.GetEmail(NextUser.SelectedValue), Utils.GetEmail(Page.Session["user_id"].ToString()), BugTitle.Text, Phenomenon.Text); //if (NextUser.SelectedValue !="0") //{ // string Solution_1 = Solution.Text.Replace("\n", "<BR>               "); // string Phenomenon_1 = Phenomenon.Text.Replace("\n", "<BR>           "); // string Theme = "问题主题:" + BugTitle.Text + ", 提出人:" + Utils.GetUserName(Convert.ToInt32(Page.Session["user_id"].ToString())) + ", 问题状态:新增"; // string concent = "<BR>问题标题: " + BugTitle.Text + "<BR>提出人: " + Utils.GetUserName(Convert.ToInt32(Page.Session["user_id"].ToString())) + "<BR>所属项目: " + BugBelongPJ.SelectedText + "<BR>所属产品 " + BugBelongPD.SelectedText + "<BR>当前状态 " + "新增" + "<BR>现象描述: " + Phenomenon_1 + "<BR>现场处理过程: " + Solution_1 + "<BR><BR><BR><BR><BR><BR>                                 -----此邮件来自瑞驰管理系统"; // int res = Utils.SendEmail(Utils.GetEmail(NextUser.SelectedValue), Utils.GetEmail(Page.Session["user_id"].ToString()), Theme, concent); // if (res != 0) // { // Alert.ShowInTop("邮件发送失败 请联系检查邮件地址是否为公司邮箱!"); // } //} } catch (Exception ex) { Alert.ShowInTop(ex.Message); } }
protected void btnSaveRefresh_Click(object sender, EventArgs e) { if (Request.QueryString["Type"] == "1") { //编辑保存 zlzw.Model.CareersListModal careersListModal = new zlzw.Model.CareersListModal(); careersListModal.DictionaryKey = drpStoreType.SelectedValue; //所属门店 careersListModal.DepartmentName = txbDepartmentName.Text; //招聘部门 careersListModal.CareersTitle = txbCareersTitle.Text; //职位名称 careersListModal.CareersCount = int.Parse(txbCareersCount.Text); //招聘人数 careersListModal.WorkAdd = txbWorkAdd.Text; //工作地点 careersListModal.Educational = txbEducational.Text; //学历要求 careersListModal.Salary = txbSalary.Text; //月薪 careersListModal.WorkExperience = txbWorkExperience.Text; //工作经验 careersListModal.EMail = txbEmail.Text; //联系邮件 careersListModal.Telephone = txbTel.Text; //联系电话 careersListModal.ContactMan = txbContactMan.Text; //联系人 careersListModal.Responsibilities = txbResponsibilities.Text; //岗位职责 careersListModal.Qualifications = txbQualifications.Text; //任职资格 if (ckbIsHot.Checked) { careersListModal.IsHot = 1; } else { careersListModal.IsHot = 0; } careersListModal.IsEnable = 1; careersListModal.CareersGUID = new Guid(Request.QueryString["value"]); careersListModal.PublishDate = DateTime.Parse(ViewState["PublishDate"].ToString()); careersListModal.CareersID = int.Parse(Get_CareersID(Request.QueryString["value"])); zlzw.BLL.CareersListBLL careersListBLL = new zlzw.BLL.CareersListBLL(); careersListBLL.Update(careersListModal); } else { //添加保存 zlzw.Model.CareersListModal careersListModal = new zlzw.Model.CareersListModal(); careersListModal.DictionaryKey = drpStoreType.SelectedValue; //所属门店 careersListModal.DepartmentName = txbDepartmentName.Text; //招聘部门 careersListModal.CareersTitle = txbCareersTitle.Text; //职位名称 careersListModal.CareersCount = int.Parse(txbCareersCount.Text); //招聘人数 careersListModal.WorkAdd = txbWorkAdd.Text; //工作地点 careersListModal.Educational = txbEducational.Text; //学历要求 careersListModal.Salary = txbSalary.Text; //月薪 careersListModal.WorkExperience = txbWorkExperience.Text; //工作经验 careersListModal.EMail = txbEmail.Text; //联系邮件 careersListModal.Telephone = txbTel.Text; //联系电话 careersListModal.ContactMan = txbContactMan.Text; //联系人 careersListModal.Responsibilities = txbResponsibilities.Text; //岗位职责 careersListModal.Qualifications = txbQualifications.Text; //任职资格 careersListModal.CareersGUID = Guid.NewGuid(); //创建GUID careersListModal.IsEnable = 1; if (ckbIsHot.Checked) { careersListModal.IsHot = 1; } else { careersListModal.IsHot = 0; } careersListModal.PublishDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss")); zlzw.BLL.CareersListBLL careersListBLL = new zlzw.BLL.CareersListBLL(); careersListBLL.Add(careersListModal); } // 2. Close this window and Refresh parent window PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); }
/// <summary> /// 保存按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { this.SaveData(BLL.Const.BtnSave); PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); }
protected void btnSaveRefresh_Click(object sender, EventArgs e) { // 1. 这里放置保存窗体中数据的逻辑 string top_flag = "0"; if (CheckBox1.Checked) { top_flag = "1"; } string sql = ""; string vals = Request.Url.Query; if (vals == "") { sql = "INSERT INTO sys_organize_info "; sql += "(org_name, org_normal_name, org_manager_name, org_assist_name, is_top, father_org_id) "; sql += "VALUES ('" + TextBox5.Text + "', '" + TextBox1.Text + "', '" + TextBox2.Text + "', '" + TextBox3.Text + "'," + top_flag + ", " + dr_dpt.SelectedItem.Value + ") "; //Alert.ShowInTop(sql); int rst = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sql); if (rst != 1) { Alert.ShowInTop("save error!"); return; } sql = "select IDENT_CURRENT('sys_organize_info') "; SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sql); string newId = "0"; while (reader.Read()) { newId = reader.GetValue(0).ToString(); } sql = " insert into sys_func_authority (og_id,og_type)values ('"; sql += newId; sql += "',3002)"; //Alert.ShowInTop(sql); rst = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sql); if (rst < 0) { Alert.ShowInTop("save error!"); } } else { oid = Request.QueryString.GetValues(0)[0]; sql = "update sys_organize_info set org_name='" + TextBox5.Text + "',org_normal_name='" + TextBox1.Text + "',org_manager_name='" + TextBox2.Text; sql += "',org_assist_name='" + TextBox3.Text + "',is_top=" + top_flag + ",father_org_id= " + dr_dpt.SelectedItem.Value; sql += " where org_id = " + oid; int rst = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sql); if (rst != 1) { Alert.ShowInTop("save error !"); } } // 2. 关闭本窗体,然后刷新父窗体 PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); }
protected void btnSaveRefresh_Click(object sender, EventArgs e) { // 1. 这里放置保存窗体中数据的逻辑 int messageID = int.Parse(Request.QueryString["id"].Trim()); List <T_Message> message = messageBLL.GetMessageById(messageID); T_Message messageModel = new T_Message(); try { #region 邮件信息 MailMessage mail = new MailMessage(); mail.To.Add(new MailAddress(message[0].Email)); mail.From = new MailAddress(txb_ReplyEmailAddress.Text.Trim(), "武汉理工大学心理健康平台", System.Text.Encoding.UTF8); string _body = ""; string _subject = "回复:" + txa_BriefQuestion.Text.Trim(); _body = HtmlEditor1.Text + "<br/><br/>******************************************************" + "<br/>" + "这是一封系统自动发送的邮件通知,请不要直接回复,如有疑问,请联系管理员。" + "<br/>" + "<br/>请添加本邮箱为联系人,以便于即时收到邮件通知。祝 学习生活愉快!"; mail.Body = _body; mail.Subject = _subject; mail.Priority = MailPriority.High; mail.IsBodyHtml = true; //mail.BodyEncoding = System.Text.Encoding.UTF8; #endregion #region 发送方服务器信息 SmtpClient smtp = new SmtpClient(); if (txb_ReplyEmailAddress.Text.Trim().IndexOf("@126.com") >= 0) { smtp.Host = "smtp.126.com"; } //smtp.UseDefaultCredentials = true; //smtp.EnableSsl = true; string mailFromAddress = txb_ReplyEmailAddress.Text.Split(new char[] { '@' })[0]; smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", txb_ReplyEmailPwd.Text.Trim()); smtp.DeliveryMethod = SmtpDeliveryMethod.Network; smtp.Port = 25; //smtp.Send(mail); //同步发送程序将被阻塞 #endregion #region 异步发送邮件 判断发送状态 smtp.SendCompleted += new SendCompletedEventHandler(SendCompletedCallBack); string userState = "测试"; smtp.SendAsync(mail, userState); #endregion } catch { throw; } #region 保存至数据库 messageModel.ID = messageID; messageModel.NickName = message[0].NickName; messageModel.Sex = message[0].Sex; messageModel.Email = message[0].Email; messageModel.Grade = message[0].Grade; messageModel.TeacherName = message[0].TeacherName; messageModel.BriefQuestion = txa_BriefQuestion.Text.Trim(); messageModel.DetailQuestion = txa_DetailQuestion.Text.Trim(); messageModel.QuestionTime = message[0].QuestionTime; messageModel.Reply = HtmlEditor1.Text.Trim(); messageModel.ReplyTime = DateTime.Now; messageModel.Category = 0; if (HtmlEditor1.Text.Trim() != "") { messageModel.Status = 1; } int result = messageBLL.Update(messageModel); if (result > 0) { Alert alert = new Alert(); alert.Message = "回复成功"; alert.Target = Target.Top; alert.Show(); } else { Alert alert = new Alert(); alert.Message = "出现错误 请稍后再试"; alert.Target = Target.Top; alert.Show(); } #endregion // 2. 关闭本窗体,然后刷新父窗体 PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); }
//新增 protected void btnSaveRefresh_Click2(object sender, EventArgs e) { try { // 1. 这里放置保存窗体中数据的逻辑 string sql = ""; string pjm_id = Request.QueryString.GetValues(1)[0]; sql += " INSERT INTO dev_sdd_mission_detail "; sql += " (sdd_pjm_id,user_id,"; if (NumBox2.Text != "") { sql += "PAP,"; } if (NumberBox1.Text != "") { sql += "rPAP,"; } sql += "mission_content,expect_date,begin_date,finish_flag"; if (DatePicker3.Text != "") { sql += ",finish_date"; } sql += ") "; sql += " VALUES (" + pjm_id + "," + DropDownList7.SelectedItem.Value + ","; if (NumBox2.Text != "") { sql += NumBox2.Text + ","; } if (NumberBox1.Text != "") { sql += NumberBox1.Text + ","; } sql += "'" + content.Text + "','" + DatePicker4.Text + "','" + DatePicker2.Text + "',"; string finishFlag = "0"; if (CheckBox1.Checked) { finishFlag = "1"; } sql += finishFlag; if (DatePicker3.Text != "") { sql += ",'" + DatePicker3.Text + "'"; } sql += ");"; int rst = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sql); if (rst != 1) { Alert.ShowInTop("save error !"); } PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); } catch (System.Exception ex) { Alert.ShowInTop(ex.Message); } }
protected void btnSaveClose_Click(object sender, EventArgs e) { //PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); int budgetID = GetQueryIntValue("id"); if (budgetID > 0) { Infobasis.Data.DataEntity.BudgetTemplate data = DB.BudgetTemplates .Where(u => u.ID == budgetID).FirstOrDefault(); if (data == null) { // 参数错误,首先弹出Alert对话框然后关闭弹出窗口 Alert.Show("参数错误!", String.Empty, ActiveWindow.GetHideReference()); return; } data.Code = tbxCode.Text.Trim(); data.Name = tbxName.Text; data.DisplayOrder = Change.ToInt(tbxDisplayOrder.Text); if (Change.ToInt(DropDownProvince.SelectedValue) > 0) { data.ProvinceID = Change.ToInt(DropDownProvince.SelectedValue); data.ProvinceName = DropDownProvince.SelectedText; } if (Change.ToInt(DropDownBoxBudgetType.SelectedValue) > 0) { data.BudgetTypeID = Change.ToInt(DropDownBoxBudgetType.SelectedValue); data.BudgetTypeName = DropDownBoxBudgetType.SelectedText; } data.IsActive = tbxIsActive.Checked; data.BudgetTemplateStatus = tbxIsActive.Checked ? BudgetTemplateStatus.Enabled : BudgetTemplateStatus.Disabled; data.LastUpdateDatetime = DateTime.Now; data.Remark = tbxRemark.Text; data.LastUpdateByID = UserInfo.Current.ID; data.LastUpdateByName = UserInfo.Current.ChineseName; } else { Infobasis.Data.DataEntity.BudgetTemplate data = new Infobasis.Data.DataEntity.BudgetTemplate() { CreateDatetime = DateTime.Now, Code = tbxCode.Text.Trim(), Name = tbxName.Text, Remark = tbxRemark.Text, BudgetTemplateStatus = Infobasis.Data.DataEntity.BudgetTemplateStatus.Enabled }; data.DisplayOrder = Change.ToInt(tbxDisplayOrder.Text); if (Change.ToInt(DropDownProvince.SelectedValue) > 0) { data.ProvinceID = Change.ToInt(DropDownProvince.SelectedValue); data.ProvinceName = DropDownProvince.SelectedText; } if (Change.ToInt(DropDownBoxBudgetType.SelectedValue) > 0) { data.BudgetTypeID = Change.ToInt(DropDownBoxBudgetType.SelectedValue); data.BudgetTypeName = DropDownBoxBudgetType.Text; } data.IsActive = tbxIsActive.Checked; data.BudgetTemplateStatus = tbxIsActive.Checked ? BudgetTemplateStatus.Enabled : BudgetTemplateStatus.Disabled; DB.BudgetTemplates.Add(data); } SaveChanges(); ShowNotify("添加成功"); PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); }
protected void PageManager1_CustomEvent(object sender, CustomEventArgs e) { string picurl = @""; if (e.EventArgument.IndexOf("mysave") >= 0) { //获取上传的授权书图片并和授权书相关数据一起保存 JArray jaResult = JsonConvert.DeserializeObject <JArray>(hfdURL.Text); foreach (JToken jt in jaResult) { picurl += jt["_raw"].ToString() + ","; } if (picurl.Length <= 0) { Alert.Show("请传入授权书证照图片!"); return; } picurl = picurl.Substring(0, picurl.Length - 1); string[] arrays = picurl.Split(','); StringBuilder sb = new StringBuilder(); for (int i = 0; i < GridList.SelectedRowIndexArray.Length; i++) { sb.Append(GridList.SelectedRowIndexArray[i].ToString() + ","); } sb = sb.Remove(sb.Length - 1, 1); string seqnostr = hfdGrantid.Text; List <CommandInfo> liscmd = new List <CommandInfo>(); string sqtype = ""; if (chkisLR.Checked) { sqtype = "厂家直接授权"; } else { sqtype = "代理商授权"; } DataTable dtt = DbHelperOra.Query(@"SELECT PRODUCER,F_GETSUPNAME(PRODUCER)PRODUCERNAME,SUPID,F_GETSUPNAME(SUPID)SUPNAME,SUPTOID,F_GETSUPNAME(SUPTOID)SUPTONAME,FLAG,SQREGION,BEGINSQRQ,ENDSQRQ, DECODE(FLAG,'N','已保存','S','已提交','Y','已审批','R','已驳回') FLAGNAME,DOCID,SUPAGENT,GOODSINDEX,F_GETSUPNAME(SUPAGENT)SUPAGENTNAME,MEMO,SQTYPE FROM DOC_LICENSE_GRANT T WHERE GRANTID='" + hfdGrantid.Text + "' AND SUPTOID='" + hfdbesup.Text + "'").Tables[0]; string supid = dtt.Rows[0]["SUPID"].ToString(); //授权方 string producer = dtt.Rows[0]["PRODUCER"].ToString(); //生产厂商 string suptoid = dtt.Rows[0]["SUPTOID"].ToString(); //被授权方 string flag = dtt.Rows[0]["FLAG"].ToString(); //状态 if (flag.Equals("N") || flag.Equals("R")) { //如果证照是保存或撤回状态,直接删除掉已保存证照,再换上新证照 List <CommandInfo> delCmd = new List <CommandInfo>(); delCmd.Add(new CommandInfo("delete from doc_license_grant where grantid='" + hfdGrantid.Text + "' and suptoid='" + hfdbesup.Text + "' and iscur='Y'", null)); delCmd.Add(new CommandInfo("delete from doc_license_grantgoods where grantid='" + hfdGrantid.Text + "' and iscur='Y'", null)); delCmd.Add(new CommandInfo("delete from doc_license_sqimg where seqno='" + hfdGrantid.Text + "' and str2='" + hfdbesup.Text + "' and iscur='Y'", null)); DbHelperOra.ExecuteSqlTran(delCmd); } else { //如果证照状态不是N或R的话,直接将现有证照变成老证照,ISCUR='N'(将状态直接变成N) List <CommandInfo> liscommand = new List <CommandInfo>(); liscommand.Add(new CommandInfo("update doc_license_grant set iscur='N' where grantid='" + hfdGrantid.Text + "' and suptoid='" + hfdbesup.Text + "' and iscur='Y'", null)); liscommand.Add(new CommandInfo("update doc_license_grantgoods set iscur='N' where grantid='" + hfdGrantid.Text + "' and supbeto='" + hfdbesup.Text + "' and iscur='Y'", null)); liscommand.Add(new CommandInfo("update doc_license_sqimg SET ISCUR='N' where seqno='" + hfdGrantid.Text + "' and str2='" + hfdbesup.Text + "' and iscur='Y'", null)); DbHelperOra.ExecuteSqlTran(liscommand); } //换证之后,更新新录入的证照流水,其他老流水保持不变。插入本次换证的新证照 string seqnostrnew = DbHelperOra.GetSingle("SELECT SEQ_LICENSE_PIC.NEXTVAL FROM DUAL").ToString(); string myseq = "LIS" + producer + seqnostrnew; for (int i = 0; i < GridList.SelectedRowIndexArray.Length; i++) { int rowIndex = GridList.SelectedRowIndexArray[i]; string gdseq = GridList.DataKeys[rowIndex][0].ToString(); string gdname = GridList.DataKeys[rowIndex][1].ToString(); string gdspec = GridList.DataKeys[rowIndex][2].ToString(); liscmd.Add(new CommandInfo(@"insert into doc_license_grantgoods(GRANTID,FLAG,GDSEQ,GDNAME,SPEC,SUPPLIER,UPTIME,SUPBETO,ISCUR) values('" + myseq + "','N','" + gdseq + "','" + gdname + "','" + gdspec + "','" + producer + "',sysdate,'" + hfdbesup.Text + "','Y')", null)); } if (sqtype.Equals("厂家直接授权")) { //如果是厂家直接授权,则生产商和授权方都是生产商 liscmd.Add(new CommandInfo(@"insert into doc_license_grant(GRANTID,PRODUCER,SUPID,SUPTOID,SUPAGENT,FLAG,SQREGION,BEGINSQRQ,ENDSQRQ,OPERTIME,LRY,MEMO,GOODSINDEX,DOCID,SQTYPE,ISCUR,ISCHANGE) values('" + myseq + "','" + producer + "','" + supid + "','" + hfdbesup.Text + "','" + hfdagent.Text + "','N','" + tbxSQREGION.Text + "',to_date('" + dpkBEGRQ.Text + "','yyyy/mm/dd'),to_date('" + dpkENDRQ.Text + "','yyyy/mm/dd'),SYSDATE,'" + UserAction.UserID + "','" + tbxMEMO.Text + "','" + sb.ToString() + "','" + tbxDOCID.Text + "','" + sqtype + "','Y','Y')", null)); } else { //如果是代理商授权,则授权方是代理商 liscmd.Add(new CommandInfo(@"insert into doc_license_grant(GRANTID,PRODUCER,SUPID,SUPTOID,SUPAGENT,FLAG,SQREGION,BEGINSQRQ,ENDSQRQ,OPERTIME,LRY,MEMO,GOODSINDEX,DOCID,SQTYPE,ISCUR,ISCHANGE) values('" + myseq + "','" + producer + "','" + hfdagent.Text + "','" + hfdbesup.Text + "','" + hfdagent.Text + "','N','" + tbxSQREGION.Text + "',to_date('" + dpkBEGRQ.Text + "','yyyy/mm/dd'),to_date('" + dpkENDRQ.Text + "','yyyy/mm/dd'),SYSDATE,'" + UserAction.UserID + "','" + tbxMEMO.Text + "','" + sb.ToString() + "','" + tbxDOCID.Text + "','" + sqtype + "','Y','Y')", null)); } //授权链中有一个换证,那么将整个层级授权的流水更改成换证后的新流水,并且将层级中其他证照一并更换流水及授权商品、状态 liscmd.Add(new CommandInfo("update doc_license_grant set grantid='" + myseq + "',flag='N',goodsindex='" + sb.ToString() + "' where grantid='" + hfdGrantid.Text + "' and iscur='Y'", null)); liscmd.Add(new CommandInfo("update doc_license_grantgoods set grantid='" + myseq + "',flag='N' where grantid='" + hfdGrantid.Text + "' and iscur='Y'", null)); liscmd.Add(new CommandInfo("update doc_license_sqimg set seqno='" + myseq + "' where seqno='" + hfdGrantid.Text + "' and iscur='Y'", null)); //换证更新首级代理商 DataTable chkddt = DbHelperOra.Query("select supid,suptoid from doc_license_grantdoc where grantid='" + hfdGrantid.Text + "'").Tables[0]; if (chkddt.Rows[0][0].ToString().Equals(hfdbesup.Text) && chkddt.Rows[0][1].ToString().Equals(hfdsupid.Text)) { liscmd.Add(new CommandInfo("update doc_license_grantdoc set sqregion='" + tbxSQREGION.Text + "',beginsqrq=to_date('" + dpkBEGRQ.Text + "','yyyy/mm/dd'),endsqrq=to_date('" + dpkENDRQ.Text + "','yyyy/mm/dd'),grantid='" + myseq + "',flag='N',ischange='Y',goodsindex='" + sb.ToString() + "' where grantid='" + hfdGrantid.Text + "' and iscur='Y'", null)); } else { liscmd.Add(new CommandInfo("update doc_license_grantdoc set grantid='" + myseq + "',flag='N',ischange='Y' where grantid='" + hfdGrantid.Text + "' and iscur='Y'", null)); } for (int i = 1; i < arrays.Length + 1; i++) { liscmd.Add(new CommandInfo(@"insert into DOC_LICENSE_SQIMG(SEQNO,ROWNO,IMGPATH,UPTTIME,LICENSEID,ISCUR,STR1,STR2)values('" + myseq + "','" + i + "','" + arrays[i - 1] + "',sysdate,'" + "SQ" + "','Y','" + producer + "','" + hfdbesup.Text + "')", null)); } if (DbHelperOra.ExecuteSqlTran(liscmd)) { Alert.Show("证照上传成功!"); flagLbl.Text = "当前状态:已保存"; //DataSearch(); PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); } else { Alert.Show("证照上传失败!"); } } }
protected void btnSave_Click(object sender, EventArgs e) { //非换证直接保存的情况 if (isChange.Text.Equals("N")) { string sqtype = ""; if (chkisLR.Checked) { sqtype = "厂家直接授权"; } else { sqtype = "代理商授权"; } DateTime beginsqrq = Convert.ToDateTime(dpkBEGRQ.Text); DateTime endsqrq = Convert.ToDateTime(dpkENDRQ.Text); List <CommandInfo> liscmd = new List <CommandInfo>(); string sb = string.Empty; for (int i = 0; i < GridList.SelectedRowIndexArray.Length; i++) { sb = sb + GridList.SelectedRowIndexArray[i].ToString() + ","; } sb = sb.Remove(sb.Length - 1, 1); if (!sb.Equals(hfdGoodsIndex.Text)) { for (int i = 0; i < GridList.SelectedRowIndexArray.Length; i++) { int rowIndex = GridList.SelectedRowIndexArray[i]; string gdseq = GridList.DataKeys[rowIndex][0].ToString(); string gdname = GridList.DataKeys[rowIndex][1].ToString(); string gdspec = GridList.DataKeys[rowIndex][2].ToString(); liscmd.Add(new CommandInfo(@"insert into doc_license_grantgoods(GRANTID,FLAG,GDSEQ,GDNAME,SPEC,SUPPLIER,UPTIME,SUPBETO,ISCUR) values('" + hfdGrantid.Text + "','N','" + gdseq + "','" + gdname + "','" + gdspec + "','" + trgPRODUCER.Text + "',sysdate,'" + hfdbesup.Text + "','Y')", null)); } liscmd.Add(new CommandInfo("UPDATE DOC_LICENSE_GRANT SET FLAG='N',SQTYPE='" + sqtype + "',SUPAGENT='" + hfdagent.Text + "',SUPTOID='" + hfdbesup.Text + "',BEGINSQRQ=to_date('" + dpkBEGRQ.Text + "','yyyy/mm/dd'),ENDSQRQ=to_date('" + dpkENDRQ.Text + "','yyyy/mm/dd'),SQREGION='" + tbxSQREGION.Text + "',DOCID='" + tbxDOCID.Text + "',MEMO='" + tbxMEMO.Text + "',GOODSINDEX='" + sb.ToString() + "' where grantid='" + hfdGrantid.Text + "' and suptoid='" + hfdSuptoid.Text + "'", null)); } else { liscmd.Add(new CommandInfo("UPDATE DOC_LICENSE_GRANT SET FLAG='N',SQTYPE='" + sqtype + "',SUPAGENT='" + hfdagent.Text + "',SUPTOID='" + hfdbesup.Text + "',BEGINSQRQ=to_date('" + dpkBEGRQ.Text + "','yyyy/mm/dd'),ENDSQRQ=to_date('" + dpkENDRQ.Text + "','yyyy/mm/dd'),SQREGION='" + tbxSQREGION.Text + "',DOCID='" + tbxDOCID.Text + "',MEMO='" + tbxMEMO.Text + "' where grantid='" + hfdGrantid.Text + "' and suptoid='" + hfdSuptoid.Text + "'", null)); } if (DbHelperOra.ExecuteSqlTran(liscmd)) { Alert.Show("保存成功!"); flagLbl1.Hidden = true; flagLbl.Hidden = false; flagLbl.Text = "当前状态:已保存"; PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); } else { Alert.Show("保存失败!"); } } else //执行换证操作后保存 { if (dpkBEGRQ.Text.Length <= 0) { Alert.Show("请为 授权日期* 提供有效值!"); return; } if (dpkENDRQ.Text.Length <= 0) { Alert.Show("请为 截止日期* 提供有效值!"); return; } DateTime dtBEGRQ = Convert.ToDateTime(dpkBEGRQ.Text); DateTime dtENDRQ = Convert.ToDateTime(dpkENDRQ.Text); if (dtBEGRQ > dtENDRQ) { Alert.Show("授权日期不能大于截止日期!"); return; } if (GridList.SelectedRowIndexArray.Length <= 0) { Alert.Show("必须选择授权的商品!"); return; } PageContext.RegisterStartupScript("save();"); } }
protected void btnSaveRefresh_Click(object sender, EventArgs e) { if (Request.QueryString["Type"] == "1") { //编辑保存 zlzw.Model.StorefrontEleganceListModal storefrontEleganceListModal = new zlzw.Model.StorefrontEleganceListModal(); storefrontEleganceListModal.StorefrontEleganceGUID = new Guid(ViewState["StorefrontEleganceGUID"].ToString()); //店面风采GUID storefrontEleganceListModal.Other01 = drpRegionList.SelectedValue; storefrontEleganceListModal.DictionaryKey = drpStorefrontEleganceType.SelectedValue; //所属门店 storefrontEleganceListModal.StorefrontEleganceTitle = txbStorefrontEleganceTitle.Text; //门店名称 storefrontEleganceListModal.StorefrontEleganceDescription = txbStorefrontEleganceDescription.Text; //门店简介 storefrontEleganceListModal.PushJobs = txbPushJobs.Text; //主推岗位 if (btnStorefrontEleganceHeadImage.PostedFile.ContentLength > 0) { btnStorefrontEleganceHeadImage.SaveAs(Server.MapPath(ViewState["StorefrontEleganceHeadImage"].ToString())); storefrontEleganceListModal.StorefrontEleganceHeadImage = ViewState["StorefrontEleganceHeadImage"].ToString();//保存页面头部门店介绍路径 } else { storefrontEleganceListModal.StorefrontEleganceHeadImage = ViewState["StorefrontEleganceHeadImage"].ToString(); } storefrontEleganceListModal.IsEnable = 1; storefrontEleganceListModal.PublishDate = DateTime.Parse(ViewState["PublishDate"].ToString()); storefrontEleganceListModal.StorefrontEleganceID = int.Parse(Get_StorefrontEleganceID(Request.QueryString["value"])); storefrontEleganceListModal.StorefrontEleganceGUID = new Guid(Request.QueryString["value"]); zlzw.BLL.StorefrontEleganceListBLL storefrontEleganceListBLL = new zlzw.BLL.StorefrontEleganceListBLL(); storefrontEleganceListBLL.Update(storefrontEleganceListModal); } else { //添加保存 zlzw.Model.StorefrontEleganceListModal storefrontEleganceListModal = new zlzw.Model.StorefrontEleganceListModal(); storefrontEleganceListModal.DictionaryKey = drpStorefrontEleganceType.SelectedValue; //所属门店 storefrontEleganceListModal.Other01 = drpRegionList.SelectedValue; storefrontEleganceListModal.StorefrontEleganceTitle = txbStorefrontEleganceTitle.Text; //门店名称 storefrontEleganceListModal.StorefrontEleganceDescription = txbStorefrontEleganceDescription.Text; //门店简介 storefrontEleganceListModal.PushJobs = txbPushJobs.Text; //主推岗位 if (btnStorefrontEleganceHeadImage.PostedFile.ContentLength > 0) { string fileName = DateTime.Now.Ticks.ToString() + "_" + btnStorefrontEleganceHeadImage.FileName; btnStorefrontEleganceHeadImage.SaveAs(Server.MapPath("~/storefrontEleganceImages/" + fileName)); storefrontEleganceListModal.StorefrontEleganceHeadImage = "~/storefrontEleganceImages/" + fileName;//保存页面头部门店介绍路径 } else { storefrontEleganceListModal.StorefrontEleganceHeadImage = ViewState["StorefrontEleganceHeadImage"].ToString(); } storefrontEleganceListModal.IsEnable = 1; storefrontEleganceListModal.StorefrontEleganceGUID = Guid.NewGuid();//店面风采GUID storefrontEleganceListModal.PublishDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss")); zlzw.BLL.StorefrontEleganceListBLL storefrontEleganceListBLL = new zlzw.BLL.StorefrontEleganceListBLL(); storefrontEleganceListBLL.Add(storefrontEleganceListModal); } // 2. Close this window and Refresh parent window PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); }
protected void btnSaveRefresh_Click(object sender, EventArgs e) { try { string sqlCmd = ""; DataTable dt = new DataTable(); int userStatus = CkeckBox_enabled.Checked ? 1 : 0; sqlCmd = "select * from x_user where name='" + txb_workNo.Text + "' and Enabled=1";//是否在办公系统中开通相应账户 SqlSel.GetSqlSel(ref dt, sqlCmd); if (dt.Rows.Count > 0) { int fId = Convert.ToInt32(dt.Rows[0]["id"]); //用户流水id if (string.IsNullOrEmpty(userId)) //新建用户 { sqlCmd = "insert into PLM_Sys_UserList (userId,enabled) values ("; sqlCmd += "'" + txb_workNo.Text + "','" + userStatus + "')"; SqlSel.ExeSql(sqlCmd); //删除用户现有角色 sqlCmd += "delete from OA_Sys_UserRole where userid=(select id from x_user where name='" + userId + "')"; SqlSel.ExeSql(sqlCmd); //更新角色信息 string[] selectValueArray = ckb_roleList.SelectedValueArray; foreach (string item in selectValueArray) { sqlCmd = "insert into OA_Sys_UserRole (userid,roleid,addtime) values ("; sqlCmd += "'" + fId + "','" + item + "','" + DateTime.Now + "')"; SqlSel.ExeSql(sqlCmd); } } else //更新用户信息 { sqlCmd = "update PLM_Sys_UserList set enabled='" + userStatus + "' where userId='" + userId + "'"; SqlSel.ExeSql(sqlCmd); //删除用户现有角色 sqlCmd += "delete from OA_Sys_UserRole where userid=(select id from x_user where name='" + userId + "')"; SqlSel.ExeSql(sqlCmd); string[] selectValueArray = ckb_roleList.SelectedValueArray; foreach (string item in selectValueArray) { sqlCmd = "insert into OA_Sys_UserRole (userid,roleid,addtime) values ("; sqlCmd += "'" + fId + "','" + item + "','" + DateTime.Now + "')"; SqlSel.ExeSql(sqlCmd); } } Alert.ShowInTop("保存成功!"); PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); } else { Alert.ShowInTop("系统不存在此工号!请查正或联系管理员。"); return; } } catch (Exception ex) { Alert.ShowInTop(ex.Message); return; } }