protected void btnAdd_Click(object sender, System.EventArgs e) { string RowGuid = Guid.NewGuid().ToString(); this.d_qiJian_2027.Text = this.jpdYear.SelectedValue + "-" + this.jpdMonth.SelectedValue + "-" + "1"; s_Status_2027.Text = DQStatus.编辑中; DWGuid_2027.Text = Request["DWGuid"]; ProjectGuid_2027.Text = Request["ProjectGuid"]; oAddPage.SaveTableValues(RowGuid, tdContainer, Request.QueryString["ParentRowGuid"]); CL_DQSX.MisRowGuid = RowGuid;// Request["DWGuid"]; CL_DQSX.MisTableID = TableID; CL_DQSX.ProjectGuid = ""; CL_DQSX.Comment = Request["DWGuid"]; CL_DQSX.d_TiJiaoSJ = DateTime.Now.ToString(); CL_DQSX.Save(); //如果是父表,要转入多表编辑页面 //if (oAddPage.TableDetail.TableType == 1) //{ // Response.Redirect("MultiPageTab.aspx?mode=Mode&TableID=" + oAddPage.TableDetail.TableID + "&RowGuid=" + RowGuid); //} //else //{ // this.WriteAjaxMessage ("refreshParent();"); //} //Epoint.MisBizLogic2.Web.CodeGenerator.InitiateControl_AddPage(oAddPage, tdContainer); //this.WriteAjaxMessage("EP_ShowMessageDiv(" + tdContainer.ClientID + ",'数据保存成功')"); string url = "RG_DingQi_Edit.aspx?RowGuid=" + RowGuid + "&DWGuid=" + Request["DWGuid"]; this.WriteAjaxMessage("refreshParent();alert('添加成功');window.location.href='" + url + "';"); }
protected void btnAdd_Click(object sender, System.EventArgs e) { string parentguid = Request["ParentGuid"]; if (string.IsNullOrEmpty(Request["ParentGuid"]) && string.IsNullOrEmpty(Request["AppGuid"])) { parentguid = ""; } string RowGuid = Guid.NewGuid().ToString(); if (IsDefault_131.SelectedValue == "1") { UniqueID_131.Text = dplMatterName.SelectedValue; } else { UniqueID_131.Text = ""; } AppGuid_131.Text = App.SelectedValue; if (OrderNum_131.Text == "") { OrderNum_131.Text = "-1"; } Instruction_131.Text = Content.Text; ParentGuid_131.Text = parentguid; oAddPage.SaveTableValues(RowGuid, tdContainer, Request.QueryString["ParentRowGuid"]); new ComDataSyn().InsertWithKeyValue(DataSynTarget.BackEndToFront, "RG_Matters", "RowGuid", RowGuid); this.WriteAjaxMessage("refreshParent();EP_ShowMessageDiv(" + tdContainer.ClientID + ",'数据保存成功')"); }
protected void btnAdd_Click(object sender, System.EventArgs e) { //string RowGuid = Guid.NewGuid().ToString(); //oAddPage.SaveTableValues(RowGuid, tdContainer, Request.QueryString["ParentRowGuid"]); ////如果是父表,要转入多表编辑页面 //if (oAddPage.TableDetail.TableType == 1) //{ // Response.Redirect("MultiPageTab.aspx?mode=Mode&TableID=" + oAddPage.TableDetail.TableID + "&RowGuid=" + RowGuid); //} //else //{ // this.WriteAjaxMessage ("refreshParent();"); //} //Epoint.MisBizLogic2.Web.CodeGenerator.InitiateControl_AddPage(oAddPage, tdContainer); //this.WriteAjaxMessage("EP_ShowMessageDiv(" + tdContainer.ClientID + ",'数据保存成功')"); string RowGuid = Request["RowGuid"]; string DWGuid = Request["DWGuid"]; //先判断下某个月是否已经提交过 string strSql = string.Format("select count(*) from RG_OtherInfo where DWGuid='{0}' and Year='{1}' and Month='{2}'", DWGuid, ddlYear.SelectedValue, ddlMonth.SelectedValue); if (Epoint.MisBizLogic2.DB.ExecuteToString(strSql) != "0")//说明已经有了 { //进行提示 WriteAjaxMessage("alert('该月已经存在信息');"); return; } 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; IsHistory_2021.Text = "0"; UpdateTime_2021.Text = DateTime.Now.ToString(); Status_2021.Text = EpointRegisterUser_Bizlogic.OUStatus.编辑中;//0:编辑 1:待审核 2:通过 DWGuid_2021.Text = DWGuid; 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 string url = "RG_OtherInfo_Edit.aspx?RowGuid=" + RowGuid + "&DWGuid=" + DWGuid + "&sType=0"; this.WriteAjaxMessage("alert('添加成功');window.location.href='" + url + "';"); }
protected void btnAdd_Click(object sender, System.EventArgs e) { string RowGuid = Guid.NewGuid().ToString(); ParentGuid_136.Text = Request["ParentGuid"]; CreatorGuid_136.Text = ""; if (OrderNum_136.Text == "") { OrderNum_136.Text = "-1"; } oAddPage.SaveTableValues(RowGuid, tdContainer, Request.QueryString["ParentRowGuid"]); new ComDataSyn().InsertWithKeyValue(DataSynTarget.BackEndToFront, "RG_DataGroup", "RowGuid", RowGuid); this.WriteAjaxMessage("rtnValue(\"\")"); }
protected void btnAdd_Click(object sender, System.EventArgs e) { string RowGuid = Guid.NewGuid().ToString(); oAddPage.SaveTableValues(RowGuid, tdContainer, Request.QueryString["ParentRowGuid"]); new ComDataSyn().InsertWithKeyValue(DataSynTarget.BackEndToFront, "RG_ShortcutMenu", "RowGuid", 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); this.WriteAjaxMessage("refreshParent();EP_ShowMessageDiv(" + tdContainer.ClientID + ",'数据保存成功')"); }
protected void btnAdd_Click(object sender, System.EventArgs e) { string RowGuid = Guid.NewGuid().ToString(); ParentGuid_103.Text = Request.QueryString["ParentGuid"]; if (Request["ParentGuid"] == "" && rgModule.TopModuleCode("", 4) == "") { ModuleCode_103.Text = "0001"; } else if (Request["ParentGuid"] == "") { ModuleCode_103.Text = (Convert.ToInt64(rgModule.TopModuleCode("", 4)) + 1).ToString().PadLeft(4, '0'); } else { string ParentModuleCode = Epoint.MisBizLogic2.DB.ExecuteToString("select ModuleCode from RG_Module where RowGuid='" + Request["ParentGuid"] + "'"); int CodeLength = ParentModuleCode.Length + 4; string LastModuleCode = rgModule.TopModuleCode(ParentModuleCode, CodeLength);//取得上一个ModuleCode if (string.IsNullOrEmpty(LastModuleCode)) { LastModuleCode = ParentModuleCode + "0000"; } ModuleCode_103.Text = (Convert.ToInt64(LastModuleCode) + 1).ToString().PadLeft(CodeLength, '0'); } if (string.IsNullOrEmpty(Request["AppGuid"])) { AppGuid_103.Text = BelongToApp.SelectedValue; } else { AppGuid_103.Text = Request["AppGuid"]; } if (!string.IsNullOrEmpty(AppGuid_103.Text) && string.IsNullOrEmpty(HidUrl_103.Text)) { HidUrl_103.Text = Epoint.MisBizLogic2.DB.ExecuteToString("select HidUrl from RG_Application where AppGuid='" + AppGuid_103.Text + "'"); } IsBelongtoApp_103.SelectedValue = Request["IsBelongtoApp"]; oAddPage.SaveTableValues(RowGuid, tdContainer, Request.QueryString["ParentRowGuid"]); new ComDataSyn().InsertWithKeyValue(DataSynTarget.BackEndToFront, "RG_Module", "RowGuid", 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); this.WriteAjaxMessage("refreshParent();EP_ShowMessageDiv(" + tdContainer.ClientID + ",'数据保存成功');"); this.WriteAjaxMessage("rtnValue(\"\")"); }
protected void btnAdd_Click(object sender, System.EventArgs e) { DataView dv = Epoint.MisBizLogic2.DB.ExecuteDataView("select UserName,UserPwd from RG_Application"); foreach (DataRowView row in dv) { if (row["UserName"].ToString() == UserName_118.Text && row["UserPwd"].ToString() == UserPwd_118.Text) { AlertAjaxMessage("该用户名密码已被使用,请重新填写!"); return; } } string RowGuid = Guid.NewGuid().ToString(); ParentGuid_118.Text = Request["ParentGuid"]; AppGuid_118.Text = RowGuid; UserGuid_118.Text = AppManager.Value; if (ShortcutText_118.Text == "") { ShortcutText_118.Text = AppName_118.Text; } oAddPage.SaveTableValues(RowGuid, tdContainer, Request.QueryString["ParentRowGuid"]); new ComDataSyn().InsertWithKeyValue(DataSynTarget.BackEndToFront, "RG_Application", "RowGuid", 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); string IsHoldCurPage = Epoint.Frame.Bizlogic.Frame_Config.GetConfigValue("IsHoldCurPage"); if (IsHoldCurPage == "1") { this.WriteAjaxMessage("refreshParentHoldCurPage();EP_ShowMessageDiv(" + tdContainer.ClientID + ",'数据保存成功')"); } else { this.WriteAjaxMessage("refreshParent();EP_ShowMessageDiv(" + tdContainer.ClientID + ",'数据保存成功')"); } this.WriteAjaxMessage("rtnValue(\"\")"); }
protected void btnAdd_Click(object sender, System.EventArgs e) { //string RowGuid = Guid.NewGuid().ToString(); //oAddPage.SaveTableValues(RowGuid, tdContainer, Request.QueryString["ParentRowGuid"]); ////如果是父表,要转入多表编辑页面 //if (oAddPage.TableDetail.TableType == 1) //{ // Response.Redirect("MultiPageTab.aspx?mode=Mode&TableID=" + oAddPage.TableDetail.TableID + "&RowGuid=" + RowGuid); //} //else //{ // this.WriteAjaxMessage ("refreshParent();"); //} //Epoint.MisBizLogic2.Web.CodeGenerator.InitiateControl_AddPage(oAddPage, tdContainer); //this.WriteAjaxMessage("EP_ShowMessageDiv(" + tdContainer.ClientID + ",'数据保存成功')"); string RowGuid = Request["RowGuid"]; string DWGuid = Request["DWGuid"]; 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 = ""; } UpdateUserName_2022.Text = this.DisplayName; UpdateUserGuid_2022.Text = this.UserGuid; IsHistory_2022.Text = "0"; UpdateTime_2022.Text = DateTime.Now.ToString(); Status_2022.Text = EpointRegisterUser_Bizlogic.OUStatus.编辑中;//0:编辑 1:待审核 2:通过 DWGuid_2022.Text = DWGuid; string strSql = " select top(1) EnterpriseName from rg_ouinfo where DWGuid='" + Request["DWGuid"] + "' order by row_id desc "; DWName_2022.Text = Epoint.MisBizLogic2.DB.ExecuteToString(strSql); oAddPage.SaveTableValues(RowGuid, tdContainer, Request.QueryString["ParentRowGuid"]); string url = "RG_RenShiInfo_Edit.aspx?RowGuid=" + RowGuid + "&DWGuid=" + DWGuid + "&sType=0"; this.WriteAjaxMessage("alert('添加成功');window.location.href='" + url + "';"); }
protected void btnAdd_Click(object sender, System.EventArgs e) { string RowGuid = Guid.NewGuid().ToString(); DWGuid_2023.Text = Request["DWGuid"]; PGuid_2023.Text = Request["PGuid"]; oAddPage.SaveTableValues(RowGuid, tdContainer, Request.QueryString["ParentRowGuid"]); //如果是父表,要转入多表编辑页面 //if (oAddPage.TableDetail.TableType == 1) //{ // Response.Redirect("MultiPageTab.aspx?mode=Mode&TableID=" + oAddPage.TableDetail.TableID + "&RowGuid=" + RowGuid); //} //else //{ // this.WriteAjaxMessage ("refreshParent();"); //} //Epoint.MisBizLogic2.Web.CodeGenerator.InitiateControl_AddPage(oAddPage, tdContainer); //this.WriteAjaxMessage("EP_ShowMessageDiv(" + tdContainer.ClientID + ",'数据保存成功')"); string url = "RG_GaoGuan_Edit.aspx?RowGuid=" + RowGuid; this.WriteAjaxMessage("refreshParent();alert('添加成功');window.location.href='" + url + "';"); }
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 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; } //判断是不是已经有了 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 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 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) { //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 btnAdd_Click(object sender, System.EventArgs e) { string RowGuid = Request["RowGuid"]; string DWGuid = Request["DWGuid"]; UpdateUserName_2017.Text = this.DisplayName; UpdateUserGuid_2017.Text = this.UserGuid; IsHistory_2017.Text = "0"; UpdateTime_2017.Text = DateTime.Now.ToString(); Status_2017.Text = OUStatus.编辑中;// "0";//1:编辑 2:待审核 3:通过 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 oAddPage.SaveTableValues(RowGuid, 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 //如果是父表,要转入多表编辑页面 //if (oAddPage.TableDetail.TableType == 1) //{ // Response.Redirect("MultiPageTab.aspx?mode=Mode&TableID=" + oAddPage.TableDetail.TableID + "&RowGuid=" + RowGuid); //} //else //{ // this.WriteAjaxMessage ("refreshParent();"); //} //Epoint.MisBizLogic2.Web.CodeGenerator.InitiateControl_AddPage(oAddPage, tdContainer); //this.WriteAjaxMessage("EP_ShowMessageDiv(" + tdContainer.ClientID + ",'数据保存成功')"); string url = "RG_OU_Edit.aspx?RowGuid=" + RowGuid + "&DWGuid=" + DWGuid; this.WriteAjaxMessage("refreshParent();alert('添加成功');window.location.href='" + url + "';"); }
protected void btnAdd_Click(object sender, System.EventArgs e) { string RowGuid = Request["RowGuid"]; string DWGuid = Request["DWGuid"]; 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.编辑中;//0:编辑 1:待审核 2:通过 DWGuid_2019.Text = DWGuid; oAddPage.SaveTableValues(RowGuid, tdContainer, Request.QueryString["ParentRowGuid"]); #region 保存附件 CL_ZLJS.MisRowGuid = DWGuid; CL_ZLJS.MisTableID = TableID; CL_ZLJS.ProjectGuid = ""; CL_ZLJS.Comment = DWGuid; CL_ZLJS.d_TiJiaoSJ = DateTime.Now.ToString(); CL_ZLJS.Save(); 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 ////如果是父表,要转入多表编辑页面 //if (oAddPage.TableDetail.TableType == 1) //{ // Response.Redirect("MultiPageTab.aspx?mode=Mode&TableID=" + oAddPage.TableDetail.TableID + "&RowGuid=" + RowGuid); //} //else //{ // this.WriteAjaxMessage ("refreshParent();"); //} //Epoint.MisBizLogic2.Web.CodeGenerator.InitiateControl_AddPage(oAddPage, tdContainer); //this.WriteAjaxMessage("EP_ShowMessageDiv(" + tdContainer.ClientID + ",'数据保存成功')"); string url = "RG_DongTai_Edit.aspx?RowGuid=" + RowGuid + "&DWGuid=" + DWGuid + "&sType=0"; this.WriteAjaxMessage("refreshParent();alert('添加成功');window.location.href='" + url + "';"); }