protected void btnPass_Click(object sender, System.EventArgs e) { Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oDetailPage.TableDetail.SQL_TableName, Request["RowGuid"]); oRow["DelStatus"] = "1"; oRow.Update(); //AlertAjaxMessage("操作成功"); tabOP.Visible = false; //删除待办事宜 new HTProject_Bizlogic.DB_Messages_Center().WaitHandle_Delete("人员信息审核", Request["RowGuid"]); AlertAjaxMessage("操作成功"); //添加短信 string IsSendSMS = ApplicationOperate.GetConfigValueByName("IsSendOUSMS"); if (IsSendSMS == "1") { Detail_RG_User D_R_User = DB_R_User.GetDetail(TJRGuid_2019.Text); if (D_R_User.Mobile != "") { HTSMS.SendSMS(this.DisplayName, D_R_User.DispName, "您提交的" + XM_2019.Text + "的离职申请已审核通过,请及时关注,谢谢", D_R_User.Mobile); } } this.WriteAjaxMessage("refreshParent();"); this.WriteAjaxMessage("window.close();"); }
protected void btnNo_Click(object sender, System.EventArgs e) { string RowGuid = Request["RowGuid"]; string DWGuid = Request["DWGuid"]; //先将原来的设置为历史记录 Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oDetailPage.TableDetail.SQL_TableName, Request["RowGuid"]); oRow["Status"] = EpointRegisterUser_Bizlogic.OUStatus.通过; oRow["CheckUserName"] = this.DisplayName; oRow["CheckUserGuid"] = this.UserGuid; oRow["CheckTime"] = DateTime.Now; oRow.Update(); btnNo.Visible = false; btnYes.Visible = false; #region 步附件 CL.UpdateCaiLiaoProjectGuid(DWGuid, "企业-注册商标", DWGuid); CL.UpdateCaiLiaoProjectGuid(DWGuid, "企业-Logo", DWGuid); CL.UpdateCaiLiaoProjectGuid(DWGuid, "企业-公司介绍", DWGuid); CL.UpdateCaiLiaoProjectGuid(DWGuid, "企业-证书", DWGuid); #endregion if (!String.IsNullOrEmpty(Request["MessageItemGuid"])) { msg.WaitHandle_Delete(Request["MessageItemGuid"]); } WriteAjaxMessage("refreshParent();alert('审核不通过');window.close();"); }
protected void Check_Click(object sender, EventArgs e) { Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oDetailPage.TableDetail.SQL_TableName, Request["RowGuid"]);//<a href='http://www.baidu.com'>点击激活</a> oRow["UserStatus"] = "002"; //oRow["IsValid"] = "1"; oRow.Update(); new ComDataSyn().UpdateWithKeyValue(DataSynTarget.BackEndToFront, "RG_User", "RowGuid", Request["RowGuid"]); string EncryptedUserGuid = SymmetricMethod.Encrypto(Request["RowGuid"]); string Addr = System.Configuration.ConfigurationManager.AppSettings["Addr"].ToString(); string SmtpServer = System.Configuration.ConfigurationManager.AppSettings["SmtpServer"].ToString(); string EmailFrom = System.Configuration.ConfigurationManager.AppSettings["EmailFrom"].ToString(); string EmailAccount = System.Configuration.ConfigurationManager.AppSettings["EmailAccount"].ToString(); string EmailPassword = System.Configuration.ConfigurationManager.AppSettings["EmailPassword"].ToString(); string time = SymmetricMethod.Encrypto(System.DateTime.Now.ToString()); string ActivationAddr = Addr + "?UserGuid=" + EncryptedUserGuid + "&SendTime=" + time; Boolean IsSendSuccess = usermail.sendMail(SmtpServer, EmailAccount, EmailPassword, EmailFrom, oRow["EMail"].ToString(), "请点击链接激活您的会员账号!", "如果不能直接点击,请右键打开新窗口……\r\n <a href='" + ActivationAddr + "'>点击激活</a>"); if (!IsSendSuccess) { AlertAjaxMessage("激活邮件发送失败!"); return; } if (oRow["EnableSMS"].ToString() == "1") { string VerifyCode = CreateRnd(6); string content = "请使用以下验证码激活账号:" + VerifyCode; Epoint.MisBizLogic2.DB.ExecuteNonQuery("update RG_User set VerifyCode='" + VerifyCode + "',SendVCodeDate='" + System.DateTime.Now.ToString() + "' where RowGuid='" + Request["RowGuid"] + "'"); new ComDataSyn().UpdateWithKeyValue(DataSynTarget.BackEndToFront, "RG_User", "RowGuid", Request["RowGuid"]); string SendMobilephone = System.Configuration.ConfigurationManager.AppSettings["SendMobilephone"].ToString(); string SystemID = System.Configuration.ConfigurationManager.AppSettings["SystemID"].ToString(); SMS_Send.SendSMS("管理员", SendMobilephone, oRow["Mobile"].ToString(), content, SystemID); } this.AlertAjaxMessage("审核完成!"); this.WriteAjaxMessage("refreshParent();window.close();"); }
protected void UpdateStatus(string CID, string CGuid) { Epoint.MisBizLogic2.Data.MisGuidRow oRow; // = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, Request["RowGuid"]); string TableName = ""; string lb = CID.Substring(0, 2); if (lb == "QY") { TableName = "RG_OUInfo"; } else if (lb == "RY") { TableName = "RG_QYUser"; } else if (lb == "ZZ") { TableName = "RG_QiYeZiZhi"; } else if (lb == "XM") { TableName = "RG_XMBeiAn"; } else { TableName = "RG_OUInfo"; } oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(TableName, CGuid.Replace(CID, "")); if (oRow["Status"].ToString() == "90")//如果已经通过,当附件变化是,变成变更中 { oRow["Status"] = "85"; oRow.Update(); } }
protected void btnPass_Click(object sender, System.EventArgs e) { Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oDetailPage.TableDetail.SQL_TableName, Request["RowGuid"]); oRow["Status"] = "90"; oRow.Update(); //AlertAjaxMessage("�����ɹ�"); string Opinion = "���ͨ��"; if (SHOpinion.Text.Trim() != "") { Opinion += "��������Ϊ��" + Epoint.MisBizLogic2.DB.SQL_Encode(SHOpinion.Text.Trim()); } RG_DW.InsertSHOpinion(Request["RowGuid"], this.DisplayName, Opinion, ""); //AlertAjaxMessage("�����ɹ�"); tabOP.Visible = false; //ɾ���������� new HTProject_Bizlogic.DB_Messages_Center().WaitHandle_Delete("�����ҵ����", Request["RowGuid"]); AlertAjaxMessage("�����ɹ�"); //��Ӷ��� string IsSendSMS = ApplicationOperate.GetConfigValueByName("IsSendOUSMS"); if (IsSendSMS == "1") { Detail_RG_User D_R_User = DB_R_User.GetDetail(TJRGuid_2020.Text); if (D_R_User.Mobile != "") { HTSMS.SendSMS(this.DisplayName, D_R_User.DispName, "���ύ��" + ZiZhiText_2020.Text + "��������Ϣ�����ͨ�����뼰ʱ��ע��лл", D_R_User.Mobile); } } this.WriteAjaxMessage("refreshParent();"); this.WriteAjaxMessage("window.close();"); }
protected void btnNo_Click(object sender, System.EventArgs e) { string RowGuid = Request["RowGuid"]; string DWGuid = Request["DWGuid"]; //�Ƚ�ԭ��������Ϊ��ʷ��¼ Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oDetailPage.TableDetail.SQL_TableName, Request["RowGuid"]); oRow["Status"] = EpointRegisterUser_Bizlogic.OUStatus.��ͨ��; oRow["CheckUserName"] = this.DisplayName; oRow["CheckUserGuid"] = this.UserGuid; oRow["CheckTime"] = DateTime.Now; oRow.Update(); btnNo.Visible = false; btnYes.Visible = false; #region ͬ������ CL.UpdateCaiLiaoProjectGuid(DWGuid, "��ҵ-��̬����", DWGuid); CL.UpdateCaiLiaoProjectGuid(DWGuid, "��ҵ-Ӫҵִ��", DWGuid); CL.UpdateCaiLiaoProjectGuid(DWGuid, "��ҵ-˰��Ǽ�֤��", DWGuid); CL.UpdateCaiLiaoProjectGuid(DWGuid, "��ҵ-��֯��������֤", DWGuid); CL.UpdateCaiLiaoProjectGuid(DWGuid, "��ҵ-������֤��", DWGuid); #endregion if (!String.IsNullOrEmpty(Request["MessageItemGuid"])) { msg.WaitHandle_Delete(Request["MessageItemGuid"]); } WriteAjaxMessage("refreshParent();alert('��˲�ͨ��');window.close();"); }
protected void btnNoPass_Click(object sender, System.EventArgs e) { Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oDetailPage.TableDetail.SQL_TableName, Request["RowGuid"]); oRow["Status"] = "80"; oRow.Update(); string Opinion = "审核不通过"; if (SHOpinion.Text.Trim() != "") { Opinion += ",审核意见为:" + Epoint.MisBizLogic2.DB.SQL_Encode(SHOpinion.Text.Trim()); } RG_DW.InsertSHOpinion(Request["RowGuid"], this.DisplayName, Opinion, ""); tabOP.Visible = false; //AlertAjaxMessage("操作成功"); //删除待办事宜 new HTProject_Bizlogic.DB_Messages_Center().WaitHandle_Delete("备案信息审核", Request["RowGuid"]); AlertAjaxMessage("操作成功"); //添加短信 string IsSendSMS = ApplicationOperate.GetConfigValueByName("IsSendOUSMS"); if (IsSendSMS == "1") { Detail_RG_User D_R_User = DB_R_User.GetDetail(TJRGuid_2021.Text); if (D_R_User.Mobile != "") { HTSMS.SendSMS(this.DisplayName, D_R_User.DispName, "您提交的" + XMName_2021.Text + "的项目备案信息审核未通过,请及时关注,谢谢", D_R_User.Mobile); } } this.WriteAjaxMessage("refreshParent();"); this.WriteAjaxMessage("window.close();"); }
protected void btSubmit_Click(object sender, System.EventArgs e) { //�Ƚ�ԭ����ɾ������ֹ�ظ� new HTProject_Bizlogic.DB_Messages_Center().DeleteWH("�����ҵ", Request["RowGuid"]); RegistAddress_2017.Text = RegionTreeView.Text; RegistAddressCode_2017.Text = RegionTreeView.Value; TJRGuid_2017.Text = this.UserGuid; //Status_2017.Text = "70"; oEditPage.SaveTableValues(Request["RowGuid"], tdContainer); Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, Request["RowGuid"]); oRow["Status"] = "70"; oRow["UpdateUserName"] = this.DisplayName; oRow["UpdateUserGuid"] = this.UserGuid; oRow["UpdateTime"] = DateTime.Now.ToString(); oRow.Update(); //this.WriteAjaxMessage("refreshParent();"); //this.WriteAjaxMessage("EP_ShowMessageDiv(" + tdContainer.ClientID + ",'���ݱ���ɹ�')"); //���ʹ�������ˣ����ݽ�ɫ�� DataView dv = DBF.GetUserByRoleName("��ҵ��Ϣ���"); for (int m = 0; m < dv.Count; m++) { string messageGuid = Guid.NewGuid().ToString(); new HTProject_Bizlogic.DB_Messages_Center().WaitHandle_Insert(messageGuid, EnterpriseName_2017.Text + "��Ϣ���", "", dv[m]["UserGuid"].ToString(), dv[m]["DisplayName"].ToString(), "", "", "", @"HTProject/Pages/RG_OU/RG_OU_All_Detail.aspx?stype=shenhe&RowGuid=" + Request["RowGuid"], "", "", 1, "", "", "" ); //���±�־λ string strSql = "update messages_center set PType='�����ҵ',PGuid='"+ Request["RowGuid"] +"' where MessageItemGuid='" + messageGuid + "'"; Epoint.MisBizLogic2.DB.ExecuteNonQuery(strSql); //��Ӷ��� string IsSendADSMS = ApplicationOperate.GetConfigValueByName("IsSendADSMS"); if (IsSendADSMS == "1") { if (dv[m]["Mobile"].ToString() != "") { HTSMS.SendSMS(this.DisplayName, dv[m]["DisplayName"], EnterpriseName_2017.Text + "�ύ��ҵ��Ϣ���", dv[m]["Mobile"]); } } } AlertAjaxMessage("�ύ�ɹ�"); this.WriteAjaxMessage("refreshParent();window.close();"); }
protected void btSubmit_Click(object sender, System.EventArgs e) { //先将原来的删除,防止重复 new HTProject_Bizlogic.DB_Messages_Center().DeleteWH("审核企业", Request["RowGuid"]); RegistAddress_2017.Text = RegionTreeView.Text; RegistAddressCode_2017.Text = RegionTreeView.Value; TJRGuid_2017.Text = this.UserGuid; //Status_2017.Text = "70"; oEditPage.SaveTableValues(Request["RowGuid"], tdContainer); Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, Request["RowGuid"]); oRow["Status"] = "70"; oRow["UpdateUserName"] = this.DisplayName; oRow["UpdateUserGuid"] = this.UserGuid; oRow["UpdateTime"] = DateTime.Now.ToString(); oRow.Update(); //this.WriteAjaxMessage("refreshParent();"); //this.WriteAjaxMessage("EP_ShowMessageDiv(" + tdContainer.ClientID + ",'数据保存成功')"); //发送待审核事宜,根据角色来 DataView dv = DBF.GetUserByRoleName("企业信息审核"); for (int m = 0; m < dv.Count; m++) { string messageGuid = Guid.NewGuid().ToString(); new HTProject_Bizlogic.DB_Messages_Center().WaitHandle_Insert(messageGuid, EnterpriseName_2017.Text + "信息审核", "", dv[m]["UserGuid"].ToString(), dv[m]["DisplayName"].ToString(), "", "", "", @"HTProject/Pages/RG_OU/RG_OU_All_Detail.aspx?stype=shenhe&RowGuid=" + Request["RowGuid"], "", "", 1, "", "", "" ); //更新标志位 string strSql = "update messages_center set PType='审核企业',PGuid='" + Request["RowGuid"] + "' where MessageItemGuid='" + messageGuid + "'"; Epoint.MisBizLogic2.DB.ExecuteNonQuery(strSql); //添加短信 string IsSendADSMS = ApplicationOperate.GetConfigValueByName("IsSendADSMS"); if (IsSendADSMS == "1") { if (dv[m]["Mobile"].ToString() != "") { HTSMS.SendSMS(this.DisplayName, dv[m]["DisplayName"], EnterpriseName_2017.Text + "提交企业信息审核", dv[m]["Mobile"]); } } } AlertAjaxMessage("提交成功"); this.WriteAjaxMessage("refreshParent();window.close();"); }
/// <summary> /// 保存单位类别 /// </summary> /// <summary> /// 初始化信息 /// </summary> //protected void InitUser() //{ // Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, Request["RowGuid"]); // if (UserType_2010.SelectedItem.Value == "001") // { // // 如果RG_会员类别是个人会员,不需要显示所属单位和单位信息 // trOUInfo.Visible = false; // trDanwei.Style["display"] = "none"; // } // else if (UserType_2010.SelectedItem.Value == "002") // { // // 如果RG_会员类别是单位管理员,不需要显示所属单位 // trDanwei.Style["display"] = "none"; // Epoint.MisBizLogic2.Data.MisGuidRow arow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_OUInfo", oRow["DanWeiGuid"].ToString()); // EnterpriseName.Text = arow["EnterpriseName"].ToString(); // CodeCertificate.Text = arow["CodeCertificate"].ToString(); // LegalPerson.Text = arow["LegalPerson"].ToString(); // RegionCharacter.Text = arow["RegionCharacter"].ToString(); // BusinessLicenseNO.Text = arow["BusinessLicenseNO"].ToString(); // Contacter.Text = arow["Contacter"].ToString(); // Tel.Text = arow["Tel"].ToString(); // ContacterID.Text = arow["ContacterID"].ToString(); // Email.Text = arow["Email"].ToString(); // Address.Text = arow["Address"].ToString(); // RegistAddress.Text = arow["RegistAddress"].ToString(); // ((EpointNetoffice7.Ascx.CtlMisAttachments)AttachGuid).AttachGroupGuid = arow["AttachGuid"].ToString(); // BeiZhu.Text = arow["BeiZhu"].ToString(); // if (!string.IsNullOrEmpty(oRow["DanWeiGuid"].ToString())) // BindOuType(oRow["DanWeiGuid"].ToString()); // } // else if (UserType_2010.SelectedItem.Value == "003") // { // // 如果RG_会员类别是单位子账号,不需要显示单位信息,但是需要显示所属单位 // trOUInfo.Visible = false; // // 绑定所属单位 // if (string.IsNullOrEmpty(ApplyDanWeiGuid)) // { // // 绑定所属单位 // DataView dv = Epoint.MisBizLogic2.DB.ExecuteDataView("select EnterpriseName, RowGuid from RG_OUInfo WHERE DelFlag=0"); // dpDanWeiGuid.DataSource = dv; // dpDanWeiGuid.DataTextField = "EnterpriseName"; // dpDanWeiGuid.DataValueField = "RowGuid"; // dpDanWeiGuid.DataBind(); // dpDanWeiGuid.Items.Insert(0, new ListItem("", "")); // dpDanWeiGuid.SelectedValue = DanWeiGuid_2010.Text; // } // else // { // DanWeiGuid_2010.Text = ApplyDanWeiGuid; // trDanwei.Style["display"] = "none"; // } // } //} ///// <summary> ///// 绑定角色 ///// </summary> //protected void BindRoleName() //{ // DataView dv = Epoint.MisBizLogic2.DB.ExecuteDataView("select RoleName,RowGuid from RG_Role where UserType='" + UserType_2010.SelectedItem.Value + "'"); // if (dv.Count > 0) // { // jpdRoleName.DataSource = dv; // jpdRoleName.DataTextField = "RoleName"; // jpdRoleName.DataValueField = "RowGuid"; // jpdRoleName.DataBind(); // string RowGuid = Request["RowGuid"]; // DataView dv2 = Epoint.MisBizLogic2.DB.ExecuteDataView("select RoleGuid from RG_User_Role where RGUserGUID='" + RowGuid + "'"); // foreach (DataRowView row in dv2) // { // foreach (ListItem item in jpdRoleName.Items) // { // if (Convert.ToString(row[0]) == item.Value) // item.Selected = true; // } // } // } // else // { // trRoleList.Style["display"] = "none"; // } //} //protected void UserType_2010_SelectedIndexChanged(object sender, EventArgs e) //{ // BindRoleName(); // InitUser(); //} //protected void dpDanWeiGuid_SelectedIndexChanged(object sender, EventArgs e) //{ // BindOuType(); //} /// <summary> /// 初始化密码 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnInitPwd_Click(object sender, EventArgs e) { Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_User", Request["RowGuid"]); if (oRow.R_HasFilled) { string pwd = "11111"; oRow["Password"] = common.authPassword(pwd); oRow.Update(); AlertAjaxMessage("初始化密码成功。"); new ComDataSyn().UpdateWithKeyValue(DataSynTarget.BackEndToFront, "RG_User", "RowGuid", Request["RowGuid"]); } }
protected void btnPass_Click(object sender, System.EventArgs e) { //判断人员和资质是否有没有审核的 string strSql = "SELECT COUNT(*) FROM RG_QiYeZiZhi WHERE Status='70' AND DelStatus=0 AND DWGuid='" + Request["RowGuid"] + "'"; //if (Epoint.MisBizLogic2.DB.ExecuteToInt(strSql) > 0) //{ // AlertAjaxMessage("存在未审核的企业资质"); // return; //} //strSql = "SELECT COUNT(*) FROM RG_QYUser WHERE Status='70' AND DelStatus=0 AND DWGuid='" + Request["RowGuid"] + "'"; //if (Epoint.MisBizLogic2.DB.ExecuteToInt(strSql) > 0) //{ // AlertAjaxMessage("存在未审核的企业人员"); // return; //} Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oDetailPage.TableDetail.SQL_TableName, Request["RowGuid"]); oRow["Status"] = "90"; oRow["TG_Date"] = DateTime.Now.ToString(); oRow.Update(); //AlertAjaxMessage("操作成功"); string Opinion = "审核通过"; if (SHOpinion.Text.Trim() != "") { Opinion += ",审核意见为:" + Epoint.MisBizLogic2.DB.SQL_Encode(SHOpinion.Text.Trim()); } RG_DW.InsertSHOpinion(Request["RowGuid"], this.DisplayName, Opinion, ""); //AlertAjaxMessage("操作成功"); tabOP.Visible = false; //删除待办事宜 new HTProject_Bizlogic.DB_Messages_Center().WaitHandle_Delete("审核企业", Request["RowGuid"]); AlertAjaxMessage("操作成功"); //添加短信 string IsSendSMS = ApplicationOperate.GetConfigValueByName("IsSendOUSMS"); if (IsSendSMS == "1") { Detail_RG_User D_R_User = DB_R_User.GetDetail(TJRGuid_2017.Text); if (D_R_User.Mobile != "") { HTSMS.SendSMS(this.DisplayName, D_R_User.DispName, "您提交的企业信息已审核通过,请及时关注,谢谢", D_R_User.Mobile); } } this.WriteAjaxMessage("refreshParent();"); this.WriteAjaxMessage("window.close();"); }
protected void btnEdit_Click(object sender, System.EventArgs e) { Status_2017.Text = "85";//����� RegistAddress_2017.Text = RegionTreeView.Text; RegistAddressCode_2017.Text = RegionTreeView.Value; oEditPage.SaveTableValues(Request["RowGuid"], tdContainer); Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, Request["RowGuid"]); oRow["Status"] = "85"; oRow.Update(); if (ApplicationOperate.GetConfigValueByName("IsHoldCurPage", "0") == "1") this.WriteAjaxMessage("refreshParentHoldCurPage();"); else this.WriteAjaxMessage("refreshParent();"); this.WriteAjaxMessage("EP_ShowMessageDiv(" + tdContainer.ClientID + ",'���ݱ���ɹ�')"); }
protected void btnSave_Click(object sender, EventArgs e) { for (int i = 0; i < Datagrid1.Items.Count; i++) { TextBox txtName = (TextBox)Datagrid1.Items[i].FindControl("txtName"); TextBox txtAddress = (TextBox)Datagrid1.Items[i].FindControl("txtAddress"); // TextBox txtOrderNum = (TextBox)Datagrid1.Items[i].FindControl("txtOrderNum"); string gd = Convert.ToString(Datagrid1.DataKeys[i]); Epoint.MisBizLogic2.Data.MisGuidRow orow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_ShortcutMenu", gd); orow["ShortcutText"] = txtName.Text; orow["ShortcutUrl"] = txtAddress.Text; orow.Update(); new ComDataSyn().UpdateWithKeyValue(DataSynTarget.BackEndToFront, "RG_ShortcutMenu", "RowGuid", gd); } this.RefreshGrid(); }
protected void btnPass_Click(object sender, System.EventArgs e) { Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oDetailPage.TableDetail.SQL_TableName, Request["RowGuid"]); oRow["Status"] = "90"; oRow["CheckUserName"] = this.DisplayName; oRow["CheckUserGuid"] = this.UserGuid; oRow["CheckTime"] = DateTime.Now.ToString(); oRow.Update(); //AlertAjaxMessage("�����ɹ�"); btnNoPass.Visible = false; btnPass.Visible = false; //ɾ���������� new HTProject_Bizlogic.DB_Messages_Center().WaitHandle_Delete("�����ҵ", Request["RowGuid"]); AlertAjaxMessage("�����ɹ�"); this.WriteAjaxMessage("refreshParent();"); this.WriteAjaxMessage("window.close();"); }
/// <summary> /// 保存单位类别 /// </summary> /// <summary> /// 初始化信息 /// </summary> //protected void InitUser() //{ // Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, Request["RowGuid"]); // if (UserType_2010.SelectedItem.Value == "001") // { // // 如果RG_会员类别是个人会员,不需要显示所属单位和单位信息 // trOUInfo.Visible = false; // trDanwei.Style["display"] = "none"; // } // else if (UserType_2010.SelectedItem.Value == "002") // { // // 如果RG_会员类别是单位管理员,不需要显示所属单位 // trDanwei.Style["display"] = "none"; // Epoint.MisBizLogic2.Data.MisGuidRow arow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_OUInfo", oRow["DanWeiGuid"].ToString()); // EnterpriseName.Text = arow["EnterpriseName"].ToString(); // CodeCertificate.Text = arow["CodeCertificate"].ToString(); // LegalPerson.Text = arow["LegalPerson"].ToString(); // RegionCharacter.Text = arow["RegionCharacter"].ToString(); // BusinessLicenseNO.Text = arow["BusinessLicenseNO"].ToString(); // Contacter.Text = arow["Contacter"].ToString(); // Tel.Text = arow["Tel"].ToString(); // ContacterID.Text = arow["ContacterID"].ToString(); // Email.Text = arow["Email"].ToString(); // Address.Text = arow["Address"].ToString(); // RegistAddress.Text = arow["RegistAddress"].ToString(); // ((EpointNetoffice7.Ascx.CtlMisAttachments)AttachGuid).AttachGroupGuid = arow["AttachGuid"].ToString(); // BeiZhu.Text = arow["BeiZhu"].ToString(); // if (!string.IsNullOrEmpty(oRow["DanWeiGuid"].ToString())) // BindOuType(oRow["DanWeiGuid"].ToString()); // } // else if (UserType_2010.SelectedItem.Value == "003") // { // // 如果RG_会员类别是单位子账号,不需要显示单位信息,但是需要显示所属单位 // trOUInfo.Visible = false; // // 绑定所属单位 // if (string.IsNullOrEmpty(ApplyDanWeiGuid)) // { // // 绑定所属单位 // DataView dv = Epoint.MisBizLogic2.DB.ExecuteDataView("select EnterpriseName, RowGuid from RG_OUInfo WHERE DelFlag=0"); // dpDanWeiGuid.DataSource = dv; // dpDanWeiGuid.DataTextField = "EnterpriseName"; // dpDanWeiGuid.DataValueField = "RowGuid"; // dpDanWeiGuid.DataBind(); // dpDanWeiGuid.Items.Insert(0, new ListItem("", "")); // dpDanWeiGuid.SelectedValue = DanWeiGuid_2010.Text; // } // else // { // DanWeiGuid_2010.Text = ApplyDanWeiGuid; // trDanwei.Style["display"] = "none"; // } // } //} ///// <summary> ///// 绑定角色 ///// </summary> //protected void BindRoleName() //{ // DataView dv = Epoint.MisBizLogic2.DB.ExecuteDataView("select RoleName,RowGuid from RG_Role where UserType='" + UserType_2010.SelectedItem.Value + "'"); // if (dv.Count > 0) // { // jpdRoleName.DataSource = dv; // jpdRoleName.DataTextField = "RoleName"; // jpdRoleName.DataValueField = "RowGuid"; // jpdRoleName.DataBind(); // string RowGuid = Request["RowGuid"]; // DataView dv2 = Epoint.MisBizLogic2.DB.ExecuteDataView("select RoleGuid from RG_User_Role where RGUserGUID='" + RowGuid + "'"); // foreach (DataRowView row in dv2) // { // foreach (ListItem item in jpdRoleName.Items) // { // if (Convert.ToString(row[0]) == item.Value) // item.Selected = true; // } // } // } // else // { // trRoleList.Style["display"] = "none"; // } //} //protected void UserType_2010_SelectedIndexChanged(object sender, EventArgs e) //{ // BindRoleName(); // InitUser(); //} //protected void dpDanWeiGuid_SelectedIndexChanged(object sender, EventArgs e) //{ // BindOuType(); //} /// <summary> /// 初始化密码 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnInitPwd_Click(object sender, EventArgs e) { Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_User", this.UserGuid); if (oRow.R_HasFilled) { //要更新为企业的组织结构代码 //string pwd = "11111"; string RGID = Epoint.MisBizLogic2.DB.ExecuteToString("select ZuZhiJGDM from RG_OUInfo where RowGuod='" + DanWeiGuid_2010.Text + "'"); if (RGID == "") { RGID = "11111"; } oRow["Password"] = common.authPassword(RGID); oRow.Update(); AlertAjaxMessage("初始化密码成功。新密码为:" + RGID); new ComDataSyn().UpdateWithKeyValue(DataSynTarget.BackEndToFront, "RG_User", "RowGuid", this.UserGuid); } }
protected void btnPass_Click(object sender, System.EventArgs e) { Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oDetailPage.TableDetail.SQL_TableName, Request["RowGuid"]); oRow["Status"] = "90"; oRow["CheckUserName"] = this.DisplayName; oRow["CheckUserGuid"] = this.UserGuid; oRow["CheckTime"] = DateTime.Now.ToString(); oRow.Update(); //AlertAjaxMessage("操作成功"); btnNoPass.Visible = false; btnPass.Visible = false; //删除待办事宜 new HTProject_Bizlogic.DB_Messages_Center().WaitHandle_Delete("审核企业", Request["RowGuid"]); AlertAjaxMessage("操作成功"); this.WriteAjaxMessage("refreshParent();"); this.WriteAjaxMessage("window.close();"); }
protected void btnEdit_Click(object sender, System.EventArgs e) { //UserIdendity_2010.Text = txtUserIdendity.Text; string RowGuid = rgUser.GetCurrentRegisterUser().RegisterUserGuid; Boolean UserExisted = Epoint.MisBizLogic2.DB.ExecuteToInt("select count(RowGuid) from RG_User where LoginID='" + LoginID_2010.Text + "' and RowGuid<>'" + RowGuid + "'") > 1; if (UserExisted) { AlertAjaxMessage("�õ�¼���ѱ�ʹ��,���ĵ�¼����"); return; } oEditPage.SaveTableValues(rgUser.GetCurrentRegisterUser().RegisterUserGuid, tdContainer); //new ComDataSyn().UpdateWithKeyValue(DataSynTarget.FrontToBackEnd, "RG_User", "RowGuid", rgUser.GetCurrentRegisterUser().RegisterUserGuid); Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, RowGuid); oRow["UserStatus"] = "002"; //oRow["DanWeiGuid"] = DanWeiGuid_2010.Text; oRow.Update(); this.WriteAjaxMessage("location.reload();EP_ShowMessageDiv(" + tdContainer.ClientID + ",'���ݱ���ɹ�')"); }
protected void btnSave_Click(object sender, EventArgs e) { for (int i = 0; i < Datagrid1.Items.Count; i++) { TextBox txtName = (TextBox)Datagrid1.Items[i].FindControl("txtName"); TextBox txtUrl = (TextBox)Datagrid1.Items[i].FindControl("txtUrl"); TextBox txtShortcut = (TextBox)Datagrid1.Items[i].FindControl("txtShortcut"); TextBox txtOrderNum = (TextBox)Datagrid1.Items[i].FindControl("txtOrderNum"); string gd = Convert.ToString(Datagrid1.DataKeys[i]); Epoint.MisBizLogic2.Data.MisGuidRow orow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_Application", gd); orow["AppName"] = txtName.Text; orow["AppUrl"] = txtUrl.Text; orow["ShortcutText"] = txtShortcut.Text; orow["OrderNum"] = txtOrderNum.Text; new ComDataSyn().UpdateWithKeyValue(DataSynTarget.BackEndToFront, "RG_Application", "AppGuid", gd); orow.Update(); } }
protected void btnSave_Click(object sender, EventArgs e) { for (int i = 0; i < Datagrid1.Items.Count; i++) { TextBox txtName = (TextBox)Datagrid1.Items[i].FindControl("txtName"); TextBox txtAddress = (TextBox)Datagrid1.Items[i].FindControl("txtAddress"); TextBox txtOrderNum = (TextBox)Datagrid1.Items[i].FindControl("txtOrderNum"); string gd = Convert.ToString(Datagrid1.DataKeys[i]); Epoint.MisBizLogic2.Data.MisGuidRow orow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_Matters", gd); orow["MatterName"] = txtName.Text; orow["MatterUrl"] = txtAddress.Text; orow["OrderNum"] = txtOrderNum.Text; orow.Update(); new ComDataSyn().UpdateWithKeyValue(DataSynTarget.BackEndToFront, "RG_Matters", "RowGuid", gd); } // new ComDataSyn().UpdateWithCondition(DataSynTarget.BackEndToFront, "RG_Matters", "ParentGuid='" + ParentGuid + "'and AppGuid='" + AppGuid + "'", "RowGuid"); AlertAjaxMessage("修改成功!"); this.RefreshGrid(); }
protected void btnEdit_Click(object sender, System.EventArgs e) { Status_2017.Text = "85";//变更中 RegistAddress_2017.Text = RegionTreeView.Text; RegistAddressCode_2017.Text = RegionTreeView.Value; oEditPage.SaveTableValues(Request["RowGuid"], tdContainer); Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, Request["RowGuid"]); oRow["Status"] = "85"; oRow.Update(); if (ApplicationOperate.GetConfigValueByName("IsHoldCurPage", "0") == "1") { this.WriteAjaxMessage("refreshParentHoldCurPage();"); } else { this.WriteAjaxMessage("refreshParent();"); } this.WriteAjaxMessage("EP_ShowMessageDiv(" + tdContainer.ClientID + ",'数据保存成功')"); }
protected void btnEdit_Click(object sender, System.EventArgs e) { //UserIdendity_2010.Text = txtUserIdendity.Text; string RowGuid = rgUser.GetCurrentRegisterUser().RegisterUserGuid; Boolean UserExisted = Epoint.MisBizLogic2.DB.ExecuteToInt("select count(RowGuid) from RG_User where LoginID='" + LoginID_2010.Text + "' and RowGuid<>'" + RowGuid + "'") > 1; if (UserExisted) { AlertAjaxMessage("该登录名已被使用,请修改登录名!"); return; } oEditPage.SaveTableValues(rgUser.GetCurrentRegisterUser().RegisterUserGuid, tdContainer); //new ComDataSyn().UpdateWithKeyValue(DataSynTarget.FrontToBackEnd, "RG_User", "RowGuid", rgUser.GetCurrentRegisterUser().RegisterUserGuid); Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, RowGuid); oRow["UserStatus"] = "002"; //oRow["DanWeiGuid"] = DanWeiGuid_2010.Text; oRow.Update(); this.WriteAjaxMessage("location.reload();EP_ShowMessageDiv(" + tdContainer.ClientID + ",'数据保存成功')"); }
protected void btnPass_Click(object sender, System.EventArgs e) { CheckBox chk; for (int i = 0; i < Datagrid1.Items.Count; i++) { chk = (CheckBox)Datagrid1.Items[i].FindControl("chkAdd"); if (chk.Checked) { Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_User", Convert.ToString(Datagrid1.DataKeys[i])); oRow["UserStatus"] = "002"; oRow["IsValid"] = "1"; oRow.Update(); new ComDataSyn().UpdateWithKeyValue(DataSynTarget.BackEndToFront, "RG_User", "RowGuid", Convert.ToString(Datagrid1.DataKeys[i])); } } this.AlertAjaxMessage("审核完成!"); this.RefreshGrid(); }
protected void btnNoPass_Click(object sender, System.EventArgs e) { //�ж���Ա�������Ƿ���û����˵� string strSql = "SELECT COUNT(*) FROM RG_QiYeZiZhi WHERE Status='70' AND DWGuid='" + Request["RowGuid"] + "'"; //if (Epoint.MisBizLogic2.DB.ExecuteToInt(strSql) > 0) //{ // AlertAjaxMessage("����δ��˵���ҵ����"); // return; //} //strSql = "SELECT COUNT(*) FROM RG_QYUser WHERE Status='70' AND DWGuid='" + Request["RowGuid"] + "'"; //if (Epoint.MisBizLogic2.DB.ExecuteToInt(strSql) > 0) //{ // AlertAjaxMessage("����δ��˵���ҵ��Ա"); // return; //} Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oDetailPage.TableDetail.SQL_TableName, Request["RowGuid"]); oRow["Status"] = "80"; oRow.Update(); string Opinion = "��˲�ͨ��"; if (SHOpinion.Text.Trim() != "") { Opinion += "��������Ϊ��" + Epoint.MisBizLogic2.DB.SQL_Encode(SHOpinion.Text.Trim()); } RG_DW.InsertSHOpinion(Request["RowGuid"], this.DisplayName, Opinion, ""); tabOP.Visible = false; //AlertAjaxMessage("�����ɹ�"); //ɾ���������� new HTProject_Bizlogic.DB_Messages_Center().WaitHandle_Delete("�����ҵ", Request["RowGuid"]); AlertAjaxMessage("�����ɹ�"); //��Ӷ��� string IsSendSMS = ApplicationOperate.GetConfigValueByName("IsSendOUSMS"); if (IsSendSMS == "1") { Detail_RG_User D_R_User = DB_R_User.GetDetail(TJRGuid_2017.Text); if (D_R_User.Mobile != "") { HTSMS.SendSMS(this.DisplayName, D_R_User.DispName, "���ύ����ҵ��Ϣ���в�����Ϣ���δͨ�����뼰ʱ��ע��лл", D_R_User.Mobile); } } this.WriteAjaxMessage("refreshParent();"); this.WriteAjaxMessage("window.close();"); }
protected void btnSave_Click(object sender, EventArgs e) { for (int i = 0; i < Datagrid1.Items.Count; i++) { TextBox txtName = (TextBox)Datagrid1.Items[i].FindControl("txtName"); TextBox txtAddress = (TextBox)Datagrid1.Items[i].FindControl("txtAddress"); TextBox txtOrderNum = (TextBox)Datagrid1.Items[i].FindControl("txtOrderNum"); string gd = Convert.ToString(Datagrid1.DataKeys[i]); Epoint.MisBizLogic2.Data.MisGuidRow orow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_Module", gd); orow["ModuleName"] = txtName.Text; orow["ModuleAddress"] = txtAddress.Text; orow["OrderNum"] = txtOrderNum.Text; orow.Update(); new ComDataSyn().UpdateWithKeyValue(DataSynTarget.BackEndToFront, "RG_Module", "RowGuid", gd); string ModuleGuid = gd; bool isExists = Epoint.MisBizLogic2.DB.ExecuteToInt("select COUNT(*) FROM RG_Module_Right WHERE AllowGuid='All' and ModuleGuid='" + ModuleGuid + "'") > 0; CheckBox chkAllowToAll = (CheckBox)Datagrid1.Items[i].FindControl("chkAdd2"); if (chkAllowToAll.Checked) { // 添加完全公开的配置 // 判断是否存在,如果存在,不需要添加配置 if (!isExists) { string RowGuid = Guid.NewGuid().ToString(); Epoint.MisBizLogic2.Data.MisGuidRow orow2 = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_Module_Right", RowGuid); orow2["ModuleGuid"] = ModuleGuid; orow2["AllowGuid"] = "All"; orow2["AllowType"] = ""; orow2.Insert(); new ComDataSyn().InsertWithKeyValue(DataSynTarget.BackEndToFront, "RG_Module_Right", "RowGuid", RowGuid); } } else { // 删除完全公开的配置 new ComDataSyn().DeleteWithCondition(DataSynTarget.BackEndToFront, "RG_Module_Right", "AllowGuid='All'and ModuleGuid='" + ModuleGuid + "'", "RowGuid"); Epoint.MisBizLogic2.DB.ExecuteNonQuery("delete from RG_Module_Right WHERE AllowGuid='All'and ModuleGuid='" + ModuleGuid + "'"); } } }
protected void btnAdd_Click(object sender, System.EventArgs e) { string RowGuid = Guid.NewGuid().ToString(); if (cardJPG.Text != "") { //CardIMG_2019.Text = Convert.FromBase64String(cardJPG.Text); CardImgType_2019.Text = "image/pjpeg"; } else { this.WriteAjaxMessage("alert('抱歉!请重新点击[读卡]读取照片后[保存]!');"); return; } //判断下身份证s是否已经有了 string oName = ""; if (RG_DW.IsExistByIDNO(IDNum_2019.Text.Trim(), out oName)) { this.WriteAjaxMessage("alert('该身份证已经存在,姓名为:" + oName + "');"); return; } DWGuid_2019.Text = Request["DWGuid"]; DelStatus_2019.SelectedValue = "0"; Status_2019.Text = "60"; string strSql = "select ZuZhiJGDM from RG_OUInfo where RowGuid='" + Request["DWGuid"] + "'"; ZuZhiJGDM_2019.Text = Epoint.MisBizLogic2.DB.ExecuteToString(strSql); if (oAddPage.SaveTableValues_CheckExist(RowGuid, tdContainer, Request.QueryString["ParentRowGuid"])) { if (cardJPG.Text != "") { Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oAddPage.TableDetail.SQL_TableName, RowGuid); //strSql = "UPDATE RG_QYUser SET CardIMG='" + Convert.FromBase64String(cardJPG.Text) + "' where RowGuid='" + RowGuid + "'"; //Epoint.MisBizLogic2.DB.ExecuteNonQuery(strSql); oRow["CardIMG"] = Convert.FromBase64String(cardJPG.Text); oRow.Update(); } this.WriteAjaxMessage("window.location.href='RG_QYUser_Edit_Card.aspx?RowGuid=" + RowGuid + "&DWGuid=" + Request["DWGuid"] + "';alert('保存成功');refreshParent();"); } }
protected void btnZS_Click(object sender, System.EventArgs e) { CheckBox chk; for (int i = 0; i < Datagrid1.Items.Count; i++) { chk = (CheckBox)Datagrid1.Items[i].FindControl("chkAdd"); if (chk.Checked) { //Epoint.MisBizLogic2.Data.CommonDataTable.DeleteRecord_FromSqlTable( // oListPage.TableID, // oListPage.TableDetail.SQL_TableName, // Convert.ToString(Datagrid1.DataKeys[i]) // ); Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oListPage.TableDetail.SQL_TableName, Convert.ToString(Datagrid1.DataKeys[i])); oRow["DelFlag"] = "1"; oRow.Update(); } } this.RefreshGrid(); }
protected void btnAdd_Click(object sender, System.EventArgs e) { string RowGuid = Guid.NewGuid().ToString(); if (cardJPG.Text != "") { //CardIMG_2019.Text = Convert.FromBase64String(cardJPG.Text); CardImgType_2019.Text = "image/pjpeg"; } else { this.WriteAjaxMessage("alert('��Ǹ�������µ��[����]��ȡ��Ƭ��[����]��');"); return; } //�ж������֤s�Ƿ��Ѿ����� string oName = ""; if(RG_DW.IsExistByIDNO(IDNum_2019.Text.Trim(),out oName)) { this.WriteAjaxMessage("alert('�����֤�Ѿ����ڣ�����Ϊ��" + oName + "');"); return; } DWGuid_2019.Text = Request["DWGuid"]; DelStatus_2019.SelectedValue = "0"; Status_2019.Text = "60"; string strSql = "select ZuZhiJGDM from RG_OUInfo where RowGuid='" + Request["DWGuid"] + "'"; ZuZhiJGDM_2019.Text = Epoint.MisBizLogic2.DB.ExecuteToString(strSql); if (oAddPage.SaveTableValues_CheckExist(RowGuid, tdContainer, Request.QueryString["ParentRowGuid"])) { if (cardJPG.Text != "") { Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oAddPage.TableDetail.SQL_TableName, RowGuid); //strSql = "UPDATE RG_QYUser SET CardIMG='" + Convert.FromBase64String(cardJPG.Text) + "' where RowGuid='" + RowGuid + "'"; //Epoint.MisBizLogic2.DB.ExecuteNonQuery(strSql); oRow["CardIMG"] = Convert.FromBase64String(cardJPG.Text); oRow.Update(); } this.WriteAjaxMessage("window.location.href='RG_QYUser_Edit_Card.aspx?RowGuid=" + RowGuid + "&DWGuid=" + Request["DWGuid"] + "';alert('����ɹ�');refreshParent();"); } }
protected void btnAdd_Click(object sender, System.EventArgs e) { //验证单位是否已存在 DataView dvDW = dbDW.CheckCodeForRowGuid("ZuZhiJGDM", ZuZhiJGDM_2017.Text.Trim()); if (dvDW.Count > 0) { this.AlertAjaxMessage("已存在相同组织机构代码的单位:" + dvDW[0]["EnterpriseName"].ToString()); return; } dvDW = dbDW.CheckCodeForRowGuid("YingYeZZ", YingYeZZ_2017.Text.Trim()); if (dvDW.Count > 0) { this.AlertAjaxMessage("已存在相同营业执照号码的单位:" + dvDW[0]["EnterpriseName"].ToString()); return; } string RowGuid = Guid.NewGuid().ToString(); Status_2017.Text = "60"; SMJZSJ_2017.Text = DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00"; if (oAddPage.SaveTableValues_CheckExist(RowGuid, tdContainer, Request.QueryString["ParentRowGuid"])) { //创建企业的用户 if (!dbUSER.CheckUserExist(ZuZhiJGDM_2017.Text.Trim())) { InsertUser(ZuZhiJGDM_2017.Text.Trim(), RowGuid, LianXiRen_2017.Text.Trim()); } this.WriteAjaxMessage("refreshParent();"); this.AlertAjaxMessage("数据保存成功!企业用户创建成功,登录名和密码均为组织结构代码证号"); this.WriteAjaxMessage("window.close();"); //更新下状态为编辑中 Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow("rg_ouinfo", RowGuid); oRow["Status"] = "60"; oRow["DelStatus"] = "0"; oRow["IsNDBA"] = "0"; oRow.Update(); } }
protected void btnSave_Click(Object sender, EventArgs args) { //�ж��������Ƿ���ȷ Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_User", rgUser.GetCurrentRegisterUser().RegisterUserGuid); if (Epoint.Frame.Bizlogic.common.authPassword(txtOldPwd.Text) != oRow["Password"].ToString()) { AlertAjaxMessage("����������벻��ȷ"); return; } // �ж��ظ������Ƿ���ȷ if (txtNewPwd.Text != txtRptPwd.Text) { AlertAjaxMessage("������������벻��ȷ"); return; } // �������� oRow["Password"] = Epoint.Frame.Bizlogic.common.authPassword(txtRptPwd.Text); oRow.Update(); new ComDataSyn().UpdateWithKeyValue(DataSynTarget.FrontToBackEnd, "RG_User", "RowGuid", rgUser.GetCurrentRegisterUser().RegisterUserGuid); AlertAjaxMessage("����ɹ�"); WriteAjaxMessage("window.close();"); }
protected void btnSave_Click(Object sender, EventArgs args) { //判断老密码是否正确 Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_User", rgUser.GetCurrentRegisterUser().RegisterUserGuid); if (Epoint.Frame.Bizlogic.common.authPassword(txtOldPwd.Text) != oRow["Password"].ToString()) { AlertAjaxMessage("输入的老密码不正确"); return; } // 判断重复密码是否正确 if (txtNewPwd.Text != txtRptPwd.Text) { AlertAjaxMessage("两次输入的密码不正确"); return; } // 保存密码 oRow["Password"] = Epoint.Frame.Bizlogic.common.authPassword(txtRptPwd.Text); oRow.Update(); new ComDataSyn().UpdateWithKeyValue(DataSynTarget.FrontToBackEnd, "RG_User", "RowGuid", rgUser.GetCurrentRegisterUser().RegisterUserGuid); AlertAjaxMessage("保存成功"); WriteAjaxMessage("window.close();"); }
protected void btnAdd_Click(object sender, System.EventArgs e) { //��֤��λ�Ƿ��Ѵ��� DataView dvDW = dbDW.CheckCodeForRowGuid("ZuZhiJGDM", ZuZhiJGDM_2017.Text.Trim()); if (dvDW.Count > 0) { this.AlertAjaxMessage("�Ѵ�����ͬ��֯��������ĵ�λ��" + dvDW[0]["EnterpriseName"].ToString()); return; } dvDW = dbDW.CheckCodeForRowGuid("YingYeZZ", YingYeZZ_2017.Text.Trim()); if (dvDW.Count > 0) { this.AlertAjaxMessage("�Ѵ�����ͬӪҵִ�պ���ĵ�λ��" + dvDW[0]["EnterpriseName"].ToString()); return; } string RowGuid = Guid.NewGuid().ToString(); Status_2017.Text = "60"; SMJZSJ_2017.Text = DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00"; if (oAddPage.SaveTableValues_CheckExist(RowGuid, tdContainer, Request.QueryString["ParentRowGuid"])) { //������ҵ���û� if (!dbUSER.CheckUserExist(ZuZhiJGDM_2017.Text.Trim())) { InsertUser(ZuZhiJGDM_2017.Text.Trim(), RowGuid, LianXiRen_2017.Text.Trim()); } this.WriteAjaxMessage("refreshParent();"); this.AlertAjaxMessage("���ݱ���ɹ�����ҵ�û������ɹ�����¼���������Ϊ��֯�ṹ����֤��"); this.WriteAjaxMessage("window.close();"); //������״̬Ϊ�༭�� Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow("rg_ouinfo", RowGuid); oRow["Status"] = "60"; oRow["DelStatus"] = "0"; oRow["IsNDBA"] = "0"; oRow.Update(); } }
/// <summary> /// ���浥λ��� /// </summary> /// <summary> /// ��ʼ����Ϣ /// </summary> //protected void InitUser() //{ // Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, Request["RowGuid"]); // if (UserType_2010.SelectedItem.Value == "001") // { // // ���RG_��Ա����Ǹ��˻�Ա������Ҫ��ʾ�����λ�͵�λ��Ϣ // trOUInfo.Visible = false; // trDanwei.Style["display"] = "none"; // } // else if (UserType_2010.SelectedItem.Value == "002") // { // // ���RG_��Ա����ǵ�λ����Ա������Ҫ��ʾ�����λ // trDanwei.Style["display"] = "none"; // Epoint.MisBizLogic2.Data.MisGuidRow arow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_OUInfo", oRow["DanWeiGuid"].ToString()); // EnterpriseName.Text = arow["EnterpriseName"].ToString(); // CodeCertificate.Text = arow["CodeCertificate"].ToString(); // LegalPerson.Text = arow["LegalPerson"].ToString(); // RegionCharacter.Text = arow["RegionCharacter"].ToString(); // BusinessLicenseNO.Text = arow["BusinessLicenseNO"].ToString(); // Contacter.Text = arow["Contacter"].ToString(); // Tel.Text = arow["Tel"].ToString(); // ContacterID.Text = arow["ContacterID"].ToString(); // Email.Text = arow["Email"].ToString(); // Address.Text = arow["Address"].ToString(); // RegistAddress.Text = arow["RegistAddress"].ToString(); // ((EpointNetoffice7.Ascx.CtlMisAttachments)AttachGuid).AttachGroupGuid = arow["AttachGuid"].ToString(); // BeiZhu.Text = arow["BeiZhu"].ToString(); // if (!string.IsNullOrEmpty(oRow["DanWeiGuid"].ToString())) // BindOuType(oRow["DanWeiGuid"].ToString()); // } // else if (UserType_2010.SelectedItem.Value == "003") // { // // ���RG_��Ա����ǵ�λ���˺ţ�����Ҫ��ʾ��λ��Ϣ��������Ҫ��ʾ�����λ // trOUInfo.Visible = false; // // �������λ // if (string.IsNullOrEmpty(ApplyDanWeiGuid)) // { // // �������λ // DataView dv = Epoint.MisBizLogic2.DB.ExecuteDataView("select EnterpriseName, RowGuid from RG_OUInfo WHERE DelFlag=0"); // dpDanWeiGuid.DataSource = dv; // dpDanWeiGuid.DataTextField = "EnterpriseName"; // dpDanWeiGuid.DataValueField = "RowGuid"; // dpDanWeiGuid.DataBind(); // dpDanWeiGuid.Items.Insert(0, new ListItem("", "")); // dpDanWeiGuid.SelectedValue = DanWeiGuid_2010.Text; // } // else // { // DanWeiGuid_2010.Text = ApplyDanWeiGuid; // trDanwei.Style["display"] = "none"; // } // } //} ///// <summary> ///// ��ɫ ///// </summary> //protected void BindRoleName() //{ // DataView dv = Epoint.MisBizLogic2.DB.ExecuteDataView("select RoleName,RowGuid from RG_Role where UserType='" + UserType_2010.SelectedItem.Value + "'"); // if (dv.Count > 0) // { // jpdRoleName.DataSource = dv; // jpdRoleName.DataTextField = "RoleName"; // jpdRoleName.DataValueField = "RowGuid"; // jpdRoleName.DataBind(); // string RowGuid = Request["RowGuid"]; // DataView dv2 = Epoint.MisBizLogic2.DB.ExecuteDataView("select RoleGuid from RG_User_Role where RGUserGUID='" + RowGuid + "'"); // foreach (DataRowView row in dv2) // { // foreach (ListItem item in jpdRoleName.Items) // { // if (Convert.ToString(row[0]) == item.Value) // item.Selected = true; // } // } // } // else // { // trRoleList.Style["display"] = "none"; // } //} //protected void UserType_2010_SelectedIndexChanged(object sender, EventArgs e) //{ // BindRoleName(); // InitUser(); //} //protected void dpDanWeiGuid_SelectedIndexChanged(object sender, EventArgs e) //{ // BindOuType(); //} /// <summary> /// ��ʼ������ /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnInitPwd_Click(object sender, EventArgs e) { Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_User", this.UserGuid); if (oRow.R_HasFilled) { //Ҫ����Ϊ��ҵ����֯�ṹ���� //string pwd = "11111"; string RGID = Epoint.MisBizLogic2.DB.ExecuteToString("select ZuZhiJGDM from RG_OUInfo where RowGuod='" + DanWeiGuid_2010.Text + "'"); if (RGID == "") { RGID = "11111"; } oRow["Password"] = common.authPassword(RGID); oRow.Update(); AlertAjaxMessage("��ʼ������ɹ���������Ϊ��" + RGID); new ComDataSyn().UpdateWithKeyValue(DataSynTarget.BackEndToFront, "RG_User", "RowGuid", this.UserGuid); } }
protected void btnEdit_Click(object sender, System.EventArgs e) { //oEditPage.SaveTableValues(Request["RowGuid"], tdContainer); //this.WriteAjaxMessage("refreshParent();"); //this.WriteAjaxMessage("EP_ShowMessageDiv(" + tdContainer.ClientID + ",'���ݱ���ɹ�')"); string RowGuid = Request["RowGuid"]; string DWGuid = Request["DWGuid"]; string strSql = "SELECT top(1) EnterpriseName FROM RG_OUInfo WHERE dwGuid='" + DWGuid + "' order by row_ID desc"; string EnterpriseName = Epoint.MisBizLogic2.DB.ExecuteToString(strSql); //�Ȼ�ȡͶ�ʾ��� strSql = "SELECT s_xiangmujl_guid,s_xiangmujl FROM VIEW_CurrentVersion WHERE dwGuid='" + DWGuid + "'"; DataView dvUser = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql); if (dvUser.Count == 0) { WriteAjaxMessage("����ҵû�ж�Ӧ����Ŀ������ϵϵͳ����Ա��"); return; } //�ж��Dz����Ѿ����� strSql = string.Format("select count(*) from RG_OtherInfo where DWGuid='{0}'", Request["DWGuid"]); if (Epoint.MisBizLogic2.DB.ExecuteToString(strSql) == "1")//˵��û�� { //�ύʱֱ���ύ�����ñ���汾 Year_2021.Text = ddlYear.SelectedValue; Month_2021.Text = ddlMonth.SelectedValue; YearMonth_2021.Text = ddlYear.SelectedValue + "-" + ddlMonth.SelectedValue + "-01 00:00:00"; UpdateUserName_2021.Text = this.DisplayName; UpdateUserGuid_2021.Text = this.UserGuid; UpdateTime_2021.Text = DateTime.Now.ToString(); Status_2021.Text = EpointRegisterUser_Bizlogic.OUStatus.�����; IsHistory_2021.Text = "0"; oEditPage.SaveTableValues(RowGuid, tdContainer); } else { //�Ƚ�ԭ��������Ϊ��ʷ��¼ Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, Request["RowGuid"]); oRow["IsHistory"] = "1"; //oRow["UpdateUserName"] = this.DisplayName; //oRow["UpdateUserGuid"] = this.UserGuid; //oRow["UpdateTime"] = DateTime.Now; oRow.Update(); //Ȼ���ٽ����汾�����ύ��� Year_2021.Text = ddlYear.SelectedValue; Month_2021.Text = ddlMonth.SelectedValue; YearMonth_2021.Text = ddlYear.SelectedValue + "-" + ddlMonth.SelectedValue + "-01 00:00:00"; UpdateUserName_2021.Text = this.DisplayName; UpdateUserGuid_2021.Text = this.UserGuid; UpdateTime_2021.Text = DateTime.Now.ToString(); Status_2021.Text = EpointRegisterUser_Bizlogic.OUStatus.�����; IsHistory_2021.Text = "0"; RowGuid = Guid.NewGuid().ToString(); oAddPage.SaveTableValues(RowGuid, tdContainer, Request.QueryString["ParentRowGuid"]); } #region ���渽�� CL_CWBB.MisRowGuid = DWGuid; CL_CWBB.MisTableID = TableID; CL_CWBB.ProjectGuid = ""; CL_CWBB.Comment = DWGuid; CL_CWBB.d_TiJiaoSJ = DateTime.Now.ToString(); CL_CWBB.Save(); CL_NDSJBG.MisRowGuid = DWGuid; CL_NDSJBG.MisTableID = TableID; CL_NDSJBG.ProjectGuid = ""; CL_NDSJBG.Comment = DWGuid; CL_NDSJBG.d_TiJiaoSJ = DateTime.Now.ToString(); CL_NDSJBG.Save(); #endregion #region ֪ͨͶ�ʾ��� for (int m = 0; m < dvUser.Count; m++) { msg.WaitHandle_Insert( Guid.NewGuid().ToString(), "����ˡ�" + EnterpriseName + "������Ҫ��������", "", dvUser[m]["s_xiangmujl_guid"].ToString(), dvUser[m]["s_xiangmujl"].ToString(), Session["UserGuid"].ToString(), Session["DisplayName"].ToString(), "", "EpointRegisterUser/Pages_RG/RG_Other/RG_OtherInfo_DetailForCheck.aspx?RowGuid=" + RowGuid + "&DWGuid=" + DWGuid, "", "", 1, "", "", "" ); } #endregion //this.WriteAjaxMessage("refreshParent();"); //this.WriteAjaxMessage("EP_ShowMessageDiv(" + tdContainer.ClientID + ",'���ݱ���ɹ�')"); this.WriteAjaxMessage("alert('�ύ�ɹ�');"); RefreshGrid(); btnEdit.Visible = false; }
protected void btnSave_Click(object sender, EventArgs e) { for (int i = 0; i < Datagrid1.Items.Count; i++) { TextBox txtName = (TextBox)Datagrid1.Items[i].FindControl("txtName"); TextBox txtAddress = (TextBox)Datagrid1.Items[i].FindControl("txtAddress"); // TextBox txtOrderNum = (TextBox)Datagrid1.Items[i].FindControl("txtOrderNum"); string gd = Convert.ToString(Datagrid1.DataKeys[i]); Epoint.MisBizLogic2.Data.MisGuidRow orow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_ShortcutMenu", gd); orow["ShortcutText"] = txtName.Text; orow["ShortcutUrl"] = txtAddress.Text; orow.Update(); new ComDataSyn().UpdateWithKeyValue(DataSynTarget.BackEndToFront, "RG_ShortcutMenu", "RowGuid", gd); } this.RefreshGrid(); }
protected void btnPass_Click(object sender, System.EventArgs e) { CheckBox chk; for (int i = 0; i < Datagrid1.Items.Count; i++) { chk = (CheckBox)Datagrid1.Items[i].FindControl("chkAdd"); if (chk.Checked) { Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_User", Convert.ToString(Datagrid1.DataKeys[i])); oRow["UserStatus"] = "002"; oRow["IsValid"] = "1"; oRow.Update(); new ComDataSyn().UpdateWithKeyValue(DataSynTarget.BackEndToFront, "RG_User", "RowGuid", Convert.ToString(Datagrid1.DataKeys[i])); } } this.AlertAjaxMessage("�����ɣ�"); this.RefreshGrid(); }
protected void btnEdit_Click(object sender, System.EventArgs e) { //oEditPage.SaveTableValues(Request["RowGuid"], tdContainer); //this.WriteAjaxMessage("refreshParent();"); //this.WriteAjaxMessage("EP_ShowMessageDiv(" + tdContainer.ClientID + ",'数据保存成功')"); string RowGuid = Request["RowGuid"]; string DWGuid = Request["DWGuid"]; string strSql = "SELECT top(1) EnterpriseName FROM RG_OUInfo WHERE dwGuid='" + DWGuid + "' order by row_ID desc"; string EnterpriseName = Epoint.MisBizLogic2.DB.ExecuteToString(strSql); //先获取投资经理 strSql = "SELECT s_xiangmujl_guid,s_xiangmujl FROM VIEW_CurrentVersion WHERE dwGuid='" + DWGuid + "'"; DataView dvUser = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql); if (dvUser.Count == 0) { WriteAjaxMessage("该企业没有对应的项目,请联系系统管理员。"); return; } //判断是不是已经有了 strSql = string.Format("select count(*) from RG_OtherInfo where DWGuid='{0}'", Request["DWGuid"]); if (Epoint.MisBizLogic2.DB.ExecuteToString(strSql) == "1")//说明没有 { //提交时直接提交,不用保存版本 Year_2021.Text = ddlYear.SelectedValue; Month_2021.Text = ddlMonth.SelectedValue; YearMonth_2021.Text = ddlYear.SelectedValue + "-" + ddlMonth.SelectedValue + "-01 00:00:00"; UpdateUserName_2021.Text = this.DisplayName; UpdateUserGuid_2021.Text = this.UserGuid; UpdateTime_2021.Text = DateTime.Now.ToString(); Status_2021.Text = EpointRegisterUser_Bizlogic.OUStatus.待审核; IsHistory_2021.Text = "0"; oEditPage.SaveTableValues(RowGuid, tdContainer); } else { //先将原来的设置为历史记录 Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, Request["RowGuid"]); oRow["IsHistory"] = "1"; //oRow["UpdateUserName"] = this.DisplayName; //oRow["UpdateUserGuid"] = this.UserGuid; //oRow["UpdateTime"] = DateTime.Now; oRow.Update(); //然后再将本版本进行提交审核 Year_2021.Text = ddlYear.SelectedValue; Month_2021.Text = ddlMonth.SelectedValue; YearMonth_2021.Text = ddlYear.SelectedValue + "-" + ddlMonth.SelectedValue + "-01 00:00:00"; UpdateUserName_2021.Text = this.DisplayName; UpdateUserGuid_2021.Text = this.UserGuid; UpdateTime_2021.Text = DateTime.Now.ToString(); Status_2021.Text = EpointRegisterUser_Bizlogic.OUStatus.待审核; IsHistory_2021.Text = "0"; RowGuid = Guid.NewGuid().ToString(); oAddPage.SaveTableValues(RowGuid, tdContainer, Request.QueryString["ParentRowGuid"]); } #region 保存附件 CL_CWBB.MisRowGuid = DWGuid; CL_CWBB.MisTableID = TableID; CL_CWBB.ProjectGuid = ""; CL_CWBB.Comment = DWGuid; CL_CWBB.d_TiJiaoSJ = DateTime.Now.ToString(); CL_CWBB.Save(); CL_NDSJBG.MisRowGuid = DWGuid; CL_NDSJBG.MisTableID = TableID; CL_NDSJBG.ProjectGuid = ""; CL_NDSJBG.Comment = DWGuid; CL_NDSJBG.d_TiJiaoSJ = DateTime.Now.ToString(); CL_NDSJBG.Save(); #endregion #region 通知投资经理 for (int m = 0; m < dvUser.Count; m++) { msg.WaitHandle_Insert( Guid.NewGuid().ToString(), "【审核】" + EnterpriseName + "其他重要财务数据", "", dvUser[m]["s_xiangmujl_guid"].ToString(), dvUser[m]["s_xiangmujl"].ToString(), Session["UserGuid"].ToString(), Session["DisplayName"].ToString(), "", "EpointRegisterUser/Pages_RG/RG_Other/RG_OtherInfo_DetailForCheck.aspx?RowGuid=" + RowGuid + "&DWGuid=" + DWGuid, "", "", 1, "", "", "" ); } #endregion //this.WriteAjaxMessage("refreshParent();"); //this.WriteAjaxMessage("EP_ShowMessageDiv(" + tdContainer.ClientID + ",'数据保存成功')"); this.WriteAjaxMessage("alert('提交成功');"); RefreshGrid(); btnEdit.Visible = false; }
protected void btnPass_Click(object sender, System.EventArgs e) { //这个地方要注意,如果是江阴、宜兴的项目,要先到江阴、宜兴审核,然后再到市总办审核 //特别注意:2013-09-24新增变更,如果是省外的、年度备案的企业,如果在区县的,只要区县建设局审核即可 DataView dv = new DataView(); //DBF.GetUserByRoleName("备案信息审核"); Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oDetailPage.TableDetail.SQL_TableName, Request["RowGuid"]); bool IsND = false;//如果是省外、年度备案企业,则更改为true; #region 对企业进行判断 string strSql = "SELECT IsNDBA,RegistAddress,* FROM RG_OUInfo WHERE ROWGUID='" + DWGuid_2021.Text + "'"; string qyzcd = ""; DataView dvQY = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql); if (dvQY.Count > 0) { qyzcd = dvQY[0]["RegistAddressCode"].ToString().Substring(0, 2); if (dvQY[0]["IsNDBA"].ToString() == "1") { IsND = true; } else if (qyzcd == "32") { IsND = true; } } #endregion string srStatus = oRow["Status"].ToString(); if (oRow["XMAdd"].ToString() == "320282")//宜兴 { #region 宜兴建设局 if (srStatus == "69")//区县初审,要转到区县审批 { oRow["Status"] = "68"; oRow["QXTG_Date"] = DateTime.Now.ToString(); oRow.Update(); dv = DBF.GetUserByRoleName("宜兴备案信息审批"); SaveOpinion("宜兴建设局", false); SendMessage(dv, "备案审核"); } else if (srStatus == "68") //区县审批 { if (IsND) // 先区县初审,在区县审批,然后结束 { oRow["Status"] = "90"; oRow["QXTG_Date"] = DateTime.Now.ToString(); if (oRow["XMBH"].ToString() == "") { oRow["XMBH"] = RG_DW.CreateXMBH(Request["RowGuid"], DWGuid_2021.Text, oRow["XMAdd"], oRow["XMLB"], qyzcd); } oRow["TGDate"] = DateTime.Now.ToString(); oRow.Update(); SaveOpinion("宜兴建设局", true); } else// 先区县初审,在区县审批,然后转市里 { oRow["Status"] = "70"; oRow["QXTG_Date"] = DateTime.Now.ToString(); oRow.Update(); dv = DBF.GetUserByRoleName("备案信息初审");//备案信息初审 SaveOpinion("宜兴建设局", false); SendMessage(dv, "备案初审"); } } else if (srStatus == "70")//处于初审中,则下一步就是审核中 { dv = DBF.GetUserByRoleName("备案信息审核"); oRow["Status"] = "86"; oRow["XMBH"] = ""; //RG_DW.CreateXMBH(Request["RowGuid"], DWGuid_2021.Text, oRow["XMAdd"], oRow["XMLB"], qyzcd); oRow["TGDate"] = DateTime.Now.ToString(); oRow.Update(); SaveOpinion("无锡建设局", true); SendMessage(dv, "备案审核"); } else if (srStatus == "86")//处于审核中,则下一步就是审批中 { dv = DBF.GetUserByRoleName("备案信息审批"); oRow["Status"] = "87"; oRow["XMBH"] = "";// RG_DW.CreateXMBH(Request["RowGuid"], DWGuid_2021.Text, oRow["XMAdd"], oRow["XMLB"], qyzcd); oRow["TGDate"] = DateTime.Now.ToString(); oRow.Update(); SaveOpinion("无锡建设局", true); SendMessage(dv, "备案审批"); } else { oRow["Status"] = "90"; if (oRow["XMBH"].ToString() == "") { oRow["XMBH"] = RG_DW.CreateXMBH(Request["RowGuid"], DWGuid_2021.Text, oRow["XMAdd"], oRow["XMLB"], qyzcd); } oRow["TGDate"] = DateTime.Now.ToString(); oRow.Update(); SaveOpinion("无锡建设局", true); } #endregion } else if (oRow["XMAdd"].ToString() == "320281")//江阴 { #region 江阴 if (srStatus == "69")//区县初审,要转到区县审批 { oRow["Status"] = "68"; oRow["QXTG_Date"] = DateTime.Now.ToString(); oRow.Update(); dv = DBF.GetUserByRoleName("江阴备案信息审批"); SaveOpinion("江阴建设局", false); SendMessage(dv, "备案审核"); } else if (srStatus == "68") //区县审批 { if (IsND) // 先区县初审,在区县审批,然后结束 { oRow["Status"] = "90"; oRow["QXTG_Date"] = DateTime.Now.ToString(); if (oRow["XMBH"].ToString() == "") { oRow["XMBH"] = RG_DW.CreateXMBH(Request["RowGuid"], DWGuid_2021.Text, oRow["XMAdd"], oRow["XMLB"], qyzcd); } oRow["TGDate"] = DateTime.Now.ToString(); oRow.Update(); SaveOpinion("江阴建设局", true); } else// 先区县初审,在区县审批,然后转市里 { oRow["Status"] = "70"; oRow["QXTG_Date"] = DateTime.Now.ToString(); oRow.Update(); dv = DBF.GetUserByRoleName("备案信息初审"); SaveOpinion("江阴建设局", false); SendMessage(dv, "备案初审"); } } else if (srStatus == "70")//处于初审中,则下一步就是审核中 { dv = DBF.GetUserByRoleName("备案信息审核"); oRow["Status"] = "86"; oRow["XMBH"] = ""; //RG_DW.CreateXMBH(Request["RowGuid"], DWGuid_2021.Text, oRow["XMAdd"], oRow["XMLB"], qyzcd); oRow["TGDate"] = DateTime.Now.ToString(); oRow.Update(); SaveOpinion("无锡建设局", true); SendMessage(dv, "备案审核"); } else if (srStatus == "86")//处于审核中,则下一步就是审批中 { dv = DBF.GetUserByRoleName("备案信息审批"); oRow["Status"] = "87"; oRow["XMBH"] = "";// RG_DW.CreateXMBH(Request["RowGuid"], DWGuid_2021.Text, oRow["XMAdd"], oRow["XMLB"], qyzcd); oRow["TGDate"] = DateTime.Now.ToString(); oRow.Update(); SaveOpinion("无锡建设局", true); SendMessage(dv, "备案审批"); } else { oRow["Status"] = "90"; if (oRow["XMBH"].ToString() == "") { oRow["XMBH"] = RG_DW.CreateXMBH(Request["RowGuid"], DWGuid_2021.Text, oRow["XMAdd"], oRow["XMLB"], qyzcd); } oRow["TGDate"] = DateTime.Now.ToString(); oRow.Update(); SaveOpinion("无锡建设局", true); } #endregion } else { #region 其他 if (srStatus == "70")//处于初审中,则下一步就是审核中 { dv = DBF.GetUserByRoleName("备案信息审核"); oRow["Status"] = "86"; oRow["XMBH"] = ""; //RG_DW.CreateXMBH(Request["RowGuid"], DWGuid_2021.Text, oRow["XMAdd"], oRow["XMLB"], qyzcd); oRow["TGDate"] = DateTime.Now.ToString(); oRow.Update(); SaveOpinion("无锡建设局", true); SendMessage(dv, "备案初审"); } else if (srStatus == "86")//处于审核中,则下一步就是审批中 { dv = DBF.GetUserByRoleName("备案信息审批"); oRow["Status"] = "87"; oRow["XMBH"] = "";// RG_DW.CreateXMBH(Request["RowGuid"], DWGuid_2021.Text, oRow["XMAdd"], oRow["XMLB"], qyzcd); oRow["TGDate"] = DateTime.Now.ToString(); oRow.Update(); SaveOpinion("无锡建设局", true); SendMessage(dv, "备案审批"); } else { oRow["Status"] = "90"; if (oRow["XMBH"].ToString() == "") { oRow["XMBH"] = RG_DW.CreateXMBH(Request["RowGuid"], DWGuid_2021.Text, oRow["XMAdd"], oRow["XMLB"], qyzcd); } oRow["TGDate"] = DateTime.Now.ToString(); oRow.Update(); SaveOpinion("无锡建设局", true); } #endregion } this.WriteAjaxMessage("refreshParent();"); this.WriteAjaxMessage("window.close();"); }
protected void UpdateStatus(string CID,string CGuid) { Epoint.MisBizLogic2.Data.MisGuidRow oRow ;// = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, Request["RowGuid"]); string TableName = ""; string lb = CID.Substring(0, 2); if (lb == "QY") { TableName = "RG_OUInfo"; } else if (lb == "RY") { TableName = "RG_QYUser"; } else if (lb == "ZZ") { TableName = "RG_QiYeZiZhi"; } else if (lb == "XM") { TableName = "RG_XMBeiAn"; } else { TableName = "RG_OUInfo"; } oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(TableName, CGuid.Replace(CID, "")); if (oRow["Status"].ToString() == "90")//����Ѿ�ͨ�����������仯�ǣ���ɱ���� { oRow["Status"] = "85"; oRow.Update(); } }
protected void btSubmit_Click(object sender, System.EventArgs e) { //先将原来的删除,防止重复 DB_MC.DeleteWH("审核企业", Request["RowGuid"]); RegistAddress_2017.Text = RegionTreeView.Text; RegistAddressCode_2017.Text = RegionTreeView.Value; TJRGuid_2017.Text = this.UserGuid; //Status_2017.Text = "70"; oEditPage.SaveTableValues(Request["RowGuid"], tdContainer); Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, Request["RowGuid"]); oRow["Status"] = "70"; oRow["UpdateUserName"] = this.DisplayName; oRow["UpdateUserGuid"] = this.UserGuid; oRow["UpdateTime"] = DateTime.Now.ToString(); oRow.Update(); //将人员、资质中处于编辑状态和审核退回状态的,都修改为待审核状态 string strSql = ""; //资质 strSql = "SELECT * FROM RG_QiYeZiZhi WHERE Status IN ('60','80','85') AND DWGuid='" + Request["RowGuid"] + "'"; DataView dv = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql); for (int m = 0; m < dv.Count; m++) { strSql = "UPDATE RG_QiYeZiZhi SET Status='70' WHERE ROWGUID='" + dv[m]["RowGuid"] + "' "; Epoint.MisBizLogic2.DB.ExecuteNonQuery(strSql); //将该单位其他资质的审核待办删除 DB_MC.DeleteWH("审核企业资质", dv[m]["RowGuid"].ToString()); } //人员 strSql = "SELECT * FROM RG_QYUser WHERE Status IN ('60','80','85') AND DWGuid='" + Request["RowGuid"] + "'"; dv = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql); for (int m = 0; m < dv.Count; m++) { strSql = "UPDATE RG_QYUser SET Status='70' WHERE ROWGUID='" + dv[m]["RowGuid"] + "' "; Epoint.MisBizLogic2.DB.ExecuteNonQuery(strSql); //将该单位其他资质的审核待办删除 DB_MC.DeleteWH("人员信息审核", dv[m]["RowGuid"].ToString()); } //strSql = "UPDATE RG_QYUser SET Status='70' WHERE Status IN ('60','80','85') AND DWGuid='" + Request["RowGuid"] + "'"; //Epoint.MisBizLogic2.DB.ExecuteNonQuery(strSql); //发送待审核事宜,根据角色来 dv = DBF.GetUserByRoleName("企业信息审核"); for (int m = 0; m < dv.Count; m++) { string messageGuid = Guid.NewGuid().ToString(); new HTProject_Bizlogic.DB_Messages_Center().WaitHandle_Insert(messageGuid, EnterpriseName_2017.Text + "信息审核", "", dv[m]["UserGuid"].ToString(), dv[m]["DisplayName"].ToString(), "", "", "", @"HTProject/Pages/RG_OU/RG_OU_All_Detail.aspx?type=shenhe&RowGuid=" + Request["RowGuid"], "", "", 1, "", "", "" ); //更新标志位 strSql = "update messages_center set PType='审核企业',PGuid='" + Request["RowGuid"] + "' where MessageItemGuid='" + messageGuid + "'"; Epoint.MisBizLogic2.DB.ExecuteNonQuery(strSql); //添加短信 string IsSendADSMS = ApplicationOperate.GetConfigValueByName("IsSendADSMS"); if (IsSendADSMS == "1") { if (dv[m]["Mobile"].ToString() != "") { HTSMS.SendSMS(this.DisplayName, dv[m]["DisplayName"], EnterpriseName_2017.Text + "提交企业信息审核", dv[m]["Mobile"]); } } } AlertAjaxMessage("提交成功"); this.WriteAjaxMessage("refreshParent();window.close();"); }
protected void btnEdit_Click(object sender, System.EventArgs e) { string RowGuid = Request["RowGuid"]; string DWGuid = Request["DWGuid"]; string strSql = "SELECT distinct s_xiangmujl_guid,s_xiangmujl FROM VIEW_CurrentVersion WHERE dwGuid='" + DWGuid + "'"; DataView dvUser = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql); if (dvUser.Count == 0) { WriteAjaxMessage("����ҵû�ж�Ӧ����Ŀ������ϵϵͳ����Ա��"); return; } //�Ƚ�ԭ��������Ϊ��ʷ��¼ Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, Request["RowGuid"]); oRow["IsHistory"] = "1"; //oRow["UpdateUserName"] = this.DisplayName; //oRow["UpdateUserGuid"] = this.UserGuid; //oRow["UpdateTime"] = DateTime.Now; oRow.Update(); //������һ������ UpdateUserName_2017.Text = this.DisplayName; UpdateUserGuid_2017.Text = this.UserGuid; IsHistory_2017.Text = "0"; UpdateTime_2017.Text = DateTime.Now.ToString(); Status_2017.Text = EpointRegisterUser_Bizlogic.OUStatus.�����;// "1";//0:�༭ 1������� 2��ͨ�� DelFlag_2017.Text = "0"; //DWGuid_2017.Text = DWGuid; #region �����ı��� ZhuCeDi_2017.Text = tvZCD.Text; ZhuCeDiCode_2017.Text = tvZCD.Value; YunYingDi1_2017.Text = tvYYD1.Text; YunYingDi1Code_2017.Text = tvYYD1.Value; YunYingDi2_2017.Text = tvYYD2.Text; YunYingDi2Code_2017.Text = tvYYD2.Value; YunYingDi3_2017.Text = tvYYD3.Text; YunYingDi3Code_2017.Text = tvYYD3.Value; #endregion //oEditPage.SaveTableValues(RowGuid, tdContainer); string newGuid = Guid.NewGuid().ToString(); oAddPage.SaveTableValues(newGuid, tdContainer, Request.QueryString["ParentRowGuid"]); #region ���渽�� CL_SB.MisRowGuid = DWGuid; CL_SB.MisTableID = TableID; CL_SB.ProjectGuid = ""; CL_SB.Comment = DWGuid; CL_SB.d_TiJiaoSJ = DateTime.Now.ToString(); CL_SB.Save(); CL_Logo.MisRowGuid = DWGuid; CL_Logo.MisTableID = TableID; CL_Logo.ProjectGuid = ""; CL_Logo.Comment = DWGuid; CL_Logo.d_TiJiaoSJ = DateTime.Now.ToString(); CL_Logo.Save(); CL_GSJS.MisRowGuid = DWGuid; CL_GSJS.MisTableID = TableID; CL_GSJS.ProjectGuid = ""; CL_GSJS.Comment = DWGuid; CL_GSJS.d_TiJiaoSJ = DateTime.Now.ToString(); CL_GSJS.Save(); CL_ZS.MisRowGuid = DWGuid; CL_ZS.MisTableID = TableID; CL_ZS.ProjectGuid = ""; CL_ZS.Comment = DWGuid; CL_ZS.d_TiJiaoSJ = DateTime.Now.ToString(); CL_ZS.Save(); #endregion #region ֪ͨͶ�ʾ��� //�Ȼ�ȡͶ�ʾ��� for (int m = 0; m < dvUser.Count; m++) { msg.WaitHandle_Insert( Guid.NewGuid().ToString(), "����ˡ�" + EnterpriseName_2017.Text +"��ҵ��Ϣ", "", dvUser[m]["s_xiangmujl_guid"].ToString(), dvUser[m]["s_xiangmujl"].ToString(), Session["UserGuid"].ToString(), Session["DisplayName"].ToString(), "", "EpointRegisterUser/Pages_RG/RG_OU/RG_OU_DetailForCheck.aspx?RowGuid=" + newGuid + "&DWGuid=" + DWGuid, "", "", 1, "", "", "" ); } #endregion this.WriteAjaxMessage("refreshParent();alert('�ύ�ɹ�');window.close();"); }
protected void btSubmit_Click(object sender, System.EventArgs e) { //�Ƚ�ԭ����ɾ������ֹ�ظ� DB_MC.DeleteWH("�����ҵ", Request["RowGuid"]); RegistAddress_2017.Text = RegionTreeView.Text; RegistAddressCode_2017.Text = RegionTreeView.Value; TJRGuid_2017.Text = this.UserGuid; //Status_2017.Text = "70"; oEditPage.SaveTableValues(Request["RowGuid"], tdContainer); Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, Request["RowGuid"]); oRow["Status"] = "70"; oRow["UpdateUserName"] = this.DisplayName; oRow["UpdateUserGuid"] = this.UserGuid; oRow["UpdateTime"] = DateTime.Now.ToString(); oRow.Update(); //����Ա�������д��ڱ༭״̬������˻�״̬�ģ�����Ϊ�����״̬ string strSql = ""; //���� strSql = "SELECT * FROM RG_QiYeZiZhi WHERE Status IN ('60','80','85') AND DWGuid='" + Request["RowGuid"] + "'"; DataView dv = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql); for (int m = 0; m < dv.Count; m++) { strSql = "UPDATE RG_QiYeZiZhi SET Status='70' WHERE ROWGUID='" + dv[m]["RowGuid"] + "' "; Epoint.MisBizLogic2.DB.ExecuteNonQuery(strSql); //���õ�λ�������ʵ���˴���ɾ�� DB_MC.DeleteWH("�����ҵ����", dv[m]["RowGuid"].ToString()); } //��Ա strSql = "SELECT * FROM RG_QYUser WHERE Status IN ('60','80','85') AND DWGuid='" + Request["RowGuid"] + "'"; dv = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql); for (int m = 0; m < dv.Count; m++) { strSql = "UPDATE RG_QYUser SET Status='70' WHERE ROWGUID='" + dv[m]["RowGuid"] + "' "; Epoint.MisBizLogic2.DB.ExecuteNonQuery(strSql); //���õ�λ�������ʵ���˴���ɾ�� DB_MC.DeleteWH("��Ա��Ϣ���", dv[m]["RowGuid"].ToString()); } //strSql = "UPDATE RG_QYUser SET Status='70' WHERE Status IN ('60','80','85') AND DWGuid='" + Request["RowGuid"] + "'"; //Epoint.MisBizLogic2.DB.ExecuteNonQuery(strSql); //���ʹ�������ˣ����ݽ�ɫ�� dv = DBF.GetUserByRoleName("��ҵ��Ϣ���"); for (int m = 0; m < dv.Count; m++) { string messageGuid = Guid.NewGuid().ToString(); new HTProject_Bizlogic.DB_Messages_Center().WaitHandle_Insert(messageGuid, EnterpriseName_2017.Text + "��Ϣ���", "", dv[m]["UserGuid"].ToString(), dv[m]["DisplayName"].ToString(), "", "", "", @"HTProject/Pages/RG_OU/RG_OU_All_Detail.aspx?type=shenhe&RowGuid=" + Request["RowGuid"], "", "", 1, "", "", "" ); //���±�־λ strSql = "update messages_center set PType='�����ҵ',PGuid='"+ Request["RowGuid"] +"' where MessageItemGuid='" + messageGuid + "'"; Epoint.MisBizLogic2.DB.ExecuteNonQuery(strSql); //��Ӷ��� string IsSendADSMS = ApplicationOperate.GetConfigValueByName("IsSendADSMS"); if (IsSendADSMS == "1") { if (dv[m]["Mobile"].ToString() != "") { HTSMS.SendSMS(this.DisplayName, dv[m]["DisplayName"], EnterpriseName_2017.Text + "�ύ��ҵ��Ϣ���", dv[m]["Mobile"]); } } } AlertAjaxMessage("�ύ�ɹ�"); this.WriteAjaxMessage("refreshParent();window.close();"); }
protected void btnAdd_Click(object sender, System.EventArgs e) { //string ServerIP = System.Configuration.ConfigurationManager.AppSettings["ServerIP"].ToString(); //string SmtpServer = System.Configuration.ConfigurationManager.AppSettings["SmtpServer"].ToString(); //string EmailFrom = System.Configuration.ConfigurationManager.AppSettings["EmailFrom"].ToString(); //string EmailAccount = System.Configuration.ConfigurationManager.AppSettings["EmailAccount"].ToString(); //string EmailPassword = System.Configuration.ConfigurationManager.AppSettings["EmailPassword"].ToString(); //Boolean IsSendSuccess = usermail.sendMail(SmtpServer, EmailAccount, EmailPassword, EmailFrom, EMail_2010.Text, "�����ʼ���ַ�Ƿ���Ч��", "Test����"); //if (!IsSendSuccess) //{ // AlertAjaxMessage("����д���ʼ���ַ��Ч����ȷ�ϣ�"); // return; //} UserIdendity_2010.Text = UserIdendity.Text; if (!string.IsNullOrEmpty(PIN_2010.Value)) { if (Epoint.MisBizLogic2.DB.Check_Item_Exist("RG_User", "UserKey='" + common.authPassword(PIN_2010.Value) + "'")) { AlertAjaxMessage("��֤���ڱ�ϵͳ���Ѿ����ù�"); return; } else { UserKey_2010.Text = common.authPassword(PIN_2010.Value); } } if (string.IsNullOrEmpty(UserKey_2010.Text)) { // ��ʼ������ Password_2010.Text = common.authPassword(LoginID_2010.Text.Trim()); } Boolean UserExisted = Epoint.MisBizLogic2.DB.ExecuteToInt("select count(RowGuid) from RG_User where LoginID='" + LoginID_2010.Text + "' and DelFlag=0") > 0; if (UserExisted) { AlertAjaxMessage("�õ�¼���ѱ�ʹ��,�������¼����"); return; } string RowGuid = Guid.NewGuid().ToString(); //if (!string.IsNullOrEmpty(ApplyDanWeiGuid)) //{ // DanWeiGuid_2010.Text = ApplyDanWeiGuid; //} //else // if (UserType_2010.SelectedItem.Value == "002") // { // Epoint.MisBizLogic2.Data.MisGuidRow arow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_OUInfo"); // arow["RowGuid"] = Guid.NewGuid().ToString(); // arow["EnterpriseName"] = EnterpriseName.Text.Trim(); // arow["CodeCertificate"] = CodeCertificate.Text.Trim(); // arow["LegalPerson"] = LegalPerson.Text.Trim(); // arow["RegionCharacter"] = RegionCharacter.Text.Trim(); // arow["BusinessLicenseNO"] = BusinessLicenseNO.Text.Trim(); // arow["Contacter"] = Contacter.Text.Trim(); // arow["Tel"] = Tel.Text.Trim(); // arow["ContacterID"] = ContacterID.Text.Trim(); // arow["Email"] = Email.Text.Trim(); // arow["Address"] = Address.Text.Trim(); // arow["RegistAddress"] = RegistAddress.Text.Trim(); // //EpointNetoffice7.Ascx.CtlAttachments Att = new EpointNetoffice7.Ascx.CtlAttachments(); // //arow["AttachGuid"] = ((EpointNetoffice7.Ascx.CtlMisAttachments)AttachGuid).AttachGroupGuid; // arow["BeiZhu"] = BeiZhu.Text.Trim(); // arow["DelFlag"] = "0"; // arow.Insert(); // new ComDataSyn().InsertWithKeyValue(DataSynTarget.BackEndToFront, "RG_OUInfo", "RowGuid", arow["RowGuid"].ToString()); // DanWeiGuid_2010.Text = arow["RowGuid"].ToString(); // SaveOuType(arow["RowGuid"].ToString()); // } //else //{ // DanWeiGuid_2010.Text = dpDanWeiGuid.SelectedValue; //} //if (UserType_2010.SelectedValue != "001") // SaveOuTypeForUser(RowGuid); DelFlag_2010.Text = "0"; oAddPage.SaveTableValues(RowGuid, tdContainer, Request.QueryString["ParentRowGuid"]); //new ComDataSyn().InsertWithKeyValue(DataSynTarget.BackEndToFront, "RG_User", "RowGuid", RowGuid); //if (!string.IsNullOrEmpty(DanWeiGuid_2010.Text)) //{ // DataView dvApp = rgModule.GetAppForSyn(DanWeiGuid_2010.Text); // if (dvApp.Count > 0) // { // foreach (DataRowView row in dvApp) // { // new ComDataSyn().InsertWithKeyValue(row["SynTargetAddr"].ToString(), "RG_User", "RowGuid", RowGuid); // } // } //} //SaveUserRole(RowGuid); //����Ǹ����Ҫת����༭ҳ�� if (oAddPage.TableDetail.TableType == 1) { Response.Redirect("MultiPageTab.aspx?mode=Mode&TableID=��" + oAddPage.TableDetail.TableID + "&RowGuid=" + RowGuid); } Epoint.MisBizLogic2.Web.CodeGenerator.InitiateControl_AddPage(oAddPage, tdContainer); Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oAddPage.TableDetail.SQL_TableName, RowGuid); oRow["UserStatus"] = "002"; //oRow["DanWeiGuid"] = DanWeiGuid_2010.Text; oRow.Update(); string url = "Record_Edit.aspx?RowGuid=" + RowGuid ; this.WriteAjaxMessage("refreshParent();alert('��ӳɹ�������Ϊ���ĵ�¼��');window.location.href='" + url + "';"); }
/// <summary> /// ���浥λ��� /// </summary> /// <summary> /// ��ʼ����Ϣ /// </summary> //protected void InitUser() //{ // Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, Request["RowGuid"]); // if (UserType_2010.SelectedItem.Value == "001") // { // // ���RG_��Ա����Ǹ��˻�Ա������Ҫ��ʾ�����λ�͵�λ��Ϣ // trOUInfo.Visible = false; // trDanwei.Style["display"] = "none"; // } // else if (UserType_2010.SelectedItem.Value == "002") // { // // ���RG_��Ա����ǵ�λ����Ա������Ҫ��ʾ�����λ // trDanwei.Style["display"] = "none"; // Epoint.MisBizLogic2.Data.MisGuidRow arow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_OUInfo", oRow["DanWeiGuid"].ToString()); // EnterpriseName.Text = arow["EnterpriseName"].ToString(); // CodeCertificate.Text = arow["CodeCertificate"].ToString(); // LegalPerson.Text = arow["LegalPerson"].ToString(); // RegionCharacter.Text = arow["RegionCharacter"].ToString(); // BusinessLicenseNO.Text = arow["BusinessLicenseNO"].ToString(); // Contacter.Text = arow["Contacter"].ToString(); // Tel.Text = arow["Tel"].ToString(); // ContacterID.Text = arow["ContacterID"].ToString(); // Email.Text = arow["Email"].ToString(); // Address.Text = arow["Address"].ToString(); // RegistAddress.Text = arow["RegistAddress"].ToString(); // ((EpointNetoffice7.Ascx.CtlMisAttachments)AttachGuid).AttachGroupGuid = arow["AttachGuid"].ToString(); // BeiZhu.Text = arow["BeiZhu"].ToString(); // if (!string.IsNullOrEmpty(oRow["DanWeiGuid"].ToString())) // BindOuType(oRow["DanWeiGuid"].ToString()); // } // else if (UserType_2010.SelectedItem.Value == "003") // { // // ���RG_��Ա����ǵ�λ���˺ţ�����Ҫ��ʾ��λ��Ϣ��������Ҫ��ʾ�����λ // trOUInfo.Visible = false; // // �������λ // if (string.IsNullOrEmpty(ApplyDanWeiGuid)) // { // // �������λ // DataView dv = Epoint.MisBizLogic2.DB.ExecuteDataView("select EnterpriseName, RowGuid from RG_OUInfo WHERE DelFlag=0"); // dpDanWeiGuid.DataSource = dv; // dpDanWeiGuid.DataTextField = "EnterpriseName"; // dpDanWeiGuid.DataValueField = "RowGuid"; // dpDanWeiGuid.DataBind(); // dpDanWeiGuid.Items.Insert(0, new ListItem("", "")); // dpDanWeiGuid.SelectedValue = DanWeiGuid_2010.Text; // } // else // { // DanWeiGuid_2010.Text = ApplyDanWeiGuid; // trDanwei.Style["display"] = "none"; // } // } //} ///// <summary> ///// ��ɫ ///// </summary> //protected void BindRoleName() //{ // DataView dv = Epoint.MisBizLogic2.DB.ExecuteDataView("select RoleName,RowGuid from RG_Role where UserType='" + UserType_2010.SelectedItem.Value + "'"); // if (dv.Count > 0) // { // jpdRoleName.DataSource = dv; // jpdRoleName.DataTextField = "RoleName"; // jpdRoleName.DataValueField = "RowGuid"; // jpdRoleName.DataBind(); // string RowGuid = Request["RowGuid"]; // DataView dv2 = Epoint.MisBizLogic2.DB.ExecuteDataView("select RoleGuid from RG_User_Role where RGUserGUID='" + RowGuid + "'"); // foreach (DataRowView row in dv2) // { // foreach (ListItem item in jpdRoleName.Items) // { // if (Convert.ToString(row[0]) == item.Value) // item.Selected = true; // } // } // } // else // { // trRoleList.Style["display"] = "none"; // } //} //protected void UserType_2010_SelectedIndexChanged(object sender, EventArgs e) //{ // BindRoleName(); // InitUser(); //} //protected void dpDanWeiGuid_SelectedIndexChanged(object sender, EventArgs e) //{ // BindOuType(); //} /// <summary> /// ��ʼ������ /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnInitPwd_Click(object sender, EventArgs e) { Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_User", Request["RowGuid"]); if (oRow.R_HasFilled) { string pwd = LoginID_2010.Text; oRow["Password"] = common.authPassword(pwd); oRow.Update(); AlertAjaxMessage("��ʼ������ɹ����ѳ�ʼ��Ϊ���ĵ�¼�ʺš�"); new ComDataSyn().UpdateWithKeyValue(DataSynTarget.BackEndToFront, "RG_User", "RowGuid", Request["RowGuid"]); } }
protected void btnEdit_Click(object sender, System.EventArgs e) { string RowGuid = Request["RowGuid"]; string DWGuid = Request["DWGuid"]; string strSql = "SELECT top(1) EnterpriseName FROM RG_OUInfo WHERE dwGuid='" + DWGuid + "' order by row_ID desc"; string EnterpriseName = Epoint.MisBizLogic2.DB.ExecuteToString(strSql); //�Ȼ�ȡͶ�ʾ��� strSql = "SELECT s_xiangmujl_guid,s_xiangmujl FROM VIEW_CurrentVersion WHERE dwGuid='" + DWGuid + "'"; DataView dvUser = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql); if (dvUser.Count == 0) { WriteAjaxMessage("����ҵû�ж�Ӧ����Ŀ������ϵϵͳ����Ա��"); return; } //�ж��Dz����Ѿ����� this.s_qiJian_2022.Text = this.jpdYear.SelectedValue + "-" + this.jpdMonth.SelectedValue + "-" + "1"; HaiGuiInfo_2022.Text = HaiGuiInfo.Text; if (HaiGuiInfo_2022.Text.Trim() == "��������ҵԺУ����Ҫ��������������˾����ְ���") { HaiGuiInfo_2022.Text = ""; } strSql = string.Format("select count(*) from RG_RenShiInfo where DWGuid='{0}'", Request["DWGuid"]); if (Epoint.MisBizLogic2.DB.ExecuteToString(strSql) == "1")//˵��û�� { //�ύʱֱ���ύ�����ñ���汾 UpdateUserName_2022.Text = this.DisplayName; UpdateUserGuid_2022.Text = this.UserGuid; UpdateTime_2022.Text = DateTime.Now.ToString(); Status_2022.Text = EpointRegisterUser_Bizlogic.OUStatus.�����; IsHistory_2022.Text = "0"; oEditPage.SaveTableValues(RowGuid, tdContainer); } else { //�Ƚ�ԭ��������Ϊ��ʷ��¼ Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, Request["RowGuid"]); oRow["IsHistory"] = "1"; //oRow["UpdateUserName"] = this.DisplayName; //oRow["UpdateUserGuid"] = this.UserGuid; //oRow["UpdateTime"] = DateTime.Now; oRow.Update(); //Ȼ���ٽ����汾�����ύ��� UpdateUserName_2022.Text = this.DisplayName; UpdateUserGuid_2022.Text = this.UserGuid; UpdateTime_2022.Text = DateTime.Now.ToString(); Status_2022.Text = EpointRegisterUser_Bizlogic.OUStatus.�����; IsHistory_2022.Text = "0"; RowGuid = Guid.NewGuid().ToString(); oAddPage.SaveTableValues(RowGuid, tdContainer, Request.QueryString["ParentRowGuid"]); } #region ֪ͨͶ�ʾ��� for (int m = 0; m < dvUser.Count; m++) { msg.WaitHandle_Insert( Guid.NewGuid().ToString(), "����ˡ�" + EnterpriseName + "������Ϣ", "", dvUser[m]["s_xiangmujl_guid"].ToString(), dvUser[m]["s_xiangmujl"].ToString(), Session["UserGuid"].ToString(), Session["DisplayName"].ToString(), "", "EpointRegisterUser/Pages_RG/RG_RenShi/RG_RenShiInfo_DetailForCheck.aspx?RowGuid=" + RowGuid + "&DWGuid=" + DWGuid, "", "", 1, "", "", "" ); } #endregion this.WriteAjaxMessage("alert('�ύ�ɹ�');"); RefreshGrid(); btnEdit.Visible = false; }
protected void btnPass_Click(object sender, System.EventArgs e) { //����ط�Ҫע�⣬����ǽ��������˵���Ŀ��Ҫ�ȵ�������������ˣ�Ȼ���ٵ����ܰ���� //�ر�ע�⣺2013-09-24��������������ʡ��ġ���ȱ�������ҵ����������صģ�ֻҪ���ؽ������˼��� DataView dv = new DataView(); //DBF.GetUserByRoleName("������Ϣ���"); Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oDetailPage.TableDetail.SQL_TableName, Request["RowGuid"]); bool IsND = false;//�����ʡ�⡢��ȱ�����ҵ�������Ϊtrue�� #region ����ҵ�����ж� string strSql = "SELECT IsNDBA,RegistAddress,* FROM RG_OUInfo WHERE ROWGUID='"+ DWGuid_2021.Text +"'"; string qyzcd = ""; DataView dvQY = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql); if (dvQY.Count > 0) { qyzcd = dvQY[0]["RegistAddressCode"].ToString().Substring(0, 2); if (dvQY[0]["IsNDBA"].ToString() == "1") { IsND = true; } else if (qyzcd == "32") { IsND = true; } } #endregion string srStatus = oRow["Status"].ToString(); if (oRow["XMAdd"].ToString() == "320282")//���� { #region ���˽���� if (srStatus == "69")//���س���Ҫת���������� { oRow["Status"] = "68"; oRow["QXTG_Date"] = DateTime.Now.ToString(); oRow.Update(); dv = DBF.GetUserByRoleName("���˱�����Ϣ����"); SaveOpinion("���˽����", false); SendMessage(dv, "�������"); } else if (srStatus == "68")//�������� { if (IsND)// �����س���������������Ȼ����� { oRow["Status"] = "90"; oRow["QXTG_Date"] = DateTime.Now.ToString(); if (oRow["XMBH"].ToString() == "") { oRow["XMBH"] = RG_DW.CreateXMBH(Request["RowGuid"], DWGuid_2021.Text, oRow["XMAdd"], oRow["XMLB"], qyzcd); } oRow["TGDate"] = DateTime.Now.ToString(); oRow.Update(); SaveOpinion("���˽����", true); } else// �����س���������������Ȼ��ת���� { oRow["Status"] = "70"; oRow["QXTG_Date"] = DateTime.Now.ToString(); oRow.Update(); dv = DBF.GetUserByRoleName("������Ϣ����");//������Ϣ���� SaveOpinion("���˽����", false); SendMessage(dv, "��������"); } } else if (srStatus == "70")//���ڳ����У�����һ����������� { dv = DBF.GetUserByRoleName("������Ϣ���"); oRow["Status"] = "86"; oRow["XMBH"] = ""; //RG_DW.CreateXMBH(Request["RowGuid"], DWGuid_2021.Text, oRow["XMAdd"], oRow["XMLB"], qyzcd); oRow["TGDate"] = DateTime.Now.ToString(); oRow.Update(); SaveOpinion("���������", true); SendMessage(dv, "�������"); } else if (srStatus == "86")//��������У�����һ������������ { dv = DBF.GetUserByRoleName("������Ϣ����"); oRow["Status"] = "87"; oRow["XMBH"] = "";// RG_DW.CreateXMBH(Request["RowGuid"], DWGuid_2021.Text, oRow["XMAdd"], oRow["XMLB"], qyzcd); oRow["TGDate"] = DateTime.Now.ToString(); oRow.Update(); SaveOpinion("���������", true); SendMessage(dv, "��������"); } else { oRow["Status"] = "90"; if (oRow["XMBH"].ToString() == "") { oRow["XMBH"] = RG_DW.CreateXMBH(Request["RowGuid"], DWGuid_2021.Text, oRow["XMAdd"], oRow["XMLB"], qyzcd); } oRow["TGDate"] = DateTime.Now.ToString(); oRow.Update(); SaveOpinion("���������", true); } #endregion } else if (oRow["XMAdd"].ToString() == "320281")//���� { #region ���� if (srStatus == "69")//���س���Ҫת���������� { oRow["Status"] = "68"; oRow["QXTG_Date"] = DateTime.Now.ToString(); oRow.Update(); dv = DBF.GetUserByRoleName("����������Ϣ����"); SaveOpinion("���������", false); SendMessage(dv, "�������"); } else if (srStatus == "68")//�������� { if (IsND)// �����س���������������Ȼ����� { oRow["Status"] = "90"; oRow["QXTG_Date"] = DateTime.Now.ToString(); if (oRow["XMBH"].ToString() == "") { oRow["XMBH"] = RG_DW.CreateXMBH(Request["RowGuid"], DWGuid_2021.Text, oRow["XMAdd"], oRow["XMLB"], qyzcd); } oRow["TGDate"] = DateTime.Now.ToString(); oRow.Update(); SaveOpinion("���������", true); } else// �����س���������������Ȼ��ת���� { oRow["Status"] = "70"; oRow["QXTG_Date"] = DateTime.Now.ToString(); oRow.Update(); dv = DBF.GetUserByRoleName("������Ϣ����"); SaveOpinion("���������", false); SendMessage(dv, "��������"); } } else if (srStatus == "70")//���ڳ����У�����һ����������� { dv = DBF.GetUserByRoleName("������Ϣ���"); oRow["Status"] = "86"; oRow["XMBH"] = ""; //RG_DW.CreateXMBH(Request["RowGuid"], DWGuid_2021.Text, oRow["XMAdd"], oRow["XMLB"], qyzcd); oRow["TGDate"] = DateTime.Now.ToString(); oRow.Update(); SaveOpinion("���������", true); SendMessage(dv, "�������"); } else if (srStatus == "86")//��������У�����һ������������ { dv = DBF.GetUserByRoleName("������Ϣ����"); oRow["Status"] = "87"; oRow["XMBH"] = "";// RG_DW.CreateXMBH(Request["RowGuid"], DWGuid_2021.Text, oRow["XMAdd"], oRow["XMLB"], qyzcd); oRow["TGDate"] = DateTime.Now.ToString(); oRow.Update(); SaveOpinion("���������", true); SendMessage(dv, "��������"); } else { oRow["Status"] = "90"; if (oRow["XMBH"].ToString() == "") { oRow["XMBH"] = RG_DW.CreateXMBH(Request["RowGuid"], DWGuid_2021.Text, oRow["XMAdd"], oRow["XMLB"], qyzcd); } oRow["TGDate"] = DateTime.Now.ToString(); oRow.Update(); SaveOpinion("���������", true); } #endregion } else { #region ���� if (srStatus == "70")//���ڳ����У�����һ����������� { dv = DBF.GetUserByRoleName("������Ϣ���"); oRow["Status"] = "86"; oRow["XMBH"] = ""; //RG_DW.CreateXMBH(Request["RowGuid"], DWGuid_2021.Text, oRow["XMAdd"], oRow["XMLB"], qyzcd); oRow["TGDate"] = DateTime.Now.ToString(); oRow.Update(); SaveOpinion("���������", true); SendMessage(dv, "��������"); } else if (srStatus == "86")//��������У�����һ������������ { dv = DBF.GetUserByRoleName("������Ϣ����"); oRow["Status"] = "87"; oRow["XMBH"] = "";// RG_DW.CreateXMBH(Request["RowGuid"], DWGuid_2021.Text, oRow["XMAdd"], oRow["XMLB"], qyzcd); oRow["TGDate"] = DateTime.Now.ToString(); oRow.Update(); SaveOpinion("���������", true); SendMessage(dv, "��������"); } else { oRow["Status"] = "90"; if (oRow["XMBH"].ToString() == "") { oRow["XMBH"] = RG_DW.CreateXMBH(Request["RowGuid"], DWGuid_2021.Text, oRow["XMAdd"], oRow["XMLB"], qyzcd); } oRow["TGDate"] = DateTime.Now.ToString(); oRow.Update(); SaveOpinion("���������", true); } #endregion } this.WriteAjaxMessage("refreshParent();"); this.WriteAjaxMessage("window.close();"); }
protected void btnEdit_Click(object sender, System.EventArgs e) { //Boolean IsSendSuccess = usermail.sendMail("smtp.163.com", "zhuwb8719", "z721054587", "*****@*****.**", EMail_2010.Text, "����ע�������Ƿ���Ч����", ""); //if (!IsSendSuccess) //{ // AlertAjaxMessage("ע��������Ч����ȷ�ϣ�"); // return; //} //UserIdendity_2010.Text = UserIdendity.Text; Boolean UserExisted = Epoint.MisBizLogic2.DB.ExecuteToInt("select count(RowGuid) from RG_User where LoginID='" + LoginID_2010.Text + "'") > 1; if (UserExisted) { AlertAjaxMessage("�õ�¼���ѱ�ʹ��,���ĵ�¼����"); return; } //if (UserType_2010.SelectedItem.Value == "002") //{ // Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, Request["RowGuid"]); // Epoint.MisBizLogic2.Data.MisGuidRow arow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_OUInfo", oRow["DanWeiGuid"].ToString()); // arow["EnterpriseName"] = EnterpriseName.Text.Trim(); // arow["CodeCertificate"] = CodeCertificate.Text.Trim(); // // arow["EnterpriseType"] = EnterpriseType.Text.Trim(); // arow["LegalPerson"] = LegalPerson.Text.Trim(); // arow["RegionCharacter"] = RegionCharacter.Text.Trim(); // arow["BusinessLicenseNO"] = BusinessLicenseNO.Text.Trim(); // arow["Contacter"] = Contacter.Text.Trim(); // arow["Tel"] = Tel.Text.Trim(); // arow["ContacterID"] = ContacterID.Text.Trim(); // arow["Email"] = Email.Text.Trim(); // arow["Address"] = Address.Text.Trim(); // arow["RegistAddress"] = RegistAddress.Text.Trim(); // arow["AttachGuid"] = ((EpointNetoffice7.Ascx.CtlMisAttachments)AttachGuid).AttachGroupGuid; // arow["BeiZhu"] = BeiZhu.Text.Trim(); // arow.Update(); // new ComDataSyn().UpdateWithKeyValue(DataSynTarget.BackEndToFront, "RG_OUInfo", "RowGuid", arow["RowGuid"].ToString()); // SaveOuType(oRow["DanWeiGuid"].ToString()); //} //if (!string.IsNullOrEmpty(ApplyDanWeiGuid)) //{ // DanWeiGuid_2010.Text = ApplyDanWeiGuid; //} //else //{ // DanWeiGuid_2010.Text = dpDanWeiGuid.SelectedValue; //} oEditPage.SaveTableValues(this.UserGuid, tdContainer); Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, this.UserGuid); oRow["UserStatus"] = "002"; oRow["DanWeiGuid"] = DanWeiGuid_2010.Text; oRow.Update(); //new ComDataSyn().UpdateWithKeyValue(DataSynTarget.BackEndToFront, "RG_User", "RowGuid", Request["RowGuid"]); // new ComDataSyn().Syn(DataSynTarget.BackEndToFront, "RG_User", "RowGuid='" + Request["RowGuid"] + "'", "RowGuid"); //SaveUserRole(); //SaveOuTypeForUser(Request["RowGuid"]); //if (HidTag.Value == "0") //{ // this.AlertAjaxMessage("������Ӧ��ɫ��"); // return; //} //else this.WriteAjaxMessage("alert('�ijɹ�');refreshParent();"); }
protected void btnAdd_Click(object sender, System.EventArgs e) { //string ServerIP = System.Configuration.ConfigurationManager.AppSettings["ServerIP"].ToString(); //string SmtpServer = System.Configuration.ConfigurationManager.AppSettings["SmtpServer"].ToString(); //string EmailFrom = System.Configuration.ConfigurationManager.AppSettings["EmailFrom"].ToString(); //string EmailAccount = System.Configuration.ConfigurationManager.AppSettings["EmailAccount"].ToString(); //string EmailPassword = System.Configuration.ConfigurationManager.AppSettings["EmailPassword"].ToString(); //Boolean IsSendSuccess = usermail.sendMail(SmtpServer, EmailAccount, EmailPassword, EmailFrom, EMail_2010.Text, "测试邮件地址是否有效。", "Test……"); //if (!IsSendSuccess) //{ // AlertAjaxMessage("您填写的邮件地址无效,请确认!"); // return; //} UserIdendity_2010.Text = UserIdendity.Text; if (!string.IsNullOrEmpty(PIN_2010.Value)) { if (Epoint.MisBizLogic2.DB.Check_Item_Exist("RG_User", "UserKey='" + common.authPassword(PIN_2010.Value) + "'")) { AlertAjaxMessage("此证书在本系统中已经被用过"); return; } else { UserKey_2010.Text = common.authPassword(PIN_2010.Value); } } if (string.IsNullOrEmpty(UserKey_2010.Text)) { // 初始化密码 Password_2010.Text = common.authPassword("11111"); } Boolean UserExisted = Epoint.MisBizLogic2.DB.ExecuteToInt("select count(RowGuid) from RG_User where LoginID='" + LoginID_2010.Text + "' and DelFlag=0") > 0; if (UserExisted) { AlertAjaxMessage("该登录名已被使用,请更换登录名!"); return; } string RowGuid = Guid.NewGuid().ToString(); //if (!string.IsNullOrEmpty(ApplyDanWeiGuid)) //{ // DanWeiGuid_2010.Text = ApplyDanWeiGuid; //} //else // if (UserType_2010.SelectedItem.Value == "002") // { // Epoint.MisBizLogic2.Data.MisGuidRow arow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_OUInfo"); // arow["RowGuid"] = Guid.NewGuid().ToString(); // arow["EnterpriseName"] = EnterpriseName.Text.Trim(); // arow["CodeCertificate"] = CodeCertificate.Text.Trim(); // arow["LegalPerson"] = LegalPerson.Text.Trim(); // arow["RegionCharacter"] = RegionCharacter.Text.Trim(); // arow["BusinessLicenseNO"] = BusinessLicenseNO.Text.Trim(); // arow["Contacter"] = Contacter.Text.Trim(); // arow["Tel"] = Tel.Text.Trim(); // arow["ContacterID"] = ContacterID.Text.Trim(); // arow["Email"] = Email.Text.Trim(); // arow["Address"] = Address.Text.Trim(); // arow["RegistAddress"] = RegistAddress.Text.Trim(); // //EpointNetoffice7.Ascx.CtlAttachments Att = new EpointNetoffice7.Ascx.CtlAttachments(); // //arow["AttachGuid"] = ((EpointNetoffice7.Ascx.CtlMisAttachments)AttachGuid).AttachGroupGuid; // arow["BeiZhu"] = BeiZhu.Text.Trim(); // arow["DelFlag"] = "0"; // arow.Insert(); // new ComDataSyn().InsertWithKeyValue(DataSynTarget.BackEndToFront, "RG_OUInfo", "RowGuid", arow["RowGuid"].ToString()); // DanWeiGuid_2010.Text = arow["RowGuid"].ToString(); // SaveOuType(arow["RowGuid"].ToString()); // } //else //{ // DanWeiGuid_2010.Text = dpDanWeiGuid.SelectedValue; //} //if (UserType_2010.SelectedValue != "001") // SaveOuTypeForUser(RowGuid); DelFlag_2010.Text = "0"; oAddPage.SaveTableValues(RowGuid, tdContainer, Request.QueryString["ParentRowGuid"]); //new ComDataSyn().InsertWithKeyValue(DataSynTarget.BackEndToFront, "RG_User", "RowGuid", RowGuid); //if (!string.IsNullOrEmpty(DanWeiGuid_2010.Text)) //{ // DataView dvApp = rgModule.GetAppForSyn(DanWeiGuid_2010.Text); // if (dvApp.Count > 0) // { // foreach (DataRowView row in dvApp) // { // new ComDataSyn().InsertWithKeyValue(row["SynTargetAddr"].ToString(), "RG_User", "RowGuid", RowGuid); // } // } //} //SaveUserRole(RowGuid); //如果是父表,要转入多表编辑页面 if (oAddPage.TableDetail.TableType == 1) { Response.Redirect("MultiPageTab.aspx?mode=Mode&TableID=了" + oAddPage.TableDetail.TableID + "&RowGuid=" + RowGuid); } Epoint.MisBizLogic2.Web.CodeGenerator.InitiateControl_AddPage(oAddPage, tdContainer); Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oAddPage.TableDetail.SQL_TableName, RowGuid); oRow["UserStatus"] = "002"; //oRow["DanWeiGuid"] = DanWeiGuid_2010.Text; oRow.Update(); string url = "Record_Edit.aspx?RowGuid=" + RowGuid; this.WriteAjaxMessage("refreshParent();alert('添加成功');window.location.href='" + url + "';"); }
protected void btnEdit_Click(object sender, System.EventArgs e) { string strSql = "SELECT s_xiangmujl_guid,s_xiangmujl FROM VIEW_CurrentVersion WHERE dwGuid='" + DWGuid_2020.Text + "'"; DataView dvUser = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql); if (dvUser.Count == 0) { WriteAjaxMessage("该企业没有对应的项目,请联系系统管理员。"); return; } string RowGuid = Request["RowGuid"]; //先判断下某个月是否已经提交过 strSql = string.Format("select count(*) from RG_YueDuCaiWu where DWGuid='{0}' and Year='{1}' and Month='{2}'", DWGuid_2020.Text, ddlYear.SelectedValue, ddlMonth.SelectedValue); //if (Epoint.MisBizLogic2.DB.ExecuteToString(strSql) != "0")//说明已经有了 //{ // //进行提示 // WriteAjaxMessage("alert('该月已经存在财务信息');"); // return; //} //如果是第一条,那么就直接提交,不要再新增一个版本了 strSql = string.Format("select count(*) from RG_YueDuCaiWu where DWGuid='{0}' and Year='{1}' and Month='{2}' and RowGuid<>'{3}'", DWGuid_2020.Text, ddlYear.SelectedValue, ddlMonth.SelectedValue, RowGuid); if (Epoint.MisBizLogic2.DB.ExecuteToString(strSql) != "0")//说明已经有了,那么就要出现新版本了 { //先将原来的保存为一个版本 //先将原来的设置为历史记录 Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, Request["RowGuid"]); oRow["IsHistory"] = "1"; //oRow["UpdateUserName"] = this.DisplayName; //oRow["UpdateUserGuid"] = this.UserGuid; //oRow["UpdateTime"] = DateTime.Now; oRow.Update(); //然后再将本版本进行提交审核 Year_2020.Text = ddlYear.SelectedValue; Month_2020.Text = ddlMonth.SelectedValue; YearMonth_2020.Text = ddlYear.SelectedValue + "-" + ddlMonth.SelectedValue + "-01 00:00:00"; UpdateUserName_2020.Text = this.DisplayName; UpdateUserGuid_2020.Text = this.UserGuid; UpdateTime_2020.Text = DateTime.Now.ToString(); Status_2020.Text = EpointRegisterUser_Bizlogic.OUStatus.待审核; IsHistory_2020.Text = "0"; RowGuid = Guid.NewGuid().ToString(); oAddPage.SaveTableValues(RowGuid, tdContainer, Request.QueryString["ParentRowGuid"]); } else//第一次 { Year_2020.Text = ddlYear.SelectedValue; Month_2020.Text = ddlMonth.SelectedValue; YearMonth_2020.Text = ddlYear.SelectedValue + "-" + ddlMonth.SelectedValue + "-01 00:00:00"; UpdateUserName_2020.Text = this.DisplayName; UpdateUserGuid_2020.Text = this.UserGuid; UpdateTime_2020.Text = DateTime.Now.ToString(); Status_2020.Text = EpointRegisterUser_Bizlogic.OUStatus.待审核; IsHistory_2020.Text = "0"; oEditPage.SaveTableValues(RowGuid, tdContainer); } #region 通知投资经理 //strSql = "SELECT top(1) EnterpriseName FROM RG_OUInfo WHERE dwGuid='" + DWGuid + "' order by row_ID desc"; //string EnterpriseName = Epoint.MisBizLogic2.DB.ExecuteToString(strSql); //先获取投资经理 if (DWGuid_2020.Text != "") { for (int m = 0; m < dvUser.Count; m++) { msg.WaitHandle_Insert( Guid.NewGuid().ToString(), "【审核】" + DWName_2020.Text + Year_2020.Text + "年" + Month_2020.Text + "月财务信息", "", dvUser[m]["s_xiangmujl_guid"].ToString(), dvUser[m]["s_xiangmujl"].ToString(), Session["UserGuid"].ToString(), Session["DisplayName"].ToString(), "", "EpointRegisterUser/Pages_RG/RG_CaiWu/RG_YueDuCaiWu_DetailForCheck.aspx?RowGuid=" + RowGuid + "&DWGuid=" + DWGuid_2020, "", "", 1, "", "", "" ); } } #endregion this.WriteAjaxMessage("refreshParent();alert('提交成功');window.close();"); //this.WriteAjaxMessage("EP_ShowMessageDiv(" + tdContainer.ClientID + ",'数据保存成功')"); }
protected void btnEdit_Click(object sender, System.EventArgs e) { string RowGuid = Request["RowGuid"]; string DWGuid = Request["DWGuid"]; string strSql = "SELECT top(1) EnterpriseName FROM RG_OUInfo WHERE dwGuid='" + DWGuid + "' order by row_ID desc"; string EnterpriseName = Epoint.MisBizLogic2.DB.ExecuteToString(strSql); //先获取投资经理 strSql = "SELECT s_xiangmujl_guid,s_xiangmujl FROM VIEW_CurrentVersion WHERE dwGuid='" + DWGuid + "'"; DataView dvUser = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql); if (dvUser.Count == 0) { WriteAjaxMessage("该企业没有对应的项目,请联系系统管理员。"); return; } if (Request["sType"] == "0") { //说明是通过新增后提交审核,那么提交审核时就不要再新增一个版本了 UpdateUserName_2019.Text = this.DisplayName; UpdateUserGuid_2019.Text = this.UserGuid; Status_2019.Text = EpointRegisterUser_Bizlogic.OUStatus.待审核; UpdateTime_2019.Text = DateTime.Now.ToString(); IsHistory_2019.Text = "0"; oEditPage.SaveTableValues(Request["RowGuid"], tdContainer); } else { //先将原来的设置为历史记录 Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, Request["RowGuid"]); oRow["IsHistory"] = "1"; //oRow["UpdateUserName"] = this.DisplayName; //oRow["UpdateUserGuid"] = this.UserGuid; //oRow["UpdateTime"] = DateTime.Now; oRow.Update(); //再新增一个即可 UpdateUserName_2019.Text = this.DisplayName; UpdateUserGuid_2019.Text = this.UserGuid; IsHistory_2019.Text = "0"; UpdateTime_2019.Text = DateTime.Now.ToString(); Status_2019.Text = EpointRegisterUser_Bizlogic.OUStatus.待审核;// "1";//0:编辑 1:待审核 2:通过 //DelFlag_2019.Text = "0"; RowGuid = Guid.NewGuid().ToString(); oAddPage.SaveTableValues(RowGuid, tdContainer, Request.QueryString["ParentRowGuid"]); } #region 保存附件 CL_YYZZ.MisRowGuid = DWGuid; CL_YYZZ.MisTableID = TableID; CL_YYZZ.ProjectGuid = ""; CL_YYZZ.Comment = DWGuid; CL_YYZZ.d_TiJiaoSJ = DateTime.Now.ToString(); CL_YYZZ.Save(); CL_SWDJZ.MisRowGuid = DWGuid; CL_SWDJZ.MisTableID = TableID; CL_SWDJZ.ProjectGuid = ""; CL_SWDJZ.Comment = DWGuid; CL_SWDJZ.d_TiJiaoSJ = DateTime.Now.ToString(); CL_SWDJZ.Save(); CL_ZZJGDM.MisRowGuid = DWGuid; CL_ZZJGDM.MisTableID = TableID; CL_ZZJGDM.ProjectGuid = ""; CL_ZZJGDM.Comment = DWGuid; CL_ZZJGDM.d_TiJiaoSJ = DateTime.Now.ToString(); CL_ZZJGDM.Save(); CL_SWPZZ.MisRowGuid = DWGuid; CL_SWPZZ.MisTableID = TableID; CL_SWPZZ.ProjectGuid = ""; CL_SWPZZ.Comment = DWGuid; CL_SWPZZ.d_TiJiaoSJ = DateTime.Now.ToString(); CL_SWPZZ.Save(); CL_QTFJ.MisRowGuid = DWGuid; CL_QTFJ.MisTableID = TableID; CL_QTFJ.ProjectGuid = ""; CL_QTFJ.Comment = DWGuid; CL_QTFJ.d_TiJiaoSJ = DateTime.Now.ToString(); CL_QTFJ.Save(); #endregion #region 通知投资经理 for (int m = 0; m < dvUser.Count; m++) { msg.WaitHandle_Insert( Guid.NewGuid().ToString(), "【审核】" + EnterpriseName + "动态信息", "", dvUser[m]["s_xiangmujl_guid"].ToString(), dvUser[m]["s_xiangmujl"].ToString(), Session["UserGuid"].ToString(), Session["DisplayName"].ToString(), "", "EpointRegisterUser/Pages_RG/RG_DongTai/RG_DongTai_DetailForCheck.aspx?RowGuid=" + RowGuid + "&DWGuid=" + DWGuid, "", "", 1, "", "", "" ); } #endregion //oEditPage.SaveTableValues(Request["RowGuid"], tdContainer); this.WriteAjaxMessage("alert('提交成功');"); RefreshGrid(); btnEdit.Visible = false; }
protected void btnSave_Click(object sender, EventArgs e) { for (int i = 0; i < Datagrid1.Items.Count; i++) { TextBox txtName = (TextBox)Datagrid1.Items[i].FindControl("txtName"); TextBox txtUrl = (TextBox)Datagrid1.Items[i].FindControl("txtUrl"); TextBox txtShortcut = (TextBox)Datagrid1.Items[i].FindControl("txtShortcut"); TextBox txtOrderNum = (TextBox)Datagrid1.Items[i].FindControl("txtOrderNum"); string gd = Convert.ToString(Datagrid1.DataKeys[i]); Epoint.MisBizLogic2.Data.MisGuidRow orow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_Application", gd); orow["AppName"] = txtName.Text; orow["AppUrl"] = txtUrl.Text; orow["ShortcutText"] = txtShortcut.Text; orow["OrderNum"] = txtOrderNum.Text; new ComDataSyn().UpdateWithKeyValue(DataSynTarget.BackEndToFront, "RG_Application", "AppGuid", gd); orow.Update(); } }
protected void btnSave_Click(object sender, EventArgs e) { for (int i = 0; i < Datagrid1.Items.Count; i++) { TextBox txtName = (TextBox)Datagrid1.Items[i].FindControl("txtName"); TextBox txtAddress = (TextBox)Datagrid1.Items[i].FindControl("txtAddress"); TextBox txtOrderNum = (TextBox)Datagrid1.Items[i].FindControl("txtOrderNum"); string gd = Convert.ToString(Datagrid1.DataKeys[i]); Epoint.MisBizLogic2.Data.MisGuidRow orow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_Matters", gd); orow["MatterName"] = txtName.Text; orow["MatterUrl"] = txtAddress.Text; orow["OrderNum"] = txtOrderNum.Text; orow.Update(); new ComDataSyn().UpdateWithKeyValue(DataSynTarget.BackEndToFront, "RG_Matters", "RowGuid", gd); } // new ComDataSyn().UpdateWithCondition(DataSynTarget.BackEndToFront, "RG_Matters", "ParentGuid='" + ParentGuid + "'and AppGuid='" + AppGuid + "'", "RowGuid"); AlertAjaxMessage("�ijɹ���"); this.RefreshGrid(); }
protected void btnEdit_Click(object sender, System.EventArgs e) { //Boolean IsSendSuccess = usermail.sendMail("smtp.163.com", "zhuwb8719", "z721054587", "*****@*****.**", EMail_2010.Text, "测试注册邮箱是否有效……", ""); //if (!IsSendSuccess) //{ // AlertAjaxMessage("注册邮箱无效,请确认!"); // return; //} //UserIdendity_2010.Text = UserIdendity.Text; Boolean UserExisted = Epoint.MisBizLogic2.DB.ExecuteToInt("select count(RowGuid) from RG_User where LoginID='" + LoginID_2010.Text + "'") > 1; if (UserExisted) { AlertAjaxMessage("该登录名已被使用,请修改登录名!"); return; } //if (UserType_2010.SelectedItem.Value == "002") //{ // Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, Request["RowGuid"]); // Epoint.MisBizLogic2.Data.MisGuidRow arow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_OUInfo", oRow["DanWeiGuid"].ToString()); // arow["EnterpriseName"] = EnterpriseName.Text.Trim(); // arow["CodeCertificate"] = CodeCertificate.Text.Trim(); // // arow["EnterpriseType"] = EnterpriseType.Text.Trim(); // arow["LegalPerson"] = LegalPerson.Text.Trim(); // arow["RegionCharacter"] = RegionCharacter.Text.Trim(); // arow["BusinessLicenseNO"] = BusinessLicenseNO.Text.Trim(); // arow["Contacter"] = Contacter.Text.Trim(); // arow["Tel"] = Tel.Text.Trim(); // arow["ContacterID"] = ContacterID.Text.Trim(); // arow["Email"] = Email.Text.Trim(); // arow["Address"] = Address.Text.Trim(); // arow["RegistAddress"] = RegistAddress.Text.Trim(); // arow["AttachGuid"] = ((EpointNetoffice7.Ascx.CtlMisAttachments)AttachGuid).AttachGroupGuid; // arow["BeiZhu"] = BeiZhu.Text.Trim(); // arow.Update(); // new ComDataSyn().UpdateWithKeyValue(DataSynTarget.BackEndToFront, "RG_OUInfo", "RowGuid", arow["RowGuid"].ToString()); // SaveOuType(oRow["DanWeiGuid"].ToString()); //} //if (!string.IsNullOrEmpty(ApplyDanWeiGuid)) //{ // DanWeiGuid_2010.Text = ApplyDanWeiGuid; //} //else //{ // DanWeiGuid_2010.Text = dpDanWeiGuid.SelectedValue; //} oEditPage.SaveTableValues(Request["RowGuid"], tdContainer); Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, Request["RowGuid"]); oRow["UserStatus"] = "002"; oRow["DanWeiGuid"] = DanWeiGuid_2010.Text; oRow.Update(); //new ComDataSyn().UpdateWithKeyValue(DataSynTarget.BackEndToFront, "RG_User", "RowGuid", Request["RowGuid"]); // new ComDataSyn().Syn(DataSynTarget.BackEndToFront, "RG_User", "RowGuid='" + Request["RowGuid"] + "'", "RowGuid"); //SaveUserRole(); //SaveOuTypeForUser(Request["RowGuid"]); //if (HidTag.Value == "0") //{ // this.AlertAjaxMessage("请分配对应角色!"); // return; //} //else this.WriteAjaxMessage("alert('修改成功');refreshParent();"); }
protected void btnEdit_Click(object sender, System.EventArgs e) { string RowGuid = Request["RowGuid"]; string DWGuid = Request["DWGuid"]; string strSql = "SELECT top(1) EnterpriseName FROM RG_OUInfo WHERE dwGuid='" + DWGuid + "' order by row_ID desc"; string EnterpriseName = Epoint.MisBizLogic2.DB.ExecuteToString(strSql); //先获取投资经理 strSql = "SELECT s_xiangmujl_guid,s_xiangmujl FROM VIEW_CurrentVersion WHERE dwGuid='" + DWGuid + "'"; DataView dvUser = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql); if (dvUser.Count == 0) { WriteAjaxMessage("该企业没有对应的项目,请联系系统管理员。"); return; } //判断是不是已经有了 this.s_qiJian_2022.Text = this.jpdYear.SelectedValue + "-" + this.jpdMonth.SelectedValue + "-" + "1"; HaiGuiInfo_2022.Text = HaiGuiInfo.Text; if (HaiGuiInfo_2022.Text.Trim() == "姓名、毕业院校、主要工作经历、本公司担任职务等") { HaiGuiInfo_2022.Text = ""; } strSql = string.Format("select count(*) from RG_RenShiInfo where DWGuid='{0}'", Request["DWGuid"]); if (Epoint.MisBizLogic2.DB.ExecuteToString(strSql) == "1")//说明没有 { //提交时直接提交,不用保存版本 UpdateUserName_2022.Text = this.DisplayName; UpdateUserGuid_2022.Text = this.UserGuid; UpdateTime_2022.Text = DateTime.Now.ToString(); Status_2022.Text = EpointRegisterUser_Bizlogic.OUStatus.待审核; IsHistory_2022.Text = "0"; oEditPage.SaveTableValues(RowGuid, tdContainer); } else { //先将原来的设置为历史记录 Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, Request["RowGuid"]); oRow["IsHistory"] = "1"; //oRow["UpdateUserName"] = this.DisplayName; //oRow["UpdateUserGuid"] = this.UserGuid; //oRow["UpdateTime"] = DateTime.Now; oRow.Update(); //然后再将本版本进行提交审核 UpdateUserName_2022.Text = this.DisplayName; UpdateUserGuid_2022.Text = this.UserGuid; UpdateTime_2022.Text = DateTime.Now.ToString(); Status_2022.Text = EpointRegisterUser_Bizlogic.OUStatus.待审核; IsHistory_2022.Text = "0"; RowGuid = Guid.NewGuid().ToString(); oAddPage.SaveTableValues(RowGuid, tdContainer, Request.QueryString["ParentRowGuid"]); } #region 通知投资经理 for (int m = 0; m < dvUser.Count; m++) { msg.WaitHandle_Insert( Guid.NewGuid().ToString(), "【审核】" + EnterpriseName + "人事信息", "", dvUser[m]["s_xiangmujl_guid"].ToString(), dvUser[m]["s_xiangmujl"].ToString(), Session["UserGuid"].ToString(), Session["DisplayName"].ToString(), "", "EpointRegisterUser/Pages_RG/RG_RenShi/RG_RenShiInfo_DetailForCheck.aspx?RowGuid=" + RowGuid + "&DWGuid=" + DWGuid, "", "", 1, "", "", "" ); } #endregion this.WriteAjaxMessage("alert('提交成功');"); RefreshGrid(); btnEdit.Visible = false; }
protected void btnSave_Click(object sender, EventArgs e) { for (int i = 0; i < Datagrid1.Items.Count; i++) { TextBox txtName = (TextBox)Datagrid1.Items[i].FindControl("txtName"); TextBox txtAddress = (TextBox)Datagrid1.Items[i].FindControl("txtAddress"); TextBox txtOrderNum = (TextBox)Datagrid1.Items[i].FindControl("txtOrderNum"); string gd = Convert.ToString(Datagrid1.DataKeys[i]); Epoint.MisBizLogic2.Data.MisGuidRow orow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_Module", gd); orow["ModuleName"] = txtName.Text; orow["ModuleAddress"] = txtAddress.Text; orow["OrderNum"] = txtOrderNum.Text; orow.Update(); new ComDataSyn().UpdateWithKeyValue(DataSynTarget.BackEndToFront, "RG_Module", "RowGuid", gd); string ModuleGuid = gd; bool isExists = Epoint.MisBizLogic2.DB.ExecuteToInt("select COUNT(*) FROM RG_Module_Right WHERE AllowGuid='All' and ModuleGuid='" + ModuleGuid + "'") > 0; CheckBox chkAllowToAll = (CheckBox)Datagrid1.Items[i].FindControl("chkAdd2"); if (chkAllowToAll.Checked) { // �����ȫ���������� // �ж��Ƿ����,�������,����Ҫ������� if (!isExists) { string RowGuid = Guid.NewGuid().ToString(); Epoint.MisBizLogic2.Data.MisGuidRow orow2 = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_Module_Right", RowGuid); orow2["ModuleGuid"] = ModuleGuid; orow2["AllowGuid"] = "All"; orow2["AllowType"] = ""; orow2.Insert(); new ComDataSyn().InsertWithKeyValue(DataSynTarget.BackEndToFront, "RG_Module_Right", "RowGuid", RowGuid); } } else { // ɾ����ȫ���������� new ComDataSyn().DeleteWithCondition(DataSynTarget.BackEndToFront, "RG_Module_Right", "AllowGuid='All'and ModuleGuid='" + ModuleGuid + "'", "RowGuid"); Epoint.MisBizLogic2.DB.ExecuteNonQuery("delete from RG_Module_Right WHERE AllowGuid='All'and ModuleGuid='" + ModuleGuid + "'"); } } }
protected void btnZS_Click(object sender, System.EventArgs e) { CheckBox chk; for (int i = 0; i < Datagrid1.Items.Count; i++) { chk = (CheckBox)Datagrid1.Items[i].FindControl("chkAdd"); if (chk.Checked) { //Epoint.MisBizLogic2.Data.CommonDataTable.DeleteRecord_FromSqlTable( // oListPage.TableID, // oListPage.TableDetail.SQL_TableName, // Convert.ToString(Datagrid1.DataKeys[i]) // ); Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oListPage.TableDetail.SQL_TableName, Convert.ToString(Datagrid1.DataKeys[i])); oRow["DelFlag"] = "1"; oRow.Update(); } } this.RefreshGrid(); }
protected void Check_Click(object sender, EventArgs e) { Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oDetailPage.TableDetail.SQL_TableName, Request["RowGuid"]);//<a href='http://www.baidu.com'>�������</a> oRow["UserStatus"] = "002"; //oRow["IsValid"] = "1"; oRow.Update(); new ComDataSyn().UpdateWithKeyValue(DataSynTarget.BackEndToFront, "RG_User", "RowGuid", Request["RowGuid"]); string EncryptedUserGuid = SymmetricMethod.Encrypto(Request["RowGuid"]); string Addr = System.Configuration.ConfigurationManager.AppSettings["Addr"].ToString(); string SmtpServer = System.Configuration.ConfigurationManager.AppSettings["SmtpServer"].ToString(); string EmailFrom = System.Configuration.ConfigurationManager.AppSettings["EmailFrom"].ToString(); string EmailAccount = System.Configuration.ConfigurationManager.AppSettings["EmailAccount"].ToString(); string EmailPassword = System.Configuration.ConfigurationManager.AppSettings["EmailPassword"].ToString(); string time = SymmetricMethod.Encrypto(System.DateTime.Now.ToString()); string ActivationAddr = Addr+"?UserGuid=" + EncryptedUserGuid + "&SendTime=" + time; Boolean IsSendSuccess = usermail.sendMail(SmtpServer, EmailAccount, EmailPassword, EmailFrom, oRow["EMail"].ToString(), "�������Ӽ������Ļ�Ա�˺ţ�", "�������ֱ�ӵ�������Ҽ����´��ڡ���\r\n <a href='" + ActivationAddr + "'>�������</a>"); if (!IsSendSuccess) { AlertAjaxMessage("�����ʼ�����ʧ�ܣ�"); return; } if (oRow["EnableSMS"].ToString() == "1") { string VerifyCode=CreateRnd(6); string content = "��ʹ��������֤�뼤���˺ţ�" + VerifyCode; Epoint.MisBizLogic2.DB.ExecuteNonQuery("update RG_User set VerifyCode='" + VerifyCode + "',SendVCodeDate='"+System.DateTime.Now.ToString()+"' where RowGuid='"+Request["RowGuid"]+"'"); new ComDataSyn().UpdateWithKeyValue(DataSynTarget.BackEndToFront,"RG_User","RowGuid",Request["RowGuid"]); string SendMobilephone = System.Configuration.ConfigurationManager.AppSettings["SendMobilephone"].ToString(); string SystemID = System.Configuration.ConfigurationManager.AppSettings["SystemID"].ToString(); SMS_Send.SendSMS("����Ա", SendMobilephone, oRow["Mobile"].ToString(), content, SystemID); } this.AlertAjaxMessage("�����ɣ�"); this.WriteAjaxMessage("refreshParent();window.close();"); }
protected void btnEdit_Click(object sender, System.EventArgs e) { string strSql = "SELECT s_xiangmujl_guid,s_xiangmujl FROM VIEW_CurrentVersion WHERE dwGuid='" + DWGuid_2020.Text + "'"; DataView dvUser = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql); if (dvUser.Count == 0) { WriteAjaxMessage("����ҵû�ж�Ӧ����Ŀ������ϵϵͳ����Ա��"); return; } string RowGuid = Request["RowGuid"]; //���ж���ij�����Ƿ��Ѿ��ύ�� strSql = string.Format("select count(*) from RG_YueDuCaiWu where DWGuid='{0}' and Year='{1}' and Month='{2}'", DWGuid_2020.Text, ddlYear.SelectedValue, ddlMonth.SelectedValue); //if (Epoint.MisBizLogic2.DB.ExecuteToString(strSql) != "0")//˵���Ѿ����� //{ // //������ʾ // WriteAjaxMessage("alert('�����Ѿ����ڲ�����Ϣ');"); // return; //} //����ǵ�һ������ô��ֱ���ύ����Ҫ������һ���汾�� strSql = string.Format("select count(*) from RG_YueDuCaiWu where DWGuid='{0}' and Year='{1}' and Month='{2}' and RowGuid<>'{3}'", DWGuid_2020.Text, ddlYear.SelectedValue, ddlMonth.SelectedValue, RowGuid); if (Epoint.MisBizLogic2.DB.ExecuteToString(strSql) != "0")//˵���Ѿ�����,��ô��Ҫ�����°汾�� { //�Ƚ�ԭ���ı���Ϊһ���汾 //�Ƚ�ԭ��������Ϊ��ʷ��¼ Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, Request["RowGuid"]); oRow["IsHistory"] = "1"; //oRow["UpdateUserName"] = this.DisplayName; //oRow["UpdateUserGuid"] = this.UserGuid; //oRow["UpdateTime"] = DateTime.Now; oRow.Update(); //Ȼ���ٽ����汾�����ύ��� Year_2020.Text = ddlYear.SelectedValue; Month_2020.Text = ddlMonth.SelectedValue; YearMonth_2020.Text = ddlYear.SelectedValue + "-" + ddlMonth.SelectedValue + "-01 00:00:00"; UpdateUserName_2020.Text = this.DisplayName; UpdateUserGuid_2020.Text = this.UserGuid; UpdateTime_2020.Text = DateTime.Now.ToString(); Status_2020.Text = EpointRegisterUser_Bizlogic.OUStatus.�����; IsHistory_2020.Text = "0"; RowGuid = Guid.NewGuid().ToString(); oAddPage.SaveTableValues(RowGuid, tdContainer, Request.QueryString["ParentRowGuid"]); } else//��һ�� { Year_2020.Text = ddlYear.SelectedValue; Month_2020.Text = ddlMonth.SelectedValue; YearMonth_2020.Text = ddlYear.SelectedValue + "-" + ddlMonth.SelectedValue + "-01 00:00:00"; UpdateUserName_2020.Text = this.DisplayName; UpdateUserGuid_2020.Text = this.UserGuid; UpdateTime_2020.Text = DateTime.Now.ToString(); Status_2020.Text = EpointRegisterUser_Bizlogic.OUStatus.�����; IsHistory_2020.Text = "0"; oEditPage.SaveTableValues(RowGuid, tdContainer); } #region ֪ͨͶ�ʾ��� //strSql = "SELECT top(1) EnterpriseName FROM RG_OUInfo WHERE dwGuid='" + DWGuid + "' order by row_ID desc"; //string EnterpriseName = Epoint.MisBizLogic2.DB.ExecuteToString(strSql); //�Ȼ�ȡͶ�ʾ��� if (DWGuid_2020.Text != "") { for (int m = 0; m < dvUser.Count; m++) { msg.WaitHandle_Insert( Guid.NewGuid().ToString(), "����ˡ�" + DWName_2020.Text + Year_2020.Text + "��" + Month_2020.Text + "�²�����Ϣ", "", dvUser[m]["s_xiangmujl_guid"].ToString(), dvUser[m]["s_xiangmujl"].ToString(), Session["UserGuid"].ToString(), Session["DisplayName"].ToString(), "", "EpointRegisterUser/Pages_RG/RG_CaiWu/RG_YueDuCaiWu_DetailForCheck.aspx?RowGuid=" + RowGuid + "&DWGuid=" + DWGuid_2020, "", "", 1, "", "", "" ); } } #endregion this.WriteAjaxMessage("refreshParent();alert('�ύ�ɹ�');window.close();"); //this.WriteAjaxMessage("EP_ShowMessageDiv(" + tdContainer.ClientID + ",'���ݱ���ɹ�')"); }
protected void btnEdit_Click(object sender, System.EventArgs e) { string RowGuid = Request["RowGuid"]; string DWGuid = Request["DWGuid"]; string strSql = "SELECT top(1) EnterpriseName FROM RG_OUInfo WHERE dwGuid='" + DWGuid + "' order by row_ID desc"; string EnterpriseName = Epoint.MisBizLogic2.DB.ExecuteToString(strSql); //�Ȼ�ȡͶ�ʾ��� strSql = "SELECT s_xiangmujl_guid,s_xiangmujl FROM VIEW_CurrentVersion WHERE dwGuid='" + DWGuid + "'"; DataView dvUser = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql); if (dvUser.Count == 0) { WriteAjaxMessage("����ҵû�ж�Ӧ����Ŀ������ϵϵͳ����Ա��"); return; } if (Request["sType"] == "0") { //˵����ͨ���������ύ��ˣ���ô�ύ���ʱ�Ͳ�Ҫ������һ���汾�� UpdateUserName_2019.Text = this.DisplayName; UpdateUserGuid_2019.Text = this.UserGuid; Status_2019.Text = EpointRegisterUser_Bizlogic.OUStatus.�����; UpdateTime_2019.Text = DateTime.Now.ToString(); IsHistory_2019.Text = "0"; oEditPage.SaveTableValues(Request["RowGuid"], tdContainer); } else { //�Ƚ�ԭ��������Ϊ��ʷ��¼ Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, Request["RowGuid"]); oRow["IsHistory"] = "1"; //oRow["UpdateUserName"] = this.DisplayName; //oRow["UpdateUserGuid"] = this.UserGuid; //oRow["UpdateTime"] = DateTime.Now; oRow.Update(); //������һ������ UpdateUserName_2019.Text = this.DisplayName; UpdateUserGuid_2019.Text = this.UserGuid; IsHistory_2019.Text = "0"; UpdateTime_2019.Text = DateTime.Now.ToString(); Status_2019.Text = EpointRegisterUser_Bizlogic.OUStatus.�����;// "1";//0:�༭ 1������� 2��ͨ�� //DelFlag_2019.Text = "0"; RowGuid = Guid.NewGuid().ToString(); oAddPage.SaveTableValues(RowGuid, tdContainer, Request.QueryString["ParentRowGuid"]); } #region ���渽�� CL_YYZZ.MisRowGuid = DWGuid; CL_YYZZ.MisTableID = TableID; CL_YYZZ.ProjectGuid = ""; CL_YYZZ.Comment = DWGuid; CL_YYZZ.d_TiJiaoSJ = DateTime.Now.ToString(); CL_YYZZ.Save(); CL_SWDJZ.MisRowGuid = DWGuid; CL_SWDJZ.MisTableID = TableID; CL_SWDJZ.ProjectGuid = ""; CL_SWDJZ.Comment = DWGuid; CL_SWDJZ.d_TiJiaoSJ = DateTime.Now.ToString(); CL_SWDJZ.Save(); CL_ZZJGDM.MisRowGuid = DWGuid; CL_ZZJGDM.MisTableID = TableID; CL_ZZJGDM.ProjectGuid = ""; CL_ZZJGDM.Comment = DWGuid; CL_ZZJGDM.d_TiJiaoSJ = DateTime.Now.ToString(); CL_ZZJGDM.Save(); CL_SWPZZ.MisRowGuid = DWGuid; CL_SWPZZ.MisTableID = TableID; CL_SWPZZ.ProjectGuid = ""; CL_SWPZZ.Comment = DWGuid; CL_SWPZZ.d_TiJiaoSJ = DateTime.Now.ToString(); CL_SWPZZ.Save(); CL_QTFJ.MisRowGuid = DWGuid; CL_QTFJ.MisTableID = TableID; CL_QTFJ.ProjectGuid = ""; CL_QTFJ.Comment = DWGuid; CL_QTFJ.d_TiJiaoSJ = DateTime.Now.ToString(); CL_QTFJ.Save(); #endregion #region ֪ͨͶ�ʾ��� for (int m = 0; m < dvUser.Count; m++) { msg.WaitHandle_Insert( Guid.NewGuid().ToString(), "����ˡ�" + EnterpriseName + "��̬��Ϣ", "", dvUser[m]["s_xiangmujl_guid"].ToString(), dvUser[m]["s_xiangmujl"].ToString(), Session["UserGuid"].ToString(), Session["DisplayName"].ToString(), "", "EpointRegisterUser/Pages_RG/RG_DongTai/RG_DongTai_DetailForCheck.aspx?RowGuid=" + RowGuid + "&DWGuid=" + DWGuid, "", "", 1, "", "", "" ); } #endregion //oEditPage.SaveTableValues(Request["RowGuid"], tdContainer); this.WriteAjaxMessage("alert('�ύ�ɹ�');"); RefreshGrid(); btnEdit.Visible = false; }
protected void btnEdit_Click(object sender, System.EventArgs e) { string RowGuid = Request["RowGuid"]; string DWGuid = Request["DWGuid"]; string strSql = "SELECT distinct s_xiangmujl_guid,s_xiangmujl FROM VIEW_CurrentVersion WHERE dwGuid='" + DWGuid + "'"; DataView dvUser = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql); if (dvUser.Count == 0) { WriteAjaxMessage("该企业没有对应的项目,请联系系统管理员。"); return; } //先将原来的设置为历史记录 Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, Request["RowGuid"]); oRow["IsHistory"] = "1"; //oRow["UpdateUserName"] = this.DisplayName; //oRow["UpdateUserGuid"] = this.UserGuid; //oRow["UpdateTime"] = DateTime.Now; oRow.Update(); //再新增一个即可 UpdateUserName_2017.Text = this.DisplayName; UpdateUserGuid_2017.Text = this.UserGuid; IsHistory_2017.Text = "0"; UpdateTime_2017.Text = DateTime.Now.ToString(); Status_2017.Text = EpointRegisterUser_Bizlogic.OUStatus.待审核;// "1";//0:编辑 1:待审核 2:通过 DelFlag_2017.Text = "0"; //DWGuid_2017.Text = DWGuid; #region 地区的保存 ZhuCeDi_2017.Text = tvZCD.Text; ZhuCeDiCode_2017.Text = tvZCD.Value; YunYingDi1_2017.Text = tvYYD1.Text; YunYingDi1Code_2017.Text = tvYYD1.Value; YunYingDi2_2017.Text = tvYYD2.Text; YunYingDi2Code_2017.Text = tvYYD2.Value; YunYingDi3_2017.Text = tvYYD3.Text; YunYingDi3Code_2017.Text = tvYYD3.Value; #endregion //oEditPage.SaveTableValues(RowGuid, tdContainer); string newGuid = Guid.NewGuid().ToString(); oAddPage.SaveTableValues(newGuid, tdContainer, Request.QueryString["ParentRowGuid"]); #region 保存附件 CL_SB.MisRowGuid = DWGuid; CL_SB.MisTableID = TableID; CL_SB.ProjectGuid = ""; CL_SB.Comment = DWGuid; CL_SB.d_TiJiaoSJ = DateTime.Now.ToString(); CL_SB.Save(); CL_Logo.MisRowGuid = DWGuid; CL_Logo.MisTableID = TableID; CL_Logo.ProjectGuid = ""; CL_Logo.Comment = DWGuid; CL_Logo.d_TiJiaoSJ = DateTime.Now.ToString(); CL_Logo.Save(); CL_GSJS.MisRowGuid = DWGuid; CL_GSJS.MisTableID = TableID; CL_GSJS.ProjectGuid = ""; CL_GSJS.Comment = DWGuid; CL_GSJS.d_TiJiaoSJ = DateTime.Now.ToString(); CL_GSJS.Save(); CL_ZS.MisRowGuid = DWGuid; CL_ZS.MisTableID = TableID; CL_ZS.ProjectGuid = ""; CL_ZS.Comment = DWGuid; CL_ZS.d_TiJiaoSJ = DateTime.Now.ToString(); CL_ZS.Save(); #endregion #region 通知投资经理 //先获取投资经理 for (int m = 0; m < dvUser.Count; m++) { msg.WaitHandle_Insert( Guid.NewGuid().ToString(), "【审核】" + EnterpriseName_2017.Text + "企业信息", "", dvUser[m]["s_xiangmujl_guid"].ToString(), dvUser[m]["s_xiangmujl"].ToString(), Session["UserGuid"].ToString(), Session["DisplayName"].ToString(), "", "EpointRegisterUser/Pages_RG/RG_OU/RG_OU_DetailForCheck.aspx?RowGuid=" + newGuid + "&DWGuid=" + DWGuid, "", "", 1, "", "", "" ); } #endregion this.WriteAjaxMessage("refreshParent();alert('提交成功');window.close();"); }