本文整理汇总了C#中Epoint.MisBizLogic2.Data.MisGuidRow.Update方法的典型用法代码示例。如果您正苦于以下问题:C# Epoint.MisBizLogic2.Data.MisGuidRow.Update方法的具体用法?C# Epoint.MisBizLogic2.Data.MisGuidRow.Update怎么用?C# Epoint.MisBizLogic2.Data.MisGuidRow.Update使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Epoint.MisBizLogic2.Data.MisGuidRow
的用法示例。
在下文中一共展示了Epoint.MisBizLogic2.Data.MisGuidRow.Update方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: btnPass_Click
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();");
}
示例2: btnNo_Click
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();");
}
示例3: btSubmit_Click
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();");
}
示例4: btnEdit_Click
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 + ",'���ݱ���ɹ�')");
}
示例5: btnPass_Click
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();");
}
示例6: btnEdit_Click
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 + ",'���ݱ���ɹ�')");
}
示例7: btnNoPass_Click
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();");
}
示例8: btnAdd_Click
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();");
}
}
示例9: btnSave_Click
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();");
}
示例10: btnAdd_Click
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();
}
}
示例11: btnSave_Click
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();
}
示例12: btnInitPwd_Click
//.........这里部分代码省略.........
// 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);
}
}
示例13: btnSave_Click
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();
}
示例14: UpdateStatus
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();
}
}
示例15: btSubmit_Click
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();");
}