/// <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;
}
}