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 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 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 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 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 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 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();
}
}
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 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��");
}
}
}
/// <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 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 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 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);
}
public string getSource(string MatterGuid)
{
if (Epoint.MisBizLogic2.DB.ExecuteToInt("select count(1) from RG_Matters where ParentGuid='" + MatterGuid + "'") > 0)
return "";
else
{
Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_Matters",MatterGuid);
if (string.IsNullOrEmpty(oRow["AppGuid"].ToString()))
return "ƽ̨�ṩ";
else return Epoint.MisBizLogic2.DB.ExecuteToString("select AppName from RG_Application where AppGuid='"+oRow["AppGuid"].ToString()+"'");
}
}
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();
}
}
protected void btnDown_Click(object sender, System.EventArgs e)
{
HtmlInputCheckBox chk;
string tempGuid = this.UserGuid + "-LS";
string strUrl = HttpContext.Current.Server.MapPath(GetApplicationPath()) + "AttachStorage\\" + tempGuid + "\\";
DirectoryInfo Dir = new DirectoryInfo(strUrl);
if (!Directory.Exists(strUrl))
{
Directory.CreateDirectory(strUrl);
}
foreach (string item in System.IO.Directory.GetFiles(strUrl))
{
FileInfo FI = new FileInfo(item);
File.Delete(item);
}
for (int i = 0; i < Datagrid1.Items.Count; i++)
{
chk = (HtmlInputCheckBox)Datagrid1.Items[i].FindControl("chkAdd");
//ѭ�������ļ�
if (chk.Checked)
{
StringBuilder sb = new StringBuilder();
Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oListPage.TableDetail.SQL_TableName, Datagrid1.DataKeys[i].ToString());
string strFileName = oRow["pic_FuJian_FileName"].ToString();
strFileName = ChangFileName(strUrl, strFileName, 0);//����Ƿ���Ҫ��������
string filePath = strUrl + strFileName;
FileStream objFileStream;
BinaryWriter objBinaryWriter;
objFileStream = new FileStream(filePath, FileMode.OpenOrCreate, FileAccess.Write);
objBinaryWriter = new BinaryWriter(objFileStream);
objBinaryWriter.Write((byte[])oRow["pic_FuJian"]);
objBinaryWriter.Close();
objFileStream.Close();
}
}
//ѭ�����
string fileName = DateTime.Now.ToString("yyyyMMddHHmmss");
zip.Name = fileName ;
//zip = new ZipFile(strUrl + zip.Name + ".zip");
foreach (string item in System.IO.Directory.GetFiles(strUrl))
{
zip.AddFile(item, "");
}
//zip.
zip.Save(strUrl + zip.Name + ".zip");
WriteAjaxMessage("OpenWindow('RG_DownZip.aspx?zipname=" + fileName + "'),800,600");
}
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();
RegionTreeView.Text = ZiZhiText_2020.Text;
RegionTreeView.Value = ZiZhiTextCode_2020.Text;
string strSql = "SELECT EnterpriseName FROM RG_OUInfo WHERE RowGuid='" + DWGuid_2020.Text + "'";
lblDWName.Text = Epoint.MisBizLogic2.DB.ExecuteToString(strSql);
ZZ_ZS_Z.ClientGuid = Request["RowGuid"] + "ZZ_ZS_Z";
ZZ_ZS_Z.NodeCode = DWGuid_2020.Text;
ZZ_ZS_Z.MisRowGuid = Request["RowGuid"];
ZZ_ZS_F.ClientGuid = Request["RowGuid"] + "ZZ_ZS_F";
ZZ_ZS_F.NodeCode = DWGuid_2020.Text;
ZZ_ZS_F.MisRowGuid = Request["RowGuid"];
if (oRow["Status"].ToString() == "90")//ͨ��
{
//btnEdit.Visible = false;
}
else if (oRow["Status"].ToString() == "80")//��ͨ��
{
//btnEdit.Visible = false;
}
else if (oRow["Status"].ToString() == "70")//�����
{
//btnEdit.Visible = false;
//btnSubmit.Visible = false;
//ZZ_ZS_Z.ReadOnly = true;
//ZZ_ZS_F.ReadOnly = true;
}
lblSHOpinion.Text = RG_DW.GetSHOpinion(Request["RowGuid"], "");
}
InitTree();
}
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 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)
{
this.AlertAjaxMessage ("û�ж�Ӧ�����ݼ�¼��");
this.WriteAjaxMessage("window.close();");
return;
}
Epoint.MisBizLogic2.Web.CodeGenerator.InitiateControl_DetailPage(oDetailPage, tdContainer, oRow);
AppManager.Text=Epoint.MisBizLogic2.DB.ExecuteToString("select DisplayName from Frame_User inner join RG_Application on Frame_User.UserGuid=RG_Application.UserGuid where RowGuid='" + Request["RowGuid"] + "'");
}
}
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 InsertUser(string LoginID, string DanWeiGuid,string LXR)
{
string strSql = "select ZuZhiJGDM from RG_OUInfo where RowGuid='" + DanWeiGuid + "'";
//ZuZhiJGDM_2020.Text = Epoint.MisBizLogic2.DB.ExecuteToString(strSql);
Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_User");
oRow["OperateDate"] = DateTime.Now.ToString();//System.DateTime
oRow["RowGuid"] = Guid.NewGuid().ToString();//System.String
oRow["DispName"] = LXR;//System.String
oRow["LoginID"] = LoginID;//System.String
oRow["Password"] = common.authPassword(LoginID);//System.String
oRow["EnableSMS"] = "0";//System.String
oRow["IsValid"] = "1";//System.String
oRow["DanWeiGuid"] = DanWeiGuid;
oRow["UserStatus"] = "002";//System.Stringg
oRow["DelFlag"] = "0";//System.Int32
oRow["ZuZhiJGDM"] = Epoint.MisBizLogic2.DB.ExecuteToString(strSql);
oRow.Insert();
}
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 btnQuickNew_Click(object sender, EventArgs e)
{
string RowGuid = Guid.NewGuid().ToString();
Epoint.MisBizLogic2.Data.MisGuidRow orow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_Application", RowGuid);
orow["AppGuid"] = RowGuid;
orow["AppName"] = "��ϵͳ����";
orow["ShortcutText"] = Convert.ToString(orow["AppName"]);
orow["IsForbid"] = 0;
orow["OrderNum"] = -1;
orow["IsBlank"] = 0;
orow["IsTopMenu"] = 0;
orow["AuditedOUVisible"] = 0;
orow["OperateUserName"] = Convert.ToString(Session["DisplayName"]);
orow["OperateDate"] = System.DateTime.Now.ToString();
orow.Insert();
new ComDataSyn().InsertWithKeyValue(DataSynTarget.BackEndToFront, "RG_Application", "AppGuid", RowGuid);
this.RefreshGrid();
}
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);
}
}
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();
}
}
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();
ShortcutType_114.SelectedIndex = ShortcutType_114.Items.IndexOf(ShortcutType_114.Items.FindByValue(oRow["ShortcutType"].ToString()));
}
}
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 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 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);
BindApp(oRow["AppGuid"].ToString());
Content.Text = oRow["Instruction"].ToString();
//����ϴ��ļ��Ĵ�С�����ͼ��
this.Add_FileUploadCheck_Script();
if (Epoint.MisBizLogic2.DB.ExecuteToString("select ParentGuid from RG_Matters where RowGuid='" + oRow["RowGuid"].ToString() + "'") == "")
{
trIsHangPage.Style["display"] = "";
trInstr.Style["display"] = "none";
}
else
{
trIsHangPage.Style["display"] = "none";
trInstr.Style["display"] = "";
}
if (oRow["IsDefault"].ToString() == "0")
MatterNameSel.Style["display"] = "none";
else
{
MatterNameSel.Style["display"] = "";
BindMatterName();
dplMatterName.SelectedIndex = dplMatterName.Items.IndexOf(dplMatterName.Items.FindByValue(oRow["UniqueID"].ToString()));
}
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
if (!Page.IsPostBack)
{
string RowGuid = Request["RowGuid"];
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);
#region 附件
//CL_ZLJS.MisRowGuid = DWGuid;
//CL_ZLJS.MisTableID = TableID;
//CL_ZLJS.ProjectGuid = "";
//CL_ZLJS.Comment = DWGuid;
//CL_ZLJS.d_TiJiaoSJ = DateTime.Now.ToString();
CL_YYZZ.MisRowGuid = DWGuid;
CL_YYZZ.MisTableID = TableID;
CL_YYZZ.ProjectGuid = "";
CL_YYZZ.Comment = DWGuid;
CL_YYZZ.d_TiJiaoSJ = DateTime.Now.ToString();
CL_SWDJZ.MisRowGuid = DWGuid;
CL_SWDJZ.MisTableID = TableID;
CL_SWDJZ.ProjectGuid = "";
CL_SWDJZ.Comment = DWGuid;
CL_SWDJZ.d_TiJiaoSJ = DateTime.Now.ToString();
CL_ZZJGDM.MisRowGuid = DWGuid;
CL_ZZJGDM.MisTableID = TableID;
CL_ZZJGDM.ProjectGuid = "";
CL_ZZJGDM.Comment = DWGuid;
CL_ZZJGDM.d_TiJiaoSJ = DateTime.Now.ToString();
CL_SWPZZ.MisRowGuid = DWGuid;
CL_SWPZZ.MisTableID = TableID;
CL_SWPZZ.ProjectGuid = "";
CL_SWPZZ.Comment = DWGuid;
CL_SWPZZ.d_TiJiaoSJ = DateTime.Now.ToString();
CL_QTFJ.MisRowGuid = DWGuid;
CL_QTFJ.MisTableID = TableID;
CL_QTFJ.ProjectGuid = "";
CL_QTFJ.Comment = DWGuid;
CL_QTFJ.d_TiJiaoSJ = DateTime.Now.ToString();
#endregion
RefreshGrid();
RefreshGrid2();
BindGongSi();
BindTuanDui();
BindBuTie();
}
}
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 Page_Load(object sender, System.EventArgs e)
{
if (!Page.IsPostBack)
{
string DWGuid = "";
string RowGuid = "";
string strURL = "";
//先判断是否是跳转过来的
if (String.IsNullOrEmpty(Request["RowGuid"]))//不是跳转
{
//判断有没有记录，如果没有记录的话，就直接跳转到新增页面
string strSql = " select top(1) DWGuid from rg_ouinfo where DWGuid=(select distinct DanWeiGuid from RG_User where RowGuid='" + Session["UserGuid"].ToString() + "') order by row_id desc ";
DWGuid = Epoint.MisBizLogic2.DB.ExecuteToString(strSql);
strSql = " select top(1) RowGuid from RG_RenShiInfo where DWGuid='" + DWGuid + "' order by row_id desc ";
RowGuid = Epoint.MisBizLogic2.DB.ExecuteToString(strSql);
if (RowGuid == "")//说明没有记录，就跳转到新增页面
{
strURL = "RG_RenShiInfo_Add.aspx?ParentRowGuid=&RowGuid=" + Guid.NewGuid().ToString() + "&DWGuid=" + DWGuid + "";
this.WriteAjaxMessage("window.location.href='" + strURL + "';");
return;
}
else//如果有记录，也要跳转到本页面重新加载
{
strURL = "RG_RenShiInfo_Edit.aspx?RowGuid=" + RowGuid + "&DWGuid=" + DWGuid + "";
this.WriteAjaxMessage("window.location.href='" + strURL + "';");
return;
}
}
else//是跳转
{
RowGuid = Request["RowGuid"];
DWGuid = Request["DWGuid"];
}
ViewState["TableName"] = oEditPage.TableDetail.TableName;
Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(oEditPage.TableDetail.SQL_TableName, 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();
RefreshGrid();
if (Status_2022.Text == EpointRegisterUser_Bizlogic.OUStatus.待审核)
{
btnEdit.Visible = false;
}
if (HaiGuiInfo_2022.Text != "" && HaiGuiInfo_2022.Text.Trim() != "姓名、毕业院校、主要工作经历、本公司担任职务等")
{
HaiGuiInfo.Text = HaiGuiInfo_2022.Text;
}
#region
if (this.s_qiJian_2022.Text == "")
{
this.s_qiJian_2022.Text = DateTime.Now.ToString();
}
int thisYear = DateTime.Parse(this.s_qiJian_2022.Text.ToString()).Year;
int thisMonth = DateTime.Parse(this.s_qiJian_2022.Text.ToString()).Month;
for (int i = thisYear - 15; i <= thisYear; i++)
{
jpdYear.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
for (int i = 1, tag = 1; i <= 12; i = i + 3, tag++)
{
jpdMonth.Items.Add(new ListItem(tag.ToString(), i.ToString()));
}
jpdYear.SelectedValue = thisYear.ToString();
if (thisMonth.ToString() == "1" || thisMonth.ToString() == "2" || thisMonth.ToString() == "3")
{
jpdMonth.SelectedIndex = 0;
}
else if (thisMonth.ToString() == "4" || thisMonth.ToString() == "5" || thisMonth.ToString() == "6")
{
jpdMonth.SelectedIndex = 1;
}
else if (thisMonth.ToString() == "7" || thisMonth.ToString() == "8" || thisMonth.ToString() == "9")
{
jpdMonth.SelectedIndex = 2;
}
else
{
jpdMonth.SelectedIndex = 3;
}
#endregion
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string str = Convert.ToString(HidOUTypeList.Value);
string ShortcutGuid = Request.QueryString["ShortcutGuid"];
DataView dv = Epoint.MisBizLogic2.DB.ExecuteDataView("select AllowGuid from RG_ShortcutMenu_Right where ShortcutGuid='" + ShortcutGuid + "'and AllowType='OUType'");
if (str.Length == 0)
{
new ComDataSyn().DeleteWithCondition(DataSynTarget.BackEndToFront, "RG_ShortcutMenu_Right", "ShortcutGuid='" + ShortcutGuid + "'and AllowType='OUType'", "RowGuid");
Epoint.MisBizLogic2.DB.ExecuteNonQuery("delete from RG_ShortcutMenu_Right where ShortcutGuid='" + ShortcutGuid + "'and AllowType='OUType'");
}
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_ShortcutMenu_Right", RowGuid);
orow["ShortcutGuid"] = ShortcutGuid;
orow["AllowGuid"] = s;
orow["AllowType"] = "OUType";
orow.Insert();
new ComDataSyn().InsertWithKeyValue(DataSynTarget.BackEndToFront, "RG_ShortcutMenu_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_ShortcutMenu_Right", "AllowGuid='" + Convert.ToString(row[0]) + "'and ShortcutGuid='" + ShortcutGuid + "'and AllowType='OUType'", "RowGuid");
Epoint.MisBizLogic2.DB.ExecuteNonQuery("delete from RG_ShortcutMenu_Right where AllowGuid='" + Convert.ToString(row[0]) + "'and ShortcutGuid='" + ShortcutGuid + "'and AllowType='OUType'");
}
}
}
WriteAjaxMessage("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 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);
//如果只是查看，那么也不显示按钮
if (String.IsNullOrEmpty(Request["MessageItemGuid"]))
{
tabOP.Visible = false;
}
SFZ.ClientGuid = Request["RowGuid"] + "RY_SFZ";
SFZ.NodeCode = DWGuid_2019.Text;
SFZ.MisRowGuid = Request["RowGuid"];
BYZ.ClientGuid = Request["RowGuid"] + "RY_BYZ";
BYZ.NodeCode = DWGuid_2019.Text;
BYZ.MisRowGuid = Request["RowGuid"];
ZCZJ.ClientGuid = Request["RowGuid"] + "RY_ZCZJ";
ZCZJ.NodeCode = DWGuid_2019.Text;
ZCZJ.MisRowGuid = Request["RowGuid"];
ZhiCheng.ClientGuid = Request["RowGuid"] + "RY_ZhiCheng";
ZhiCheng.NodeCode = DWGuid_2019.Text;
ZhiCheng.MisRowGuid = Request["RowGuid"];
LDHT.ClientGuid = Request["RowGuid"] + "RY_LDHT";
LDHT.NodeCode = DWGuid_2019.Text;
LDHT.MisRowGuid = Request["RowGuid"];
GRQT.ClientGuid = Request["RowGuid"] + "RY_GRQT";
GRQT.NodeCode = DWGuid_2019.Text;
GRQT.MisRowGuid = Request["RowGuid"];
GRQM.ClientGuid = Request["RowGuid"] + "RY_GRQM";
GRQM.NodeCode = DWGuid_2019.Text;
GRQM.MisRowGuid = Request["RowGuid"];
Epoint.MisBizLogic2.Data.MisGuidRow oRowOU = new Epoint.MisBizLogic2.Data.MisGuidRow(oDetailOUPage.TableDetail.SQL_TableName, DWGuid_2019.Text);
Epoint.MisBizLogic2.Web.CodeGenerator.InitiateControl_DetailPage(oDetailOUPage, tdContainer, oRowOU);
GSZZ_Z.ClientGuid = DWGuid_2019.Text + "QY_GSZZ_Z";
GSZZ_Z.ClientTag = "工商营业执照(正本)";
GSZZ_Z.NodeCode = DWGuid_2019.Text;
GSZZ_Z.MisRowGuid = DWGuid_2019.Text;
GSZZ_F.ClientGuid = DWGuid_2019.Text + "QY_GSZZ_F";
GSZZ_F.ClientTag = "工商营业执照(副本)";
GSZZ_F.NodeCode = DWGuid_2019.Text;
GSZZ_Z.MisRowGuid = DWGuid_2019.Text;
ZZJGDMZ.ClientGuid = DWGuid_2019.Text + "QY_ZZJGDMZ";
ZZJGDMZ.ClientTag = "组织机构代码证";
ZZJGDMZ.NodeCode = DWGuid_2019.Text;
ZZJGDMZ.MisRowGuid = DWGuid_2019.Text;
FRSFZ.ClientGuid = DWGuid_2019.Text + "QY_FRSFZ";
FRSFZ.ClientTag = "法定代表人身份证";
FRSFZ.NodeCode = DWGuid_2019.Text;
FRSFZ.MisRowGuid = DWGuid_2019.Text;
FRQM.ClientGuid = DWGuid_2019.Text + "QY_FRQM";
FRQM.ClientTag = "法定代表人签名";
FRQM.NodeCode = DWGuid_2019.Text;
FRQM.MisRowGuid = DWGuid_2019.Text;
SBZM.ClientGuid = DWGuid_2019.Text + "QY_SBZM";
SBZM.ClientTag = "社会保险证明材料(近6个月)";
SBZM.NodeCode = DWGuid_2019.Text;
GSZZ_Z.MisRowGuid = DWGuid_2019.Text;
QT.ClientGuid = DWGuid_2019.Text + "QY_QYQT";
QT.ClientTag = "企业其它文件";
QT.NodeCode = DWGuid_2019.Text;
QT.MisRowGuid = DWGuid_2019.Text;
lblSHOpinion.Text = RG_DW.GetSHOpinion(Request["RowGuid"], "");
}
}
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);
BindZhuanYe();
//HTBA.ClientGuid = Request["RowGuid"] + "HTBA";
//HTBA.NodeCode = DWGuid_2021.Text;
//HTBA.MisRowGuid = Request["RowGuid"];
XM_HTBA.ClientGuid = Request["RowGuid"] + "XM_HTBA";
XM_HTBA.NodeCode = DWGuid_2021.Text;
XM_HTBA.MisRowGuid = Request["RowGuid"];
XM_HTBA.Status = oRow["Status"].ToString();
SJHT.ClientGuid = Request["RowGuid"] + "XM_SJHT";
SJHT.NodeCode = DWGuid_2021.Text;
SJHT.MisRowGuid = Request["RowGuid"];
QY_CXZM.ClientGuid = Request["RowGuid"] + "QY_CXZM";
QY_CXZM.NodeCode = DWGuid_2021.Text;
QY_CXZM.MisRowGuid = Request["RowGuid"];
lblSHOpinion.Text = RG_DW.GetSHOpinion(Request["RowGuid"], "");
//WriteAjaxMessage("window.moveTo(-4, -4);");
//WriteAjaxMessage("window.resizeTo(screen.availWidth + 8, screen.availHeight + 8);");
string QYZCD2 = Epoint.MisBizLogic2.DB.ExecuteToString("SELECT RegistAddressCode FROM RG_OUInfo WHERE RowGuid='" + DWGuid_2021.Text + "'");
if (QYZCD2.Substring(0, 2) == "32")
{
lblTips.Text = RG_DW.GetTip(oRow["Status"], "", "0", oRow["XMAdd"].ToString());
}
else
{
lblTips.Text = RG_DW.GetTip(oRow["Status"], "", "1", oRow["XMAdd"].ToString());
}
}
//如果是省内的，就不要显示
string QYZCD = Epoint.MisBizLogic2.DB.ExecuteToString("SELECT RegistAddressCode FROM RG_OUInfo WHERE RowGuid='" + DWGuid_2021.Text + "'");
if (QYZCD.Substring(0, 2) == "32")
{
XM_HTBA.SAdd = "SN";
YeWuFW_2021.Visible = false;
FuZaCD_2021.Visible = false;
WriteAjaxMessage("document.getElementById('trFW').style.display = 'none';");
WriteAjaxMessage("document.getElementById('trFZ').style.display = 'none';");
}
else
{
XM_HTBA.SAdd = "SW";
}
}
private void data1change()
{
string ePassNDstring = ConfigurationManager.AppSettings["ePassND"];
userPin = "";
string RandomData = Session["Message"].ToString();
string userSN = Request["SN_SERAL"];
string clientdigest = Request["Digest"];
string PassWord = Request["PassWord"];
string Key1 = "01234567890123456";
string Key2 = "01234567890123456";
string ServerDigest = "01234567890123456";
object oKey1 = (string)Key1;
object oKey2 = (string)Key2;
object oServerDigest = (string)ServerDigest;
string LoginID = "";
//SqlConnection ConnEpassND;
//ConnEpassND = new SqlConnection(ePassNDstring);
//string sql = "SELECT * From [Projects_Users] where ePassND_KeySerialNumber ='" + userSN + "'";
//SqlCommand myCMD = new SqlCommand(sql, ConnEpassND);
//ConnEpassND.Open();
//SqlDataReader myReader = myCMD.ExecuteReader();
//if (myReader.Read())
//{
// userPin = myReader["ePassND_KeyPinNumber"].ToString();//从Projects_Users表中读取ePassND_KeyPinNumber字段信息(ePassND_KeyPinNumber是加密锁的pin码)
// userSourceID = myReader["Source_Project_UserID"].ToString();//从Projects_Users表中读取Source_Project_UserID字段信息(Source_Project_UserID是OA系统的原来的用户登陆名)
//}
//myReader.Close();
//ConnEpassND.Close();
//string loginID = userSourceID.Trim();
//string userpwd = userPin.Trim();
//判断当前用户是否能正常登录
string RegisterUserRow_ID = "";
Session["USBKeyLogin"] = "******";
string strSql = "select * from RG_User where PINCode='" + userSN + "' and PassWord='******' and IsValid='0' and DelStatus='1' and DelFlag='1' ";
//判断是否是未激活的账号
DataView dv = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql);
Boolean needActivate = dv.Count > 0;
if (needActivate)
{
//string url = "RG_UserActivation.aspx?UserGuid=" + dv[0]["RowGuid"].ToString();
AlertAjaxMessage("本帐号未激活，请联系管理员");
return;
}
strSql = "select * from RG_User where PINCode='" + userSN + "' and PassWord='******' ";
DataView dv2 = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql);
if (dv2.Count > 0)
{
//判断当前用户是否已经配置key，如果已配置，则检查当前系统是否启用了key，如果启用了key，再检查是否配置了不运行普通登录
LoginID = dv2[0]["loginID"].ToString();
RegisterUserRow_ID = rgUser.RegisterUserLogin(LoginID, dv2[0]["Password"].ToString());
}
if (RegisterUserRow_ID == "")
{
#region 登录失败情况下，给用户的提示
if (Convert.ToInt32(ViewState["LoginErrorTimes"]) != 0)
{
if (Convert.ToInt32(ViewState["ErrorTimes"]) >= Convert.ToInt32(ViewState["LoginErrorTimes"]))
{
WriteAjaxMessage("alert('您的密码已经输错超过了3次，系统将自动关闭！');window.close();");
string RowGuid = Guid.NewGuid().ToString();
Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_Login", RowGuid);
oRow["RGGuid"] = LoginID;
oRow["LoginTime"] = System.DateTime.Now.ToString();
oRow["IsLoginSuccess"] = 0;
oRow["Message"] = "" + LoginID + "的PIN密码输错了3次，系统自动关闭！";
oRow.Insert();
return;
}
else
{
AlertAjaxMessage("系统不能完成您的登录请求，请检查您的密码是否正确！");
WriteAjaxMessage("window.location='epasslogin.aspx';");
}
ViewState["ErrorTimes"] = Convert.ToInt32(ViewState["ErrorTimes"]) + 1;
return;
}
else
{
AlertAjaxMessage("系统不能完成您的登录请求，请检查您的密码是否正确！");
WriteAjaxMessage("window.location='epasslogin.aspx';");
return;
}
#endregion
}
else
{
RG_Login(LoginID);
}
}
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 + "';");
}
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();");
}
/// <summary>
/// 保存材料内容
/// </summary>
public void Save()
{
Epoint.MisBizLogic2.Data.MisGuidRow oRow;
string RowGuid;
string[] arrFileIndex = txtFileIndex.Text.Split('|');
//判断是否是空
StringBuilder sb = new StringBuilder();
foreach (string fileIndex in arrFileIndex)
{
if (fileIndex != "")
{
//上传附件
sb.Append(CheckFilesIsEmpty("attachfile" + fileIndex));
}
}
if (sb.Length > 0)
{
//Parent.Page.ClientScript.RegisterStartupScript(this.GetType(), "2", string.Format("<script>alert('{0}');</script>", sb.ToString()));
Response.Write("<Script language='javascript'>");
Response.Write(string.Format("alert('{0}');", sb.ToString()));
Response.Write("</script>");
//return;
}
if (Convert.ToString(ViewState["IsSaved"]) != "1")
{
RowGuid = Guid.NewGuid().ToString();
//新材料的添加
oRow = new Epoint.MisBizLogic2.Data.MisGuidRow(Com.GetTableNameByID(TableID));
oRow["RowGuid"] = RowGuid;
oRow["ConfigRowGuid"] = Convert.ToString(ViewState["ConfigRowGuid"]);
oRow["MisTableID"] = Convert.ToInt32(ViewState["MisTableID"]);
oRow["MisRowGuid"] = Convert.ToString(ViewState["MisRowGuid"]);
oRow["ProjectGuid"] = Convert.ToString(ViewState["ProjectGuid"]);
oRow["Comment"] = Convert.ToString(ViewState["Comment"]);
oRow["s_YeWuMC"] = Convert.ToString(ViewState["YeWuMC"]);
oRow["s_ShiFouTiJiao"] = "1";
oRow["d_TiJiaoSJ"] = DateTime.Now.AddSeconds(-1).ToString();
oRow.Insert();
}
else
{
RowGuid = ViewState["RowGuid"].ToString();
}
foreach (string fileIndex in arrFileIndex)
{
if (fileIndex != "")
{
//上传附件
uploadFiles("attachfile" + fileIndex, RowGuid);
}
}
this.RefreshGrid();
}
protected void Page_Load(object sender, System.EventArgs e)
{
if (!Page.IsPostBack)
{
string RowGuid = Request["RowGuid"];
string DWGuid = Request["DWGuid"];
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();
tvZCD.Text = ZhuCeDi_2017.Text;
tvZCD.Value = ZhuCeDiCode_2017.Text;
tvYYD1.Text = YunYingDi1_2017.Text;
tvYYD1.Value = YunYingDi1Code_2017.Text;
tvYYD2.Text = YunYingDi2_2017.Text;
tvYYD2.Value = YunYingDi2Code_2017.Text;
tvYYD3.Text = YunYingDi3_2017.Text;
tvYYD3.Value = YunYingDi3Code_2017.Text;
#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.s
CL_Logo.MisRowGuid = DWGuid;
CL_Logo.MisTableID = TableID;
CL_Logo.ProjectGuid = "";
CL_Logo.Comment = DWGuid;
CL_Logo.d_TiJiaoSJ = DateTime.Now.ToString();
CL_GSJS.MisRowGuid = DWGuid;
CL_GSJS.MisTableID = TableID;
CL_GSJS.ProjectGuid = "";
CL_GSJS.Comment = DWGuid;
CL_GSJS.d_TiJiaoSJ = DateTime.Now.ToString();
CL_ZS.MisRowGuid = DWGuid;
CL_ZS.MisTableID = TableID;
CL_ZS.ProjectGuid = "";
CL_ZS.Comment = DWGuid;
CL_ZS.d_TiJiaoSJ = DateTime.Now.ToString();
#endregion
InitZCDTree();
InitYYD1Tree();
InitYYD2Tree();
InitYYD3Tree();
RefreshGrid2();
}
}
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();
RegionTreeView.Text = RegistAddress_2017.Text;
RegionTreeView.Value = RegistAddressCode_2017.Text;
QY_GSZZ_Z.ClientGuid = Request["RowGuid"] + "QY_GSZZ_Z";
QY_GSZZ_Z.ClientTag = "工商营业执照(正本)";
QY_GSZZ_Z.NodeCode = Request["RowGuid"];
QY_GSZZ_Z.MisRowGuid = Request["RowGuid"];
QY_GSZZ_F.ClientGuid = Request["RowGuid"] + "QY_GSZZ_F";
QY_GSZZ_F.ClientTag = "工商营业执照(副本)";
QY_GSZZ_F.NodeCode = Request["RowGuid"];
QY_GSZZ_Z.MisRowGuid = Request["RowGuid"];
QY_ZZJGDMZ.ClientGuid = Request["RowGuid"] + "QY_ZZJGDMZ";
QY_ZZJGDMZ.ClientTag = "组织机构代码证";
QY_ZZJGDMZ.NodeCode = Request["RowGuid"];
QY_ZZJGDMZ.MisRowGuid = Request["RowGuid"];
QY_FRSFZ.ClientGuid = Request["RowGuid"] + "QY_FRSFZ";
QY_FRSFZ.ClientTag = "法定代表人身份证";
QY_FRSFZ.NodeCode = Request["RowGuid"];
QY_FRSFZ.MisRowGuid = Request["RowGuid"];
QY_FRQM.ClientGuid = Request["RowGuid"] + "QY_FRQM";
QY_FRQM.ClientTag = "法定代表人签名";
QY_FRQM.NodeCode = Request["RowGuid"];
QY_FRQM.MisRowGuid = Request["RowGuid"];
QY_SBZM.ClientGuid = Request["RowGuid"] + "QY_SBZM";
QY_SBZM.ClientTag = "社会保险证明材料(近6个月)";
QY_SBZM.NodeCode = Request["RowGuid"];
QY_SBZM.MisRowGuid = Request["RowGuid"];
QY_QYQT.ClientGuid = Request["RowGuid"] + "QY_QYQT";
QY_QYQT.ClientTag = "企业其它文件";
QY_QYQT.NodeCode = Request["RowGuid"];
QY_QYQT.MisRowGuid = Request["RowGuid"];
//if (Status_2017.Text == "90")
//{
// btSubmit.Visible = false;
//}
RefreshZZGrid();
RefreshRYGrid();
}
InitCityTree();
}
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();
RY_SFZ.ClientGuid = Request["RowGuid"] + "RY_SFZ";
RY_SFZ.NodeCode = DWGuid_2019.Text;
RY_SFZ.MisRowGuid = Request["RowGuid"];
RY_BYZ.ClientGuid = Request["RowGuid"] + "RY_BYZ";
RY_BYZ.NodeCode = DWGuid_2019.Text;
RY_BYZ.MisRowGuid = Request["RowGuid"];
RY_ZCZJ.ClientGuid = Request["RowGuid"] + "RY_ZCZJ";
RY_ZCZJ.NodeCode = DWGuid_2019.Text;
RY_ZCZJ.MisRowGuid = Request["RowGuid"];
RY_ZhiCheng.ClientGuid = Request["RowGuid"] + "RY_ZhiCheng";
RY_ZhiCheng.NodeCode = DWGuid_2019.Text;
RY_ZhiCheng.MisRowGuid = Request["RowGuid"];
RY_LDHT.ClientGuid = Request["RowGuid"] + "RY_LDHT";
RY_LDHT.NodeCode = DWGuid_2019.Text;
RY_LDHT.MisRowGuid = Request["RowGuid"];
RY_GRQT.ClientGuid = Request["RowGuid"] + "RY_GRQT";
RY_GRQT.NodeCode = DWGuid_2019.Text;
RY_GRQT.MisRowGuid = Request["RowGuid"];
RY_GRQM.ClientGuid = Request["RowGuid"] + "RY_GRQM";
RY_GRQM.NodeCode = DWGuid_2019.Text;
RY_GRQM.MisRowGuid = Request["RowGuid"];
RegionTreeView.Text = ZhuanYeCS_2019.Text;
RegionTreeView.Value = ZhuanYeCSCode_2019.Text;
string strSql = "SELECT EnterpriseName FROM RG_OUInfo WHERE RowGuid='" + DWGuid_2019.Text + "'";
lblDWName.Text = Epoint.MisBizLogic2.DB.ExecuteToString(strSql);
if (oRow["Status"].ToString() == "90")//通过
{
//btnEdit.Visible = false;
}
else if (oRow["Status"].ToString() == "80" || oRow["Status"].ToString() == "85")//不通过、变更中
{
//btnEdit.Visible = false;
}
else if (oRow["Status"].ToString() == "70")//待审核
{
btnEdit.Visible = false;
btnSubmit.Visible = false;
RY_SFZ.ReadOnly = true;
RY_BYZ.ReadOnly = true;
RY_ZCZJ.ReadOnly = true;
RY_ZhiCheng.ReadOnly = true;
RY_LDHT.ReadOnly = true;
RY_GRQT.ReadOnly = true;
RY_GRQM.ReadOnly = true;
}
lblSHOpinion.Text = RG_DW.GetSHOpinion(Request["RowGuid"], "");
}
InitTree();
}
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 LoginSys_Click(object sender, ImageClickEventArgs e)
{
// 判断验证码是否正确
if (Request.Cookies["checkCode"].Value.ToLower() != userauthcode.Value.Trim().ToLower())
{
AlertAjaxMessage("您输入的验证码不正确!!");
//CreatImg();
WriteAjaxMessage("window.location=window.location;");
return;
}
//}
//string Hurl = Request.Url.Host;
//if(Hurl
//判断当前用户是否能正常登录
string RegisterUserRow_ID = "";
Session["USBKeyLogin"] = "******";
string strSql = "select * from RG_User where LoginID='" + account.Value + "' and IsValid='0' and DelStatus='1' and DelFlag='1' ";
//if (ViewState["LoginNeedVlidate"].ToString() == "1")
//{
// strSql += " and VerifyCode is not null";
//}
//判断是否是未激活的账号
DataView dv = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql);
Boolean needActivate = dv.Count > 0;
if (needActivate)
{
//string url = "RG_UserActivation.aspx?UserGuid=" + dv[0]["RowGuid"].ToString();
AlertAjaxMessage("本帐号未激活，请联系管理员");
return;
}
//判断有没有加密锁，如果有的话，就提示用加密锁登录
strSql = "select PINCode from RG_User where LoginID='" + account.Value + "' ";
string PINCode = Epoint.MisBizLogic2.DB.ExecuteToString(strSql);
if (PINCode.Length > 0)
{
//WriteAjaxMessage("alert('您已经有加密锁，请通过加密锁登录！');");
//WriteAjaxMessage("window.location='epasslogin.aspx';");
//return;
}
//判断当前用户是否已经配置key，如果已配置，则检查当前系统是否启用了key，如果启用了key，再检查是否配置了不运行普通登录
RegisterUserRow_ID = rgUser.RegisterUserLogin(account.Value, common.authPassword(password.Value));
if (RegisterUserRow_ID == "")
{
#region 登录失败情况下，给用户的提示
if (Convert.ToInt32(ViewState["LoginErrorTimes"]) != 0)
{
if (Convert.ToInt32(ViewState["ErrorTimes"]) >= Convert.ToInt32(ViewState["LoginErrorTimes"]))
{
WriteAjaxMessage("alert('您的密码或者验证码已经输错超过了3次，系统将自动关闭！');window.close();");
string RowGuid = Guid.NewGuid().ToString();
Epoint.MisBizLogic2.Data.MisGuidRow oRow = new Epoint.MisBizLogic2.Data.MisGuidRow("RG_Login", RowGuid);
oRow["RGGuid"] = account.Value;
oRow["LoginTime"] = System.DateTime.Now.ToString();
oRow["IsLoginSuccess"] = 0;
oRow["Message"] = "" + account.Value + "的密码或验证码输错了3次，系统自动关闭！";
oRow.Insert();
return;
}
else
{
AlertAjaxMessage("系统不能完成您的登录请求，请检查您的用户名和密码是否匹配！");
WriteAjaxMessage("window.location=window.location;");
}
ViewState["ErrorTimes"] = Convert.ToInt32(ViewState["ErrorTimes"]) + 1;
//if (ViewState["LoginNeedVlidate"].ToString() == "1")
// CreatImg();
return;
}
else
{
AlertAjaxMessage("系统不能完成您的登录请求，请检查您的用户名和密码是否匹配！");
WriteAjaxMessage("window.location=window.location;");
//if (ViewState["LoginNeedVlidate"].ToString() == "1")
// CreatImg();
return;
}
#endregion
}
else
{
//RG_Login(RegisterUserRow_ID, txtUserName.Value);
RG_Login(account.Value);
}
}
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);
GSZZ_Z.ClientGuid = Request["RowGuid"] + "QY_GSZZ_Z";
GSZZ_Z.ClientTag = "工商营业执照(正本)";
GSZZ_Z.NodeCode = Request["RowGuid"];
GSZZ_Z.MisRowGuid = Request["RowGuid"];
GSZZ_F.ClientGuid = Request["RowGuid"] + "QY_GSZZ_F";
GSZZ_F.ClientTag = "工商营业执照(副本)";
GSZZ_F.NodeCode = Request["RowGuid"];
GSZZ_Z.MisRowGuid = Request["RowGuid"];
ZZJGDMZ.ClientGuid = Request["RowGuid"] + "QY_ZZJGDMZ";
ZZJGDMZ.ClientTag = "组织机构代码证";
ZZJGDMZ.NodeCode = Request["RowGuid"];
ZZJGDMZ.MisRowGuid = Request["RowGuid"];
FRSFZ.ClientGuid = Request["RowGuid"] + "QY_FRSFZ";
FRSFZ.ClientTag = "法定代表人身份证";
FRSFZ.NodeCode = Request["RowGuid"];
FRSFZ.MisRowGuid = Request["RowGuid"];
FRQM.ClientGuid = Request["RowGuid"] + "QY_FRQM";
FRQM.ClientTag = "法定代表人签名";
FRQM.NodeCode = Request["RowGuid"];
FRQM.MisRowGuid = Request["RowGuid"];
SBZM.ClientGuid = Request["RowGuid"] + "QY_SBZM";
SBZM.ClientTag = "社会保险证明材料(近6个月)";
SBZM.NodeCode = Request["RowGuid"];
SBZM.MisRowGuid = Request["RowGuid"];
QT.ClientGuid = Request["RowGuid"] + "QY_QYQT";
QT.ClientTag = "企业其它文件";
QT.NodeCode = Request["RowGuid"];
QT.MisRowGuid = Request["RowGuid"];
if (Status_2017.Text != "待审核")
{
btnNoPass.Visible = false;
btnPass.Visible = false;
}
//如果只是查看，那么也不显示按钮
if (String.IsNullOrEmpty(Request["MessageItemGuid"]))
{
btnNoPass.Visible = false;
btnPass.Visible = false;
}
}
}
