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)); }