62,074
社区成员
发帖
与我相关
我的任务
分享
db.CreateCommand($"update [代理人] set 机构编码=@j,[团队名称]=@t,[团队状态]=@z,[团队长费率]=@f where Id=@id")
.SetParam("j", this.Command.GetValue<string>("机构编码"))
.SetParam("t", this.Command.GetValue<string>("团队名称"))
.SetParam("z", this.Command.GetValue<string>("团队状态"))
.SetParam("f", this.Command.GetValue<double>("团队长费率"))
.SetParam("id", this.Command.GetValue<string>("Id"))
.ExecuteNonQuery();
public static DbCommand SetParam(this DbCommand cmd, string paramName, object paramValue)
{
switch (paramValue)
{
case DateTime dt:
if (dt.Year < 1753)
paramValue = new DateTime(1753, 1, 1);
break;
case null:
paramValue = DBNull.Value;
break;
}
var p = cmd.CreateParameter();
p.ParameterName = paramName;
p.Value = paramValue;
cmd.Parameters.Add(p);
return cmd;
}
通过类似的定义,你可以让 c# 语言更加适合自己书写习惯。
SqlDataAdapter scd = new SqlDataAdapter(strsql, conn);
==>
SqlCommand scd = new SqlCommand(strsql, conn);