public static string Query(string sql, string dataSource)
{
IOWxg.Log(string.Format("sql:{0}", sql));
IOWxg.Log(string.Format("dataSource:{0}", dataSource));
DataSet ds = new DataSet();
try
{
using (var adapter = new SqlDataAdapter(sql, dataSource))
{
adapter.Fill(ds);
}
}
catch (Exception ex)
{
IOWxg.Log(ex.StackTrace);
return("error:" + ex.Message);
}
if (ds.Tables.Count == 0)
{
return(string.Empty);
}
return(UtilWxg.DataTabletoString(ds.Tables[0]));
}
public static string Batch(string sql, string dataSource)
{
IOWxg.Log(string.Format("sql:{0}", sql));
IOWxg.Log(string.Format("dataSource:{0}", dataSource));
List <string> lstValue = new List <string>();
try
{
using (var con = new SqlConnection(dataSource))
{
con.Open();
DbTransaction transaction = con.BeginTransaction();
string[] sqls = sql.Split(";".ToCharArray());
foreach (var sql1 in sqls)
{
if (sql.StartsWith("SELECT", StringComparison.OrdinalIgnoreCase))
{
DataTable dt = new DataTable();
using (var adapter = new SqlDataAdapter(sql1, con))
{
adapter.Fill(dt);
}
lstValue.Add(UtilWxg.DataTabletoString(dt));
}
else
{
using (var cmd = new SqlCommand(sql1, con))
{
int count = cmd.ExecuteNonQuery();
lstValue.Add(count.ToString());
}
}
}
transaction.Commit();
}
}
catch (Exception ex)
{
IOWxg.Log(ex.Message);
return("error:" + ex.Message);
}
return(string.Join(";", lstValue));
}
