/// <summary> /// 更新一条数据 /// </summary> public bool Update(UserBuyOrder model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update UserBuyOrder set "); strSql.Append(" Email = @Email , "); strSql.Append(" ShenFenID = @ShenFenID , "); strSql.Append(" OrderNo = @OrderNo , "); strSql.Append(" UserID = @UserID , "); strSql.Append(" CreateDate = @CreateDate , "); strSql.Append(" EditDate = @EditDate , "); strSql.Append(" OrderStatus = @OrderStatus , "); strSql.Append(" UserName = @UserName , "); strSql.Append(" Mobile = @Mobile , "); strSql.Append(" Address = @Address "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int,4) , new SqlParameter("@Email", SqlDbType.NChar,30) , new SqlParameter("@ShenFenID", SqlDbType.NChar,30) , new SqlParameter("@OrderNo", SqlDbType.VarChar,255) , new SqlParameter("@UserID", SqlDbType.Int,4) , new SqlParameter("@CreateDate", SqlDbType.DateTime) , new SqlParameter("@EditDate", SqlDbType.DateTime) , new SqlParameter("@OrderStatus", SqlDbType.Int,4) , new SqlParameter("@UserName", SqlDbType.NChar,50) , new SqlParameter("@Mobile", SqlDbType.NChar,20) , new SqlParameter("@Address", SqlDbType.NChar,50) }; parameters[0].Value = model.ID; parameters[1].Value = model.Email; parameters[2].Value = model.ShenFenID; parameters[3].Value = model.OrderNo; parameters[4].Value = model.UserID; parameters[5].Value = model.CreateDate; parameters[6].Value = DateTime.Now; parameters[7].Value = (int)model.OrderStatus; parameters[8].Value = model.UserName; parameters[9].Value = model.Mobile; parameters[10].Value = model.Address; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 根据当前用户ID得到一个对象实体 /// </summary> public UserBuyOrder GetModelByUserId(int userId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID, OrderNo, UserID,OrderStatus, CreateDate, EditDate "); strSql.Append(" from UserBuyOrder "); strSql.Append(" where UserID=@UserID"); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.Int,4) }; parameters[0].Value = userId; UserBuyOrder model = new UserBuyOrder(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } model.OrderNo = ds.Tables[0].Rows[0]["OrderNo"].ToString(); if (ds.Tables[0].Rows[0]["UserID"].ToString() != "") { model.UserID = int.Parse(ds.Tables[0].Rows[0]["UserID"].ToString()); } if (ds.Tables[0].Rows[0]["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(ds.Tables[0].Rows[0]["CreateDate"].ToString()); } if (ds.Tables[0].Rows[0]["EditDate"].ToString() != "") { model.EditDate = DateTime.Parse(ds.Tables[0].Rows[0]["EditDate"].ToString()); } if (ds.Tables[0].Rows[0]["OrderStatus"].ToString() != "") { model.OrderStatus = (OrderStatus)Enum.Parse(typeof(OrderStatus), ds.Tables[0].Rows[0]["OrderStatus"].ToString(), false); } return model; } else { return null; } }
/// <summary> /// 获得数据列表 /// </summary> public List<UserBuyOrder> GetUserBuyOrdersList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * "); strSql.Append(" FROM UserBuyOrder "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } DataSet ds = DbHelperSQL.Query(strSql.ToString()); List<UserBuyOrder> userBuyOrders = new List<UserBuyOrder>(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { UserBuyOrder model = new UserBuyOrder(); if (ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } model.OrderNo = ds.Tables[0].Rows[0]["OrderNo"].ToString(); if (ds.Tables[0].Rows[0]["UserID"].ToString() != "") { model.UserID = int.Parse(ds.Tables[0].Rows[0]["UserID"].ToString()); } if (ds.Tables[0].Rows[0]["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(ds.Tables[0].Rows[0]["CreateDate"].ToString()); } if (ds.Tables[0].Rows[0]["EditDate"].ToString() != "") { model.EditDate = DateTime.Parse(ds.Tables[0].Rows[0]["EditDate"].ToString()); } if (ds.Tables[0].Rows[0]["OrderStatus"].ToString() != "") { model.OrderStatus = (OrderStatus) Enum.Parse(typeof(OrderStatus), ds.Tables[0].Rows[0]["OrderStatus"].ToString(), false); } userBuyOrders.Add(model); } return userBuyOrders; }
/// <summary> /// 得到一个对象实体 /// </summary> public UserBuyOrder GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID, Email, ShenFenID, OrderNo, UserID, CreateDate, EditDate, OrderStatus, UserName, Mobile, Address "); strSql.Append(" from UserBuyOrder "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int,4) }; parameters[0].Value = ID; UserBuyOrder model = new UserBuyOrder(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } model.Email = ds.Tables[0].Rows[0]["Email"].ToString(); model.ShenFenID = ds.Tables[0].Rows[0]["ShenFenID"].ToString(); model.OrderNo = ds.Tables[0].Rows[0]["OrderNo"].ToString(); if (ds.Tables[0].Rows[0]["UserID"].ToString() != "") { model.UserID = int.Parse(ds.Tables[0].Rows[0]["UserID"].ToString()); } if (ds.Tables[0].Rows[0]["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(ds.Tables[0].Rows[0]["CreateDate"].ToString()); } if (ds.Tables[0].Rows[0]["EditDate"].ToString() != "") { model.EditDate = DateTime.Parse(ds.Tables[0].Rows[0]["EditDate"].ToString()); } if (ds.Tables[0].Rows[0]["OrderStatus"].ToString() != "") { model.OrderStatus = (OrderStatus)Enum.Parse(typeof(OrderStatus), ds.Tables[0].Rows[0]["OrderStatus"].ToString()); } model.UserName = ds.Tables[0].Rows[0]["UserName"].ToString(); model.Mobile = ds.Tables[0].Rows[0]["Mobile"].ToString(); model.Address = ds.Tables[0].Rows[0]["Address"].ToString(); return model; } else { return null; } }