日期:2014-05-17 浏览次数:20508 次
#region 客服更新订单资料
/// <summary>
/// 客服更新订单资料
/// </summary>
/// <param name="model">实体类</param>
/// <returns>返回BOOL值表示是否成功</returns>
public bool UpOrder(Model.Orders model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Orders set ");
strSql.Append("DeliveryTime=@DeliveryTime,");
strSql.Append("DeliveryPlace=@DeliveryPlace,");
strSql.Append("Status=@Status");
strSql.Append(" where PKid=@PKid ");
SqlParameter[] parameters = {
new SqlParameter("@DeliveryTime", SqlDbType.DateTime),
new SqlParameter("@DeliveryPlace", SqlDbType.NVarChar,50),
new SqlParameter("@Status", SqlDbType.Int,4),
new SqlParameter("@PKid", SqlDbType.Int,4)};
parameters[0].Value = model.DeliveryTime;
parameters[1].Value = model.DeliveryPlace;
parameters[3].Value = model.Status;
parameters[4].Value = model.PKid;
//其它代码
}
#endregion