/// <summary> /// 新增医院编码对照匹配信息SQL /// </summary> /// <param name="inRow"></param> /// <param name="inUserId"></param> /// <param name="MapOrgId"></param> /// <returns></returns> public string InsertHisEnterpriseMapSQL(DataGridViewRow inRow, string inUserId, string MapOrgId) { StringBuilder sb = new StringBuilder(); sb.Append("insert into gpo_corp_map( "); sb.Append("ID,MAP_ORGTYPE,Map_ORGID,DATA_ORG_ID,CODE,FULL_NAME,EASY_NAME,ADDRESS, POSTCODE,TELPHONE, LINKMAN,"); sb.Append("ISFACTORY,ISSENDER,ISSALER,"); sb.Append("Process_Flag,org_id,MODIFY_USERID,MODIFY_DATE,SYNC_STATE,ISMAP) values "); sb.Append("('").Append(IdUtil.GetGlobalId()).Append("',"); sb.Append("'2',"); sb.Append("'").Append(MapOrgId).Append("',"); sb.Append("'").Append(inRow.Cells["DATA_ORG_ID"].Value == null ? "" : inRow.Cells["DATA_ORG_ID"].Value.ToString()).Append("',"); sb.Append("'").Append(inRow.Cells["CODE"].Value == null ? "" : inRow.Cells["CODE"].Value.ToString()).Append("',"); sb.Append("'").Append(inRow.Cells["FULL_NAME"].Value == null ? "" : inRow.Cells["FULL_NAME"].Value.ToString()).Append("',"); sb.Append("'").Append(inRow.Cells["EASY_NAME"].Value == null ? "" : inRow.Cells["EASY_NAME"].Value.ToString()).Append("',"); sb.Append("'").Append(inRow.Cells["ADDRESS"].Value == null ? "" : inRow.Cells["ADDRESS"].Value.ToString()).Append("',"); sb.Append("'").Append(inRow.Cells["POSTCODE"].Value == null ? "" : inRow.Cells["POSTCODE"].Value.ToString()).Append("',"); sb.Append("'").Append(inRow.Cells["TELPHONE"].Value == null ? "" : inRow.Cells["TELPHONE"].Value.ToString()).Append("',"); sb.Append("'").Append(inRow.Cells["LINKMAN"].Value == null ? "" : inRow.Cells["LINKMAN"].Value.ToString()).Append("',"); sb.Append("'").Append(inRow.Cells["ISFACTORY"].Value == null ? "" : inRow.Cells["ISFACTORY"].Value.ToString()).Append("',"); sb.Append("'").Append(inRow.Cells["ISSENDER"].Value == null ? "" : inRow.Cells["ISSENDER"].Value.ToString()).Append("',"); sb.Append("'").Append(inRow.Cells["ISSALER"].Value == null ? "" : inRow.Cells["ISSALER"].Value.ToString()).Append("',"); sb.Append("0").Append(","); sb.Append("'").Append(inRow.Cells["ORG_ID"].Value == null ? "" : inRow.Cells["ORG_ID"].Value.ToString()).Append("',"); sb.Append("'").Append(inUserId).Append("',"); sb.Append("'").Append(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")).Append("',"); sb.Append("0").Append(","); sb.Append("'").Append(inRow.Cells["ORG_ID"].Value.ToString().Equals("") ? "0" : "1").Append("')"); return(sb.ToString()); }
/// <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()); }
public string InsertHisErpCorpMapSQL(DataRow inRow, string inUserId, string MapOrgId) { StringBuilder sb = new StringBuilder(); string GlobalID = IdUtil.GetGlobalId(); sb.Append("insert into gpo_corp_map( "); sb.Append("ID,MAP_ORGTYPE,MAP_ORGID,ORG_ID,CODE,FULL_NAME,EASY_NAME,"); sb.Append("MODIFY_USERID,MODIFY_DATE,SYNC_STATE,Process_Flag) values "); sb.Append("('").Append(GlobalID).Append("',"); sb.Append(" '2',"); sb.Append("'").Append(MapOrgId).Append("',"); sb.Append("'").Append(inRow["org_id"].ToString()).Append("',"); sb.Append("'").Append(inRow["sender_code"].ToString()).Append("',"); sb.Append("'").Append(inRow["sender_name"].ToString()).Append("',"); sb.Append("'").Append(inRow["sender_name"].ToString()).Append("',"); sb.Append("'").Append(inUserId).Append("',"); sb.Append("'").Append(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")).Append("',"); sb.Append("'0',"); sb.Append("'").Append(inRow["process_flag"].ToString().Equals("true") ? "1" : "0").Append("')"); return(sb.ToString()); }