public void UpdateHisErpCorpMap(Gpo_EnterPrice_MapModel input)
{
int result;
using (DbTransaction transaction = base.DbFacade.BeginTransaction(base.DbFacade.OpenConnection()))
{
try
{
result = base.DbFacade.SQLExecuteNonQuery(UpdateHisErpCorpMapSQL(input), transaction);
if (result > 0)
{
base.DbFacade.CommitTransaction(transaction);
}
else
{
base.DbFacade.RollbackTransaction(transaction);
}
}
catch (Exception e)
{
base.DbFacade.RollbackTransaction(transaction);
throw e;
}
}
}
/// <summary>
/// 增加对照企业SQL
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public string InsertHisErpCorpMapSQL(Gpo_EnterPrice_MapModel input)
{
StringBuilder sb = new StringBuilder();
//string GlobalID = IdUtil.GetGlobalId();
long GlobalID = this.GetClientId(input.User.HighId);
sb.Append("insert into hc_corp_map( \r\n\t\t\t\t\t");
sb.Append("ID,MAP_ORGTYPE,MAP_ORGID,ORG_ID,HIS_ORG_ID,FULL_NAME,EASY_NAME,\r\n");
sb.Append("MODIFY_USERID,MODIFY_DATE,ISSENDER,SYNC_STATE,Process_Flag,ISMAP) values \r\n");
sb.Append("('").Append(GlobalID).Append("',");
sb.Append(" '1',");
sb.Append("'").Append(input.MapOrgId).Append("',");
sb.Append("'").Append(input.CorpId).Append("',");
//sb.Append("'").Append(input.Data_org_id).Append("',");
sb.Append("'").Append(input.CorpCode).Append("',");
sb.Append("'").Append(input.CorpName).Append("',");
sb.Append("'").Append(input.CorpAbbr).Append("',");
sb.Append("'").Append(input.ModifyUserId).Append("',");
sb.Append("'").Append(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")).Append("',");
sb.Append("'1',");
sb.Append("'0',");
sb.Append("'").Append(input.Process).Append("',");
sb.Append("'").Append(input.IsMap).Append("')");
return(sb.ToString());
}
private void btn_cancelmatch_Click(object sender, EventArgs e)
{
DataRow dr = gridView3.GetDataRow(gridView3.FocusedRowHandle);
if (dr != null)
{
if (XtraMessageBox.Show("确认取消匹配关系？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
LogedInUser curUser = ClientSession.GetInstance().CurrentUser;
Gpo_EnterPrice_MapModel enterprise = new Gpo_EnterPrice_MapModel();
enterprise.MapOrgId = curUser.UserOrg.Id;
enterprise.CorpId = "0";
enterprise.CorpName = dr["FULL_NAME"].ToString();
enterprise.CorpAbbr = dr["EASY_NAME"].ToString();
enterprise.ModifyUserId = base.CurrentUserId;
enterprise.Process = "1";
enterprise.IsMap = "0";
enterprise.CorpCode = dr["HIS_ORG_ID"].ToString();
EnterpriseIDCompareBLL.GetInstance().cancelMatch(enterprise);
this.bindingDsEnterPriseMapList();
ItemFilter();
for (int i = 0; i < this.gridView3.RowCount; i++)
{
DataRow drow = gridView3.GetDataRow(i);
if (drow["HIS_ORG_ID"].ToString() == enterprise.CorpCode)
{
this.gridView3.FocusedRowHandle = i;
}
}
XtraMessageBox.Show("匹配关系已取消！");
}
}
}
public string UpdateHisErpCorpMapSQL(Gpo_EnterPrice_MapModel input)
{
StringBuilder sb = new StringBuilder();
sb.Append("update hc_corp_map");
//start modify by gaoyuan 2007.3.12
sb.AppendFormat(" set ORG_ID='{0}'", input.CorpId);
//sb.AppendFormat(" set BUYER_ORGID='{0}'", input.MapOrgId);
//sb.AppendFormat(",ORG_ID='{0}'", input.CorpId);
//end modify by gaoyuan 2007.3.12
sb.AppendFormat(",FULL_NAME='{0}'", input.CorpName);
sb.AppendFormat(",EASY_NAME='{0}'", input.CorpAbbr);
sb.AppendFormat(",MODIFY_USERID='{0}'", input.ModifyUserId);
sb.AppendFormat(",MODIFY_DATE='{0}'", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
sb.Append(",ISSENDER='1'");
sb.Append(",SYNC_STATE='0'");
sb.AppendFormat(",Process_Flag='{0}'", input.Process);
sb.AppendFormat(",ISMAP='{0}'", input.IsMap);
sb.AppendFormat(" where HIS_ORG_ID='{0}'", input.CorpCode);
sb.AppendFormat(" and map_orgid='{0}'", input.MapOrgId);
return(sb.ToString());
}
public void UpdateHisErpCorpMap(Gpo_EnterPrice_MapModel input)
{
dao.UpdateHisErpCorpMap(input);
}
public void cancelMatch(Gpo_EnterPrice_MapModel input)
{
dao.cancelMatch(input);
}
/// <summary>
/// 增加对照企业
/// </summary>
/// <returns></returns>
public void InsertHisErpCorpMap(Gpo_EnterPrice_MapModel input)
{
dao.InsertHisErpCorpMap(input);
}
