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