解决 : c# 执行拼接sql

c# 执行拼接sql

• 通过 string 进行 字符串拼接 组成两个sql 语句
• 添加到list 中
• 执行sql

  public bool DAddTransportationRoute(string fSqlConnectString, MT_RouteTransportation model)
        {
            try
            {
                ArrayList list = new ArrayList();
                model.FGUID = Guid.NewGuid();
                //1.添加运输路线信息
                string strBaseSQL = string.Format(@"if not exists(select 1 from  T_BeltAndRoadRoute where FRouteName ='{9}') insert into T_BeltAndRoadRoute(FGUID,FRouteName,FStartFenceGUID, FEndFenceGUID, FPath,FWholeDistance,FRunningTime, FPortFenceGUID, FDescription  ) 
                    values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')   ", model.FGUID, model.FRouteName, model.FStartFenceGUID, model.FEndFenceGUID, model.FPath, model.FWholeDistance, model.FRunningTime, model.FPortFenceGUID, model.FDescription, model.FRouteName);
                list.Add(strBaseSQL);
                //2.添加途经站点节点信息
                StringBuilder sbPassSql = new StringBuilder();
                sbPassSql.Append(" INSERT INTO T_BeltAndRoadRoutePassFence (FGUID, FRouteGUID, FFenceGUID, FIndex) VALUES");
                string[] fences = model.FPassFence.ToUpper().Split(',');
                int index = 0;
                foreach (string item in fences)
                {
                    index++;
                    Guid fenceGUID = new Guid(item);
                    sbPassSql.Append(string.Format(@"('{0}','{1}','{2}','{3}'),", Guid.NewGuid(), model.FGUID, fenceGUID, index));
                }
                string strPassSQL = sbPassSql.ToString().TrimEnd(',');
                list.Add(strPassSQL);
                return new DBHelper().ExecuteSqlTran(fSqlConnectString, list);
            }
            catch (Exception ex)
            {
                Log.Instance.Error("DAddTransportationRoute:" + ex.Message);
                return false;
            }
        }