public TransModel CreateAddSql(DataService.Model.OrderDetail model) { TransModel tm = new TransModel(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into OrderDetail("); strSql.Append("OrderDetailID,OrderID,ProTypeID,Spec,PlanNum,Price,total,Remark,FinishNum,OrderStatus,UpTime)"); strSql.Append(" values ("); strSql.Append("@OrderDetailID,@OrderID,@ProTypeID,@Spec,@PlanNum,@Price,@total,@Remark,@FinishNum,@OrderStatus,@UpTime)"); SqlParameter[] parameters = { new SqlParameter("@OrderDetailID", SqlDbType.Int, 4), new SqlParameter("@OrderID", SqlDbType.Int, 4), new SqlParameter("@ProTypeID", SqlDbType.Int, 4), new SqlParameter("@Spec", SqlDbType.NVarChar, 100), new SqlParameter("@PlanNum", SqlDbType.Float, 8), new SqlParameter("@Price", SqlDbType.Float, 8), new SqlParameter("@total", SqlDbType.Float, 8), new SqlParameter("@Remark", SqlDbType.NVarChar, 500), new SqlParameter("@FinishNum", SqlDbType.Float, 8), new SqlParameter("@OrderStatus", SqlDbType.Int, 4), new SqlParameter("@UpTime", SqlDbType.DateTime) }; parameters[0].Value = model.OrderDetailID; parameters[1].Value = model.OrderID; parameters[2].Value = model.ProTypeID; parameters[3].Value = model.Spec; parameters[4].Value = model.PlanNum; parameters[5].Value = model.Price; parameters[6].Value = model.total; parameters[7].Value = model.Remark; parameters[8].Value = model.FinishNum; parameters[9].Value = model.OrderStatus; parameters[10].Value = model.UpTime; tm.Sql = strSql.ToString(); tm.parameters = parameters; return(tm); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DataService.Model.OrderDetail model) { return(dal.Update(model)); }
public TransModel CreateAddSql(DataService.Model.OrderDetail model) { return(dal.CreateAddSql(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(DataService.Model.OrderDetail model) { return(dal.Add(model)); }