/// <summary>
/// 更新表cctable记录
/// </summary>
private bool Update_cctable(DTO_cctable paramArg)
{
string sql = @"UPDATE [cctable]
SET [bb] = @bb
,[cc] = @cc
,[dd] = @dd
,[ee] = @ee
WHERE [id] = @id";
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@Id", SqlDbType.Int),
new SqlParameter("@bb", SqlDbType.Bit),
new SqlParameter("@cc", SqlDbType.NVarChar),
new SqlParameter("@dd", SqlDbType.DateTime),
new SqlParameter("@ee", SqlDbType.Decimal)
};
parameters[0].Value = paramArg.Id;
parameters[1].Value = paramArg.bb;
parameters[2].Value = paramArg.cc;
parameters[3].Value = paramArg.dd;
parameters[4].Value = paramArg.ee;
var result = DBHelp.ExecuteSql(sql, parameters);
return(result > 0);
}
/// <summary>
/// 新增表cctable记录
/// </summary>
private bool Insert_cctable(DTO_cctable paramArg)
{
string sql = @"INSERT INTO [cctable] ([bb],[cc],[dd],[ee]) VALUES (@bb,@cc,@dd,@ee)";
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@bb", SqlDbType.Bit),
new SqlParameter("@cc", SqlDbType.NVarChar),
new SqlParameter("@dd", SqlDbType.DateTime),
new SqlParameter("@ee", SqlDbType.Decimal)
};
parameters[0].Value = paramArg.bb;
parameters[1].Value = paramArg.cc;
parameters[2].Value = paramArg.dd;
parameters[3].Value = paramArg.ee;
var result = DBHelp.ExecuteSql(sql, parameters);
return(result > 0);
}
