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