C# Data.MisGuidRow类代码示例

        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 btInsertRY_Click(object sender, EventArgs e)
 {
     //��ʼ������Ա����Ϣ��ע�⣬����Ѿ������˾Ͳ��ٽ��д���
     if (hiRYGuids.Text.Trim().ToLower() != "undefined")
     {
         string[] RYGuids = hiRYGuids.Text.Trim().Split(';');
         string RYG = "";
         string NoUsers = "";
         for (int m = 0; m < RYGuids.Length; m++)
         {
             RYG = RYGuids[m];
             if (RYG != "")
             {
                 Epoint.MisBizLogic2.Data.MisGuidRow oRowRY = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_QYUser", RYG);
                 if (!RG_DW.IsExistRYOfXM(RYG, Request["RowGuid"]))
                 {
                     RG_DW.InsertXMRY(ZiZhiDJCode_2021.Text, ZiZhiDJ_2021.Text, hiZYCode.Text, RYG, oRowRY["XM"], Request["RowGuid"], DWGuid_2021.Text, oRowRY["IDNum"], oRowRY["ZhiCheng"],
                         RG_DW.GetZCZ( oRowRY["YinZhangNo"] ,oRowRY["YinZhangNo1"],oRowRY["YinZhangNo2"]), oRowRY["ZhuanYe"], oRowRY["ZhuanYeCS"], oRowRY["ZhuanYeCSCode"], oRowRY["GongLing"], "85", hiZYText.Text);
                 }
                 else
                 {
                     NoUsers += oRowRY["XM"] + ";";
                 }
             }
         }
         if (NoUsers != "")
         {
             WriteAjaxMessage("alert('������Ա�Ѿ������ڱ���Ŀ�У�" + NoUsers + "');");
         }
         BindZhuanYe();
     }
 }

        protected void Page_Load(object sender, System.EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                string DWGuid = Request["DWGuid"];
                ViewState["TableName"] = oDetailPage.TableDetail.TableName;
                Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oDetailPage.TableDetail.SQL_TableName, Request["RowGuid"]);

                if (!oRow.R_HasFilled)
                {
                    //lblMessage.Visible=true;
                    //this.AlertAjaxMessage("û�ж�Ӧ�����ݼ�¼��");
                    //this.WriteAjaxMessage("window.close();");
                    return;
                }
                Epoint.MisBizLogic2.Web.CodeGenerator.InitiateControl_DetailPage(oDetailPage, tdContainer, oRow);

                RefreshGrid();

                #region ����
                CL_CWBB.MisRowGuid = DWGuid;
                CL_CWBB.MisTableID = TableID;
                CL_CWBB.ProjectGuid = "";
                CL_CWBB.Comment = DWGuid;
                CL_CWBB.d_TiJiaoSJ = DateTime.Now.ToString();

                CL_NDSJBG.MisRowGuid = DWGuid;
                CL_NDSJBG.MisTableID = TableID;
                CL_NDSJBG.ProjectGuid = "";
                CL_NDSJBG.Comment = DWGuid;
                CL_NDSJBG.d_TiJiaoSJ = DateTime.Now.ToString();

                #endregion
            }
        }

        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 BindOUInfo()
 {
     Epoint.MisBizLogic2.Code.DB_CodeMain codemain = new Epoint.MisBizLogic2.Code.DB_CodeMain();
     Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_User", Request["RowGuid"]);
     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();
     EnterpriseType.Text = arow["EnterpriseType"].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();
     BeiZhu.Text = arow["BeiZhu"].ToString();
     DataView dv = Epoint.MisBizLogic2.DB.ExecuteDataView("select * FROM RG_OuType_Relate WHERE RelatedGuid='" + oRow["DanWeiGuid"].ToString() + "'and RelatedType='OU'");
     string Type = "";
     foreach (DataRowView row in dv)
     {
         Type += codemain.GetCodeText_FromHash("RG_��Ա��λ", row["OuType"].ToString()) + ';';
     }
     EnterpriseType.Text = Type;
 }

        protected void Page_Load(object sender, EventArgs e)
        {
            Epoint.MisBizLogic2.Data.MisGuidRow oRowBM = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_QYUser", Request["RowGuid"]);
            if (oRowBM["CardIMG"] != DBNull.Value)
            {
                Response.Buffer = true;
                Response.Clear();
                //Response.BinaryWrite((byte[])(oRowBM["CardIMG"]));
                Response.ContentType = "image/pjpeg";
                string s = HttpUtility.UrlEncode(System.Text.UTF8Encoding.UTF8.GetBytes(oRowBM["XM"].ToString()));

                Response.AddHeader("Content-Disposition", "attachment;filename=" + s + ".jpg");
                object dbValue = oRowBM["CardIMG"];
                byte[] file = (byte[])dbValue;

                Response.BinaryWrite(file);
                Response.Flush();
                //Response.End();

                //Response.ContentType = "";
                //string s = HttpUtility.UrlEncode(System.Text.UTF8Encoding.UTF8.GetBytes("" + dt1.Rows[0]["name"].ToString() + ""));

                //Response.AddHeader("Content-Disposition", "attachment;filename=" + s + "");
                //object dbValue = dt1.Rows[0]["data"];
                //byte[] file = (byte[])dbValue;

                //Response.BinaryWrite(file);
                ////Response.BinaryWrite(file);
                //Response.Flush();
            }
        }

 /// <summary>
 /// 生成模块菜单的脚本
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 protected void btnGenerateSQL_Click(object sender, EventArgs e)
 {
     CheckBox chkSel;
     txtSQL.Text = "";
     for (int i = 0; i < Datagrid1.Items.Count; i++)
     {
         chkSel = (CheckBox)Datagrid1.Items[i].FindControl("chkAdd");
         if (chkSel.Checked)
         {
             string strSQL;
             Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_ShortcutMenu", Datagrid1.DataKeys[i].ToString());
             strSQL = "if not exists(select 1 from RG_ShortcutMenu where RowGuid = '" + oRow["RowGuid"] + "')\r\n";
             strSQL += " begin \r\n";
             strSQL += " insert into RG_ShortcutMenu(IsBlank, ShortcutType, ShortcutImg, ShortcutUrl, ShortcutText, BelongXiaQuCode, OperateUserName, OperateDate, Row_ID, YearFlag, RowGuid, IsReloadTree)";
             strSQL += " values('" + oRow["IsBlank"] + "',";
             strSQL += "'" + oRow["ShortcutType"] + "',";
             strSQL += "'" + oRow["ShortcutImg"] + "',";
             strSQL += "'" + oRow["ShortcutUrl"] + "',";
             strSQL += "'" + oRow["ShortcutText"] + "',";
             strSQL += "'" + oRow["BelongXiaQuCode"] + "',";
             strSQL += "'" + oRow["OperateUserName"] + "',";
             strSQL += "'" + oRow["OperateDate"] + "',";
             strSQL += "'" + oRow["Row_ID"] + "',";
             strSQL += "'" + oRow["YearFlag"] + "',";
             strSQL += "'" + oRow["RowGuid"] + "',";
             strSQL += "'" + oRow["IsReloadTree"] + "'";
             strSQL += ")\r\n";
             strSQL += " end \r\n";
             txtSQL.Text += strSQL;
         }
     }
 }

 protected void btnDel_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)
         {
             //����DZ༭�л��˻صģ���ֱ��ɾ����������Ѿ�ͨ���ģ�ֻ�ı�״̬
             Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oListPage.TableDetail.SQL_TableName, Convert.ToString(Datagrid1.DataKeys[i]));
             if (oRow["Status"].ToString() == "90")//���ͨ��
             {
                 RG_DW.DeleteByStatus(oListPage.TableDetail.SQL_TableName, " RowGuid='" + oListPage.TableDetail.SQL_TableName + "' ");
             }
             else
             {
                 Epoint.MisBizLogic2.Data.CommonDataTable.DeleteRecord_FromSqlTable(
                    oListPage.TableID,
                    oListPage.TableDetail.SQL_TableName,
                    Convert.ToString(Datagrid1.DataKeys[i])
                    );
             }
         }
     }
     this.AlertAjaxMessage("ɾ���ɹ���");
     this.RefreshGrid();
 }

        protected void btnSave_Click(object sender, EventArgs e)
        {
            string str = Convert.ToString(HidUserList.Value);
            string AppGuid = Request.QueryString["AppGuid"];
            DataView dv = Epoint.MisBizLogic2.DB.ExecuteDataView("select AllowGuid from RG_Application_Right where AppGuid='" + AppGuid + "'and AllowType='User'");
            if (str.Length == 0)
            {
                new ComDataSyn().DeleteWithCondition(DataSynTarget.BackEndToFront, "RG_Application_Right", "AppGuid='" + AppGuid + "'and AllowType='User'", "RowGuid");

                Epoint.MisBizLogic2.DB.ExecuteNonQuery("delete from RG_Application_Right where AppGuid='" + AppGuid + "'and AllowType='User'");
            }
            else
            {
                str = str.Substring(0, str.Length - 1);
                string[] strArray = str.Split(';');
                foreach (string s in strArray)
                {
                    if (!string.IsNullOrEmpty(s))
                    {
                        string RowGuid = Guid.NewGuid().ToString();
                        int count = 0;
                        foreach (DataRowView row in dv)
                        {
                            if (Convert.ToString(row[0]) == s)
                            {
                                count++;
                            }
                        }
                        if (count == 0)
                        {
                            Epoint.MisBizLogic2.Data.MisGuidRow orow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_Application_Right", RowGuid);
                            orow["AppGuid"] = AppGuid;
                            orow["AllowGuid"] = s;
                            orow["AllowType"] = "User";
                            orow["AppType"] = Request["AppType"];
                            orow.Insert();
                            new ComDataSyn().InsertWithKeyValue(DataSynTarget.BackEndToFront, "RG_Application_Right", "RowGuid", RowGuid);
                        }
                    }

                }
                foreach (DataRowView row in dv)
                {
                    int count = 0;
                    foreach (string s in strArray)
                    {
                        if (Convert.ToString(row[0]) == s)
                        {
                            count++;
                        }
                    }
                    if (count == 0)
                    {
                        new ComDataSyn().DeleteWithCondition(DataSynTarget.BackEndToFront, "RG_Application_Right", "AllowGuid='" + Convert.ToString(row[0]) + "'and AppGuid='" + AppGuid + "'and AllowType='User'", "RowGuid");
                        Epoint.MisBizLogic2.DB.ExecuteNonQuery("delete from RG_Application_Right where AllowGuid='" + Convert.ToString(row[0]) + "'and AppGuid='" + AppGuid + "'and AllowType='User'");
                    }
                }
            }
            WriteAjaxMessage("window.close();");
        }

        protected void Page_Load(object sender, System.EventArgs e)
        {
            if (!Page.IsPostBack )
            {

                ViewState ["TableName"]=oDetailPage.TableDetail.TableName;
                Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oDetailPage.TableDetail.SQL_TableName, Request["RowGuid"]);

                if (!oRow.R_HasFilled)
                {
                    //lblMessage.Visible=true;
                    //this.AlertAjaxMessage ("û�ж�Ӧ�����ݼ�¼��");
                    //this.WriteAjaxMessage("window.close();");
                    return;
                }
                Epoint.MisBizLogic2.Web.CodeGenerator.InitiateControl_DetailPage(oDetailPage, tdContainer, oRow);
                CL_DQSX.MisRowGuid = Request["RowGuid"];
                CL_DQSX.MisTableID = TableID;
                CL_DQSX.ProjectGuid = "";
                CL_DQSX.Comment = Request["DWGuid"];
                CL_DQSX.d_TiJiaoSJ = DateTime.Now.ToString();
                if (d_qiJian_2027.Text != "")
                {
                    lblSJ.Text = DateTime.Parse(d_qiJian_2027.Text).ToString("yyyy��MM��");
                }
            }
        }

        protected void btnSave_Click(object sender, EventArgs e)
        {
            string VUserGuid = Request.QueryString["RowGuid"];
            DataView dv = Epoint.MisBizLogic2.DB.ExecuteDataView("select MapGuid from RG_VUser where VUserGuid='" + VUserGuid + "'and MapType='OU'");
            string str = Convert.ToString(HidOuList.Value);
            if (str.Length == 0)
            {
                new ComDataSyn().DeleteWithCondition(DataSynTarget.BackEndToFront, "RG_VUser", " VUserGuid='" + VUserGuid + "'and MapType='OU'", "RowGuid");

                Epoint.MisBizLogic2.DB.ExecuteNonQuery("delete from RG_VUser where VUserGuid='" + VUserGuid + "'and MapType='OU'");
            }
            else
            {
                str = str.Substring(0, str.Length - 1);
                string[] strArray = str.Split('★');

                foreach (string s in strArray)
                {
                    string RowGuid = Guid.NewGuid().ToString();
                    string MapType = "OU";
                    int count = 0;
                    foreach (DataRowView row in dv)
                    {
                        if (Convert.ToString(row[0]) == s)
                        {
                            count++;
                        }
                    }
                    if (count == 0)
                    {
                        Epoint.MisBizLogic2.Data.MisGuidRow orow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_VUser", RowGuid);
                        orow["VUserGuid"] = VUserGuid;
                        orow["MapType"] = MapType;
                        orow["MapGuid"] = s;
                        orow.Insert();
                        new ComDataSyn().InsertWithKeyValue(DataSynTarget.BackEndToFront, "RG_VUser", "RowGuid", RowGuid);
                    }
                }
                foreach (DataRowView row in dv)
                {
                    int count = 0;
                    foreach (string s in strArray)
                    {

                        if (Convert.ToString(row[0]) == s)
                        {
                            count++;
                        }
                    }
                    if (count == 0)
                    {
                        new ComDataSyn().DeleteWithCondition(DataSynTarget.BackEndToFront, "RG_VUser", "MapGuid='" + Convert.ToString(row[0]) + "'and VUserGuid='" + VUserGuid + "'and MapType='OU'", "RowGuid");

                        Epoint.MisBizLogic2.DB.ExecuteNonQuery("delete from RG_VUser where MapGuid='" + Convert.ToString(row[0]) + "'and VUserGuid='" + VUserGuid + "'and MapType='OU'");
                    }
                }
            }
            WriteAjaxMessage("window.close();");
        }

        protected void btnSave_Click(object sender, EventArgs e)
        {
            string str = Convert.ToString(HidRoleList.Value);
            string MatterGuid = Request.QueryString["MatterGuid"];
            DataView dv = Epoint.MisBizLogic2.DB.ExecuteDataView("select AllowGuid,RowGuid from RG_Matter_Right where MatterGuid='" + MatterGuid + "'and (AllowType='Role' or AllowType='UserType')");
            if (str.Length == 0)
            {
                new ComDataSyn().DeleteWithCondition(DataSynTarget.BackEndToFront, "RG_Matter_Right", "MatterGuid='" + MatterGuid + "'and (AllowType='Role' or AllowType='UserType')", "RowGuid");
                Epoint.MisBizLogic2.DB.ExecuteNonQuery("delete from RG_Matter_Right where MatterGuid='" + MatterGuid + "'and (AllowType='Role' or AllowType='UserType')");
            }
            else
            {
                str = str.Substring(0, str.Length - 1);
                string[] strArray = str.Split(';');
                foreach (string s in strArray)
                {
                    if (!string.IsNullOrEmpty(s))
                    {
                        string RowGuid = Guid.NewGuid().ToString();
                        Boolean needtoAdd = true;
                        foreach (DataRowView row in dv)
                        {
                            if (Convert.ToString(row["AllowGuid"]) == s.Split('@')[0])
                            {
                                needtoAdd = false;
                            }
                        }
                        if (needtoAdd)
                        {
                            Epoint.MisBizLogic2.Data.MisGuidRow orow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_Matter_Right", RowGuid);
                            orow["MatterGuid"] = MatterGuid;
                            orow["AllowGuid"] = s.Split('@')[0];
                            orow["AllowType"] = s.Split('@')[1];
                            orow.Insert();
                            new ComDataSyn().InsertWithKeyValue(DataSynTarget.BackEndToFront, "RG_Matter_Right", "RowGuid", RowGuid);
                        }
                    }

                }
                foreach (DataRowView row in dv)
                {
                    Boolean needtoDel = true;
                    foreach (string s in strArray)
                    {
                        if (Convert.ToString(row["AllowGuid"]) == s.Split('@')[0])
                        {
                            needtoDel = false;
                        }
                    }
                    if (needtoDel)
                    {
                        new ComDataSyn().DeleteWithKeyValue(DataSynTarget.BackEndToFront, "RG_Matter_Right", "RowGuid", row["RowGuid"].ToString());
                        Epoint.MisBizLogic2.DB.ExecuteNonQuery("delete from RG_Matter_Right where RowGuid='" + row["RowGuid"].ToString() + "'");
                    }
                }
            }
            SaveAllowToAll();
            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 SaveRelation(string VUserGuid)
 {
     string RowGuid = Guid.NewGuid().ToString();
     Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_VUser");
     oRow["RowGuid"] = RowGuid;
     oRow["VUserGuid"] = VUserGuid;
     oRow["MapGuid"] = Session["UserGuid"];
     oRow["MapType"] = "User";
     oRow.Insert();
     new ComDataSyn().InsertWithKeyValue(DataSynTarget.BackEndToFront, "RG_VUser", "RowGuid", RowGuid);
 }

        protected void Page_Load(object sender, System.EventArgs e)
        {
            if (!Page.IsPostBack )
            {
                ViewState["TableName"] = oEditPage.TableDetail.TableName;
                Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, Request["RowGuid"]);
                if (!oRow.R_HasFilled)
                {
                    btnEdit.Visible = false;
                    this.AlertAjaxMessage ("û�ж�Ӧ�����ݼ�¼��");
                    this.WriteAjaxMessage("window.close();");
                    return;
                }
                Epoint.MisBizLogic2.Web.CodeGenerator.InitiateControl_EditPage(oEditPage, tdContainer, oRow);
                //����ϴ��ļ��Ĵ�С�����ͼ��
                this.Add_FileUploadCheck_Script();

                #region
                if (this.d_qiJian_2027.Text == "")
                {
                    this.d_qiJian_2027.Text = DateTime.Now.ToString();
                }
                int thisYear = DateTime.Parse(this.d_qiJian_2027.Text.ToString()).Year;
                int thisMonth = DateTime.Parse(this.d_qiJian_2027.Text.ToString()).Month;
                for (int i = thisYear - 15; i <= thisYear; i++)
                {
                    jpdYear.Items.Add(new ListItem(i.ToString(), i.ToString()));
                }

                for (int i = 1; i <= 12; i++)
                {
                    jpdMonth.Items.Add(new ListItem(i.ToString(), i.ToString()));
                }

                jpdYear.SelectedValue = thisYear.ToString();
                jpdMonth.SelectedValue = thisMonth.ToString();

                #endregion

                if (s_Status_2027.Text == DQStatus.�����)
                {
                    btnEdit.Visible = false;
                    btnWC.Visible = false;
                    CL_DQSX.ReadOnly = true;
                }

                CL_DQSX.MisRowGuid = Request["RowGuid"];
                CL_DQSX.MisTableID = TableID;
                CL_DQSX.ProjectGuid = "";
                CL_DQSX.Comment = Request["DWGuid"];
                CL_DQSX.d_TiJiaoSJ = DateTime.Now.ToString();
            }
        }