public TransModel CreateAddSql(DataService.Model.OrderInfo model) { TransModel tm = new TransModel(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into OrderInfo("); strSql.Append("OrderID,OrderCode,UserID,Use_UserID,Buyer,ProName,Province,City,Area,Address,remarks1,remarks2,IntoDate,OrderDate,IsCheck,IsDel,AddTime)"); strSql.Append(" values ("); strSql.Append("@OrderID,@OrderCode,@UserID,@Use_UserID,@Buyer,@ProName,@Province,@City,@Area,@Address,@remarks1,@remarks2,@IntoDate,@OrderDate,@IsCheck,@IsDel,@AddTime)"); SqlParameter[] parameters = { new SqlParameter("@OrderID", SqlDbType.Int, 4), new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@Use_UserID", SqlDbType.Int, 4), new SqlParameter("@Buyer", SqlDbType.VarChar, 200), new SqlParameter("@ProName", SqlDbType.NVarChar, 50), new SqlParameter("@Province", SqlDbType.NVarChar, 50), new SqlParameter("@City", SqlDbType.NVarChar, 50), new SqlParameter("@Area", SqlDbType.NVarChar, 50), new SqlParameter("@Address", SqlDbType.VarChar, 200), new SqlParameter("@remarks1", SqlDbType.VarChar, 100), new SqlParameter("@remarks2", SqlDbType.VarChar, 2000), new SqlParameter("@IntoDate", SqlDbType.DateTime), new SqlParameter("@OrderDate", SqlDbType.DateTime), new SqlParameter("@IsCheck", SqlDbType.Bit, 1), new SqlParameter("@IsDel", SqlDbType.Bit, 1), new SqlParameter("@AddTime", SqlDbType.DateTime) }; parameters[0].Value = model.OrderID; parameters[1].Value = model.OrderCode; parameters[2].Value = model.UserID; parameters[3].Value = model.Use_UserID; parameters[4].Value = model.Buyer; parameters[5].Value = model.ProName; parameters[6].Value = model.Province; parameters[7].Value = model.City; parameters[8].Value = model.Area; parameters[9].Value = model.Address; parameters[10].Value = model.remarks1; parameters[11].Value = model.remarks2; parameters[12].Value = model.IntoDate; parameters[13].Value = model.OrderDate; parameters[14].Value = model.IsCheck; parameters[15].Value = model.IsDel; parameters[16].Value = model.AddTime; tm.Sql = strSql.ToString(); tm.parameters = parameters; return(tm); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(DataService.Model.OrderInfo model) { return(dal.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DataService.Model.OrderInfo model) { return(dal.Update(model)); }
public TransModel CreateAddSql(DataService.Model.OrderInfo model) { return dal.CreateAddSql(model); }