110,545
社区成员
发帖
与我相关
我的任务
分享
public class SqlHelper
{
public string GetSqlConnection()
{
return "";
}
public void Operate(params SqlParameterModel[] models)
{
using (SqlConnection con = new SqlConnection(this.GetSqlConnection()))
{
foreach (var item in models)
{
using (SqlCommand cmd = new SqlCommand(item.StrSql, con))
{
cmd.Parameters.AddRange(item.Prm);
cmd.ExecuteNonQuery();
}
}
}
}
}
public class SqlParameterModel
{
public SqlParameterModel()
{
StrSql = string.Empty;
}
public string StrSql { get; set; }
public SqlParameter[] Prm { get; set; }
}
public void operate(List<string> sqls, List<SqlParameter[]> param)