dynamic 接收POST数据并遍历得到update 语句

最新推荐文章于 2024-07-21 07:12:31 发布

wori

最新推荐文章于 2024-07-21 07:12:31 发布

阅读量266

点赞数

分类专栏：数据库设计

本文链接：https://blog.csdn.net/wori/article/details/103385126

版权

数据库设计专栏收录该内容

1 篇文章 0 订阅

订阅专栏

public object saveCompanyInfo(dynamic data)
{

Console.Write(data.ToString());
foreach (var key in data)
{
string tmpkey = key.Name;
string value = data[tmpkey];
Console.WriteLine(tmpkey);
Console.WriteLine(value);
}

StringBuilder sb = new StringBuilder();
sb.Append("UPDATE " + "Base_CompanyInfo" + " SET ");//设置update
int i = 0;
foreach (var key in data)
{
string tmpkey = key.Name;
string value = data[tmpkey];
sb.Append(tmpkey);
sb.Append("=");
sb.Append("'" + value+ "'");
sb.Append(",");
}
sb.Remove(sb.Length-1,1);
Console.WriteLine(sb);

DBHelper db = new DBHelper();
string sql = string.Format("UPDATE Base_CompanyInfo SET " +

"UserId = '{0}'" +
",name = '{1}'" +
",regTime ='{2}'" +
",regType = '{3}'" +
",foreignAdd ='{4}'" +
",regCapital = '{5}'" +
",industry = '{6}'" +
",scale = '{7}'" +
",region = '{8}'" +
",creditCode = '{9}'" +
",taxNumber ='{10}'" +
",taxRegName = '{11}'" +
",taxType ='{12}'" +
",address = '{13}'" +
",PostalCode = '{14}'" +
",Fname ='{15}'" +
",Fmtel ='{16}'" +
",FidNo = '{17}'" +
",Ftel = '{18}'" +
",Ffax = '{19}'" +
",Femail = '{20}'" +
",LxrName = '{21}'" +
",LxrMtel ='{22}'" +
",LxrTel ='{23}'" +
",LxrFax ='{24}'" +
",LxrEmail = '{25}'" +
",isShangShi = '{26}'" +
",ShangShiTime = '{27}'" +
",StockCode ='{28}'" +
",ShanShiType = '{29}'" +
",isHT ='{30}'" +
",htName = '{31}'" +
" where UserId='{32}' ",
data.UserId, data.name, data.regTime, data.regType, data.foreignAdd, data.regCapital, data.industry, data.scale,
data.region, data.creditCode, data.taxNumber, data.taxRegName, data.taxType, data.address, data.PostalCode,
data.Fname, data.Fmtel, data.FidNo, data.Ftel, data.Ffax, data.Femail, data.LxrName, data.LxrMtel, data.LxrTel, data.LxrFax,
data.LxrEmail, data.isShangShi, data.ShangShiTime, data.StockCode, data.ShanShiType, data.isHT, data.htName, data.UserId);