private void btn_cancelmatch_Click(object sender, EventArgs e)
{
if (this.dgvEPIDCompare.CurrentRow != null)
{
if (MessageBox.Show("确认取消匹配关系？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
LogedInUser curUser = ClientSession.GetInstance().CurrentUser;
Gpo_Hosptail_MapModel enterprise = new Gpo_Hosptail_MapModel();
enterprise.MapOrgId = base.CurrentUserRegOrgId;
enterprise.CorpId = "";
enterprise.CorpName = this.dgvEPIDCompare.CurrentCell == null ? "" : this.dgvEPIDCompare.CurrentRow.Cells["FULL_NAME"].Value.ToString();
enterprise.CorpAbbr = this.dgvEPIDCompare.CurrentCell == null ? "" : this.dgvEPIDCompare.CurrentRow.Cells["EASY_NAME"].Value.ToString();
enterprise.ModifyUserId = base.CurrentUserId;
enterprise.Process = "1";
enterprise.IsMap = "0";
enterprise.CorpCode = this.dgvEPIDCompare.CurrentCell == null ? "" : this.dgvEPIDCompare.CurrentRow.Cells["CODE"].Value.ToString();
HosptailIDCompareBLL.GetInstance("ClientDB").cancelmatch(enterprise);
this.bindingDsEnterPriseMapList();
ItemFilter();
foreach (DataGridViewRow row in this.dgvEPIDCompare.Rows)
{
if (row.Cells["CODE"].Value.ToString() == enterprise.CorpCode)
{
this.dgvEPIDCompare.CurrentCell = this.dgvEPIDCompare["CODE", row.Index];
}
}
EmedMessageBox.ShowInformation("匹配关系已取消！");
}
}
}
public void UpdateHisErpCorpMap(Gpo_Hosptail_MapModel input)
{
int result;
using (DbTransaction transaction = base.DbFacade.BeginTransaction(base.DbFacade.OpenConnection()))
{
try
{
result = base.DbFacade.SQLExecuteNonQuery(UpdateHisErpCorpMapSQL(input));
if (result > 0)
{
base.DbFacade.CommitTransaction(transaction);
}
else
{
base.DbFacade.RollbackTransaction(transaction);
}
}
catch (Exception e)
{
base.DbFacade.RollbackTransaction(transaction);
throw e;
}
}
}
/// <summary>
/// 重载,返回记录ID
/// </summary>
/// <param name="input"></param>
/// <param name="sRecord_ID"></param>
/// <returns></returns>
public string InsertHisErpCorpMapSQL(Gpo_Hosptail_MapModel input, out string sRecord_ID)
{
StringBuilder sb = new StringBuilder();
string GlobalID = IdUtil.GetGlobalId();
sRecord_ID = GlobalID;
sb.Append("insert into gpo_corp_map( \r\n\t\t\t\t\t");
sb.Append("ID,MAP_ORGTYPE,MAP_ORGID,ORG_ID,CODE,FULL_NAME,EASY_NAME,\r\n");
sb.Append("MODIFY_USERID,MODIFY_DATE,SYNC_STATE,Process_Flag,ISMAP) values \r\n");
sb.Append("('").Append(GlobalID).Append("',");
sb.Append(" '2',");
sb.Append("'").Append(input.MapOrgId).Append("',");
sb.Append("'").Append(input.CorpId).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("'0',");
sb.Append("'").Append(input.Process).Append("',");
sb.Append("'").Append(input.IsMap).Append("')");
return(sb.ToString());
}
/// <summary>
/// 匹配
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnMap_Click(object sender, EventArgs e)
{
if (dgvERPCroplist.CurrentRow != null && dgvEmedCorpList.CurrentRow != null && dgvERPCroplist.CurrentRow.Cells["IsMap"].Value.ToString() == "未匹配")
{
Gpo_Hosptail_MapModel model = new Gpo_Hosptail_MapModel();
model.CorpId = dgvEmedCorpList.CurrentRow.Cells["buyer_orgid"].Value.ToString().Trim();
model.MapOrgId = ClientSession.GetInstance().CurrentUser.UserOrg.Reg_org_id;
model.CorpCode = dgvERPCroplist.CurrentRow.Cells["buyer_code"].Value.ToString().Trim();
model.CorpName = dgvERPCroplist.CurrentRow.Cells["buyer_name"].Value.ToString().Trim();
model.CorpAbbr = dgvERPCroplist.CurrentRow.Cells["buyer_easy"].Value.ToString().Trim();
model.IsMap = "1";
if (!hashMap.ContainsKey(model.CorpCode))
{
hashMap.Add(model.CorpCode, model);
dtNotMap.Select("buyer_code ='" + dgvERPCroplist.CurrentRow.Cells["buyer_code"].Value + "'")[0]["IsMap"] = "已匹配";
bSave = false;
}
}
}
public string UpdateHisErpCorpMapSQL(Gpo_Hosptail_MapModel input)
{
StringBuilder sb = new StringBuilder();
sb.Append("update GPO_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(",SYNC_STATE='0'");
sb.AppendFormat(",Process_Flag='{0}'", input.Process);
sb.AppendFormat(",ISMAP='{0}'", input.IsMap);
sb.AppendFormat(" where CODE='{0}'", input.CorpCode);
sb.AppendFormat(" and map_orgid='{0}'", input.MapOrgId);
return(sb.ToString());
}
public void UpdateHisErpCorpMap(Gpo_Hosptail_MapModel input)
{
dao.UpdateHisErpCorpMap(input);
}
public void cancelmatch(Gpo_Hosptail_MapModel input)
{
dao.cancelmatch(input);
}
/// <summary>
/// 增加对照医院
/// </summary>
/// <returns></returns>
public void InsertHisErpCorpMap(Gpo_Hosptail_MapModel input)
{
dao.InsertHisErpCorpMap(input);
}
//add bu cjg
/// <summary>
/// 获取增加买方匹配sql
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public string InsertHisErpCorpMapSQL(Gpo_Hosptail_MapModel input, out string sRecord_ID)
{
return(dao.InsertHisErpCorpMapSQL(input, out sRecord_ID));
}
