/// <summary>
/// 得到一个对象实体
/// </summary>
public HQ.Model.OrdersModel GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from HQ_Orders ");
strSql.Append(" where ");
SqlParameter[] parameters =
{
};
HQ.Model.OrdersModel model = new HQ.Model.OrdersModel();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(HQ.Model.OrdersModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update HQ_Orders set ");
strSql.Append("OrderId=@OrderId,");
strSql.Append("OrderSn=@OrderSn,");
strSql.Append("PayTime=@PayTime,");
strSql.Append("Status=@Status,");
strSql.Append("StatusDesc=@StatusDesc,");
strSql.Append("GroupSuccessTime=@GroupSuccessTime,");
strSql.Append("ReceiveTime=@ReceiveTime,");
strSql.Append("OrderType=@OrderType,");
strSql.Append("ModifyTime=@ModifyTime,");
strSql.Append("PromotionAmount=@PromotionAmount,");
strSql.Append("Amount=@Amount,");
strSql.Append("GoodsPrice=@GoodsPrice,");
strSql.Append("GoodsQuantity=@GoodsQuantity,");
strSql.Append("GoodsThumbnailUrl=@GoodsThumbnailUrl,");
strSql.Append("GoodsName=@GoodsName,");
strSql.Append("GoodsId=@GoodsId,");
strSql.Append("PId=@PId,");
strSql.Append("CustomParameters=@CustomParameters,");
strSql.Append("UserId=@UserId,");
strSql.Append("AgentId=@AgentId,");
strSql.Append("PlatType=@PlatType");
strSql.Append(" where ");
SqlParameter[] parameters =
{
new SqlParameter("@OrderId", SqlDbType.VarChar, 35),
new SqlParameter("@OrderSn", SqlDbType.VarChar, 35),
new SqlParameter("@PayTime", SqlDbType.DateTime),
new SqlParameter("@Status", SqlDbType.SmallInt, 2),
new SqlParameter("@StatusDesc", SqlDbType.VarChar, 50),
new SqlParameter("@GroupSuccessTime", SqlDbType.DateTime),
new SqlParameter("@ReceiveTime", SqlDbType.DateTime),
new SqlParameter("@OrderType", SqlDbType.SmallInt, 2),
new SqlParameter("@ModifyTime", SqlDbType.DateTime),
new SqlParameter("@PromotionAmount", SqlDbType.Decimal, 9),
new SqlParameter("@Amount", SqlDbType.Decimal, 9),
new SqlParameter("@GoodsPrice", SqlDbType.Decimal, 9),
new SqlParameter("@GoodsQuantity", SqlDbType.Int, 4),
new SqlParameter("@GoodsThumbnailUrl", SqlDbType.VarChar, 300),
new SqlParameter("@GoodsName", SqlDbType.VarChar, 500),
new SqlParameter("@GoodsId", SqlDbType.VarChar, 50),
new SqlParameter("@PId", SqlDbType.VarChar, 30),
new SqlParameter("@CustomParameters", SqlDbType.VarChar, 30),
new SqlParameter("@UserId", SqlDbType.Int, 4),
new SqlParameter("@AgentId", SqlDbType.Int, 4),
new SqlParameter("@PlatType", SqlDbType.SmallInt, 2)
};
parameters[0].Value = model.OrderId;
parameters[1].Value = model.OrderSn;
parameters[2].Value = model.PayTime;
parameters[3].Value = model.Status;
parameters[4].Value = model.StatusDesc;
parameters[5].Value = model.GroupSuccessTime;
parameters[6].Value = model.ReceiveTime;
parameters[7].Value = model.OrderType;
parameters[8].Value = model.ModifyTime;
parameters[9].Value = model.PromotionAmount;
parameters[10].Value = model.Amount;
parameters[11].Value = model.GoodsPrice;
parameters[12].Value = model.GoodsQuantity;
parameters[13].Value = model.GoodsThumbnailUrl;
parameters[14].Value = model.GoodsName;
parameters[15].Value = model.GoodsId;
parameters[16].Value = model.PId;
parameters[17].Value = model.CustomParameters;
parameters[18].Value = model.UserId;
parameters[19].Value = model.AgentId;
parameters[20].Value = model.PlatType;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(HQ.Model.OrdersModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into HQ_Orders(");
strSql.Append("OrderId,OrderSn,PayTime,Status,StatusDesc,GroupSuccessTime,ReceiveTime,OrderType,ModifyTime,PromotionAmount,Amount,GoodsPrice,GoodsQuantity,GoodsThumbnailUrl,GoodsName,GoodsId,PId,CustomParameters,UserId,AgentId,PlatType)");
strSql.Append(" values (");
strSql.Append("@OrderId,@OrderSn,@PayTime,@Status,@StatusDesc,@GroupSuccessTime,@ReceiveTime,@OrderType,@ModifyTime,@PromotionAmount,@Amount,@GoodsPrice,@GoodsQuantity,@GoodsThumbnailUrl,@GoodsName,@GoodsId,@PId,@CustomParameters,@UserId,@AgentId,@PlatType)");
SqlParameter[] parameters =
{
new SqlParameter("@OrderId", SqlDbType.VarChar, 35),
new SqlParameter("@OrderSn", SqlDbType.VarChar, 35),
new SqlParameter("@PayTime", SqlDbType.DateTime),
new SqlParameter("@Status", SqlDbType.SmallInt, 2),
new SqlParameter("@StatusDesc", SqlDbType.VarChar, 50),
new SqlParameter("@GroupSuccessTime", SqlDbType.DateTime),
new SqlParameter("@ReceiveTime", SqlDbType.DateTime),
new SqlParameter("@OrderType", SqlDbType.SmallInt, 2),
new SqlParameter("@ModifyTime", SqlDbType.DateTime),
new SqlParameter("@PromotionAmount", SqlDbType.Decimal, 9),
new SqlParameter("@Amount", SqlDbType.Decimal, 9),
new SqlParameter("@GoodsPrice", SqlDbType.Decimal, 9),
new SqlParameter("@GoodsQuantity", SqlDbType.Int, 4),
new SqlParameter("@GoodsThumbnailUrl", SqlDbType.VarChar, 300),
new SqlParameter("@GoodsName", SqlDbType.VarChar, 500),
new SqlParameter("@GoodsId", SqlDbType.VarChar, 50),
new SqlParameter("@PId", SqlDbType.VarChar, 30),
new SqlParameter("@CustomParameters", SqlDbType.VarChar, 30),
new SqlParameter("@UserId", SqlDbType.Int, 4),
new SqlParameter("@AgentId", SqlDbType.Int, 4),
new SqlParameter("@PlatType", SqlDbType.SmallInt, 2)
};
parameters[0].Value = model.OrderId;
parameters[1].Value = model.OrderSn;
parameters[2].Value = model.PayTime;
parameters[3].Value = model.Status;
parameters[4].Value = model.StatusDesc;
parameters[5].Value = model.GroupSuccessTime;
parameters[6].Value = model.ReceiveTime;
parameters[7].Value = model.OrderType;
parameters[8].Value = model.ModifyTime;
parameters[9].Value = model.PromotionAmount;
parameters[10].Value = model.Amount;
parameters[11].Value = model.GoodsPrice;
parameters[12].Value = model.GoodsQuantity;
parameters[13].Value = model.GoodsThumbnailUrl;
parameters[14].Value = model.GoodsName;
parameters[15].Value = model.GoodsId;
parameters[16].Value = model.PId;
parameters[17].Value = model.CustomParameters;
parameters[18].Value = model.UserId;
parameters[19].Value = model.AgentId;
parameters[20].Value = model.PlatType;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public HQ.Model.OrdersModel DataRowToModel(DataRow row)
{
HQ.Model.OrdersModel model = new HQ.Model.OrdersModel();
if (row != null)
{
if (row["OrderId"] != null)
{
model.OrderId = row["OrderId"].ToString();
}
if (row["OrderSn"] != null)
{
model.OrderSn = row["OrderSn"].ToString();
}
if (row["PayTime"] != null && row["PayTime"].ToString() != "")
{
model.PayTime = DateTime.Parse(row["PayTime"].ToString());
}
if (row["Status"] != null && row["Status"].ToString() != "")
{
model.Status = int.Parse(row["Status"].ToString());
}
if (row["StatusDesc"] != null)
{
model.StatusDesc = row["StatusDesc"].ToString();
}
if (row["GroupSuccessTime"] != null && row["GroupSuccessTime"].ToString() != "")
{
model.GroupSuccessTime = DateTime.Parse(row["GroupSuccessTime"].ToString());
}
if (row["ReceiveTime"] != null && row["ReceiveTime"].ToString() != "")
{
model.ReceiveTime = DateTime.Parse(row["ReceiveTime"].ToString());
}
if (row["OrderType"] != null && row["OrderType"].ToString() != "")
{
model.OrderType = int.Parse(row["OrderType"].ToString());
}
if (row["ModifyTime"] != null && row["ModifyTime"].ToString() != "")
{
model.ModifyTime = DateTime.Parse(row["ModifyTime"].ToString());
}
if (row["PromotionAmount"] != null && row["PromotionAmount"].ToString() != "")
{
model.PromotionAmount = decimal.Parse(row["PromotionAmount"].ToString());
}
if (row["Amount"] != null && row["Amount"].ToString() != "")
{
model.Amount = decimal.Parse(row["Amount"].ToString());
}
if (row["GoodsPrice"] != null && row["GoodsPrice"].ToString() != "")
{
model.GoodsPrice = decimal.Parse(row["GoodsPrice"].ToString());
}
if (row["GoodsQuantity"] != null && row["GoodsQuantity"].ToString() != "")
{
model.GoodsQuantity = int.Parse(row["GoodsQuantity"].ToString());
}
if (row["GoodsThumbnailUrl"] != null)
{
model.GoodsThumbnailUrl = row["GoodsThumbnailUrl"].ToString();
}
if (row["GoodsName"] != null)
{
model.GoodsName = row["GoodsName"].ToString();
}
if (row["GoodsId"] != null)
{
model.GoodsId = row["GoodsId"].ToString();
}
if (row["PId"] != null)
{
model.PId = row["PId"].ToString();
}
if (row["CustomParameters"] != null)
{
model.CustomParameters = row["CustomParameters"].ToString();
}
if (row["UserId"] != null && row["UserId"].ToString() != "")
{
model.UserId = int.Parse(row["UserId"].ToString());
}
if (row["AgentId"] != null && row["AgentId"].ToString() != "")
{
model.AgentId = int.Parse(row["AgentId"].ToString());
}
if (row["PlatType"] != null && row["PlatType"].ToString() != "")
{
model.PlatType = int.Parse(row["PlatType"].ToString());
}
}
return(model);
}
