/// <summary>
/// 得到 t_orders 数据实体
/// </summary>
/// <param name="dr">dr</param>
/// <returns>t_orders 数据实体</returns>
public T_OrdersEntity Populate_T_OrdersEntity_FromDr(IDataReader dr)
{
T_OrdersEntity Obj = new T_OrdersEntity();
Obj.OrderId = ((dr["OrderId"]) == DBNull.Value)?0:Convert.ToInt32(dr["OrderId"]);
Obj.OrderCode = dr["OrderCode"].ToString();
Obj.UserId = ((dr["UserId"]) == DBNull.Value)?0:Convert.ToInt32(dr["UserId"]);
Obj.PaymentId = ((dr["PaymentId"]) == DBNull.Value)?0:Convert.ToInt32(dr["PaymentId"]);
Obj.TotalPrice = ((dr["TotalPrice"]) == DBNull.Value)?0:Convert.ToDecimal(dr["TotalPrice"]);
Obj.Postage = ((dr["Postage"]) == DBNull.Value)?0:Convert.ToDecimal(dr["Postage"]);
Obj.Status = ((dr["Status"]) == DBNull.Value)?0:Convert.ToInt32(dr["Status"]);
Obj.Consignee = dr["Consignee"].ToString();
Obj.LocationId = ((dr["LocationId"]) == DBNull.Value)?0:Convert.ToInt32(dr["LocationId"]);
Obj.Buyer = dr["Buyer"].ToString();
Obj.Phone = dr["Phone"].ToString();
Obj.Address = dr["Address"].ToString();
Obj.Description = dr["Description"].ToString();
Obj.AddTime = ((dr["AddTime"]) == DBNull.Value)?Convert.ToDateTime("1900-1-1"):Convert.ToDateTime(dr["AddTime"]);
Obj.UpdateTime = ((dr["UpdateTime"]) == DBNull.Value)?Convert.ToDateTime("1900-1-1"):Convert.ToDateTime(dr["UpdateTime"]);
Obj.ConfirmTime = ((dr["ConfirmTime"]) == DBNull.Value)?Convert.ToDateTime("1900-1-1"):Convert.ToDateTime(dr["ConfirmTime"]);
Obj.SendTime = ((dr["SendTime"]) == DBNull.Value)?Convert.ToDateTime("1900-1-1"):Convert.ToDateTime(dr["SendTime"]);
Obj.expresstype = ((dr["expresstype"]) == DBNull.Value)?0:Convert.ToInt32(dr["expresstype"]);
Obj.expresscode = dr["expresscode"].ToString();
Obj.ordertype = ((dr["ordertype"]) == DBNull.Value)?0:Convert.ToInt32(dr["ordertype"]);
Obj.RefundTime = ((dr["RefundTime"]) == DBNull.Value)?Convert.ToDateTime("1900-1-1"):Convert.ToDateTime(dr["RefundTime"]);
Obj.ReturnTime = ((dr["ReturnTime"]) == DBNull.Value)?Convert.ToDateTime("1900-1-1"):Convert.ToDateTime(dr["ReturnTime"]);
Obj.Daili = dr["Daili"].ToString();
Obj.ShopId = ((dr["ShopId"]) == DBNull.Value)?0:Convert.ToInt32(dr["ShopId"]);
Obj.GroupNo = dr["GroupNo"].ToString();
Obj.GroupNum = ((dr["GroupNum"]) == DBNull.Value)?0:Convert.ToInt32(dr["GroupNum"]);
Obj.HeadStatus = ((dr["HeadStatus"]) == DBNull.Value)?0:Convert.ToInt32(dr["HeadStatus"]);
Obj.GroupStatus = ((dr["GroupStatus"]) == DBNull.Value)?0:Convert.ToInt32(dr["GroupStatus"]);
return(Obj);
}
/// <summary>
/// 根据ID,返回一个T_Orders对象
/// </summary>
/// <param name="orderId">orderId</param>
/// <returns>T_Orders对象</returns>
public T_OrdersEntity Get_T_OrdersEntity(int orderId)
{
T_OrdersEntity _obj = null;
SqlParameter[] _param =
{
new SqlParameter("@OrderId", SqlDbType.Int)
};
_param[0].Value = orderId;
string sqlStr = "select * from T_Orders with(nolock) where OrderId=@OrderId";
using (SqlDataReader dr = SqlHelper.ExecuteReader(WebConfig.WfxRW, CommandType.Text, sqlStr, _param))
{
while (dr.Read())
{
_obj = Populate_T_OrdersEntity_FromDr(dr);
}
}
return(_obj);
}
public void Update(T_OrdersEntity t_OrdersEntity)
{
t_Ordersdal.Update(t_OrdersEntity);
}
public int Insert(T_OrdersEntity t_OrdersEntity)
{
return(t_Ordersdal.Insert(t_OrdersEntity));
}
/// <summary>
/// 向数据库中插入一条新记录。
/// </summary>
/// <param name="_T_OrdersModel">T_Orders实体</param>
/// <returns>新插入记录的编号</returns>
public int Insert(T_OrdersEntity _T_OrdersModel)
{
string sqlStr = "insert into T_Orders([OrderCode],[UserId],[PaymentId],[TotalPrice],[Postage],[Status],[Consignee],[LocationId],[Buyer],[Phone],[Address],[Description],[AddTime],[UpdateTime],[ConfirmTime],[SendTime],[expresstype],[expresscode],[ordertype],[RefundTime],[ReturnTime],[Daili],[ShopId],[GroupNo],[GroupNum],[HeadStatus],[GroupStatus]) values(@OrderCode,@UserId,@PaymentId,@TotalPrice,@Postage,@Status,@Consignee,@LocationId,@Buyer,@Phone,@Address,@Description,@AddTime,@UpdateTime,@ConfirmTime,@SendTime,@expresstype,@expresscode,@ordertype,@RefundTime,@ReturnTime,@Daili,@ShopId,@GroupNo,@GroupNum,@HeadStatus,@GroupStatus) select @@identity";
int res;
SqlParameter[] _param =
{
new SqlParameter("@OrderCode", SqlDbType.VarChar),
new SqlParameter("@UserId", SqlDbType.Int),
new SqlParameter("@PaymentId", SqlDbType.Int),
new SqlParameter("@TotalPrice", SqlDbType.Decimal),
new SqlParameter("@Postage", SqlDbType.Decimal),
new SqlParameter("@Status", SqlDbType.Int),
new SqlParameter("@Consignee", SqlDbType.VarChar),
new SqlParameter("@LocationId", SqlDbType.Int),
new SqlParameter("@Buyer", SqlDbType.VarChar),
new SqlParameter("@Phone", SqlDbType.VarChar),
new SqlParameter("@Address", SqlDbType.VarChar),
new SqlParameter("@Description", SqlDbType.VarChar),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@ConfirmTime", SqlDbType.DateTime),
new SqlParameter("@SendTime", SqlDbType.DateTime),
new SqlParameter("@expresstype", SqlDbType.Int),
new SqlParameter("@expresscode", SqlDbType.VarChar),
new SqlParameter("@ordertype", SqlDbType.Int),
new SqlParameter("@RefundTime", SqlDbType.DateTime),
new SqlParameter("@ReturnTime", SqlDbType.DateTime),
new SqlParameter("@Daili", SqlDbType.VarChar),
new SqlParameter("@ShopId", SqlDbType.Int),
new SqlParameter("@GroupNo", SqlDbType.VarChar),
new SqlParameter("@GroupNum", SqlDbType.Int),
new SqlParameter("@HeadStatus", SqlDbType.Int),
new SqlParameter("@GroupStatus", SqlDbType.Int)
};
_param[0].Value = _T_OrdersModel.OrderCode;
_param[1].Value = _T_OrdersModel.UserId;
_param[2].Value = _T_OrdersModel.PaymentId;
_param[3].Value = _T_OrdersModel.TotalPrice;
_param[4].Value = _T_OrdersModel.Postage;
_param[5].Value = _T_OrdersModel.Status;
_param[6].Value = _T_OrdersModel.Consignee;
_param[7].Value = _T_OrdersModel.LocationId;
_param[8].Value = _T_OrdersModel.Buyer;
_param[9].Value = _T_OrdersModel.Phone;
_param[10].Value = _T_OrdersModel.Address;
_param[11].Value = _T_OrdersModel.Description;
_param[12].Value = _T_OrdersModel.AddTime;
_param[13].Value = _T_OrdersModel.UpdateTime;
_param[14].Value = _T_OrdersModel.ConfirmTime;
_param[15].Value = _T_OrdersModel.SendTime;
_param[16].Value = _T_OrdersModel.expresstype;
_param[17].Value = _T_OrdersModel.expresscode;
_param[18].Value = _T_OrdersModel.ordertype;
_param[19].Value = _T_OrdersModel.RefundTime;
_param[20].Value = _T_OrdersModel.ReturnTime;
_param[21].Value = _T_OrdersModel.Daili;
_param[22].Value = _T_OrdersModel.ShopId;
_param[23].Value = _T_OrdersModel.GroupNo;
_param[24].Value = _T_OrdersModel.GroupNum;
_param[25].Value = _T_OrdersModel.HeadStatus;
_param[26].Value = _T_OrdersModel.GroupStatus;
res = Convert.ToInt32(SqlHelper.ExecuteScalar(WebConfig.WfxRW, CommandType.Text, sqlStr, _param));
return(res);
}
/// <summary>
/// 向数据表T_Orders更新一条记录。带事务
/// </summary>
/// <param name="sp">事务对象</param>
/// <param name="_T_OrdersModel">_T_OrdersModel</param>
/// <returns>影响的行数</returns>
public int Update(SqlTransaction sp, T_OrdersEntity _T_OrdersModel)
{
string sqlStr = "update T_Orders set [OrderCode]=@OrderCode,[UserId]=@UserId,[PaymentId]=@PaymentId,[TotalPrice]=@TotalPrice,[Postage]=@Postage,[Status]=@Status,[Consignee]=@Consignee,[LocationId]=@LocationId,[Buyer]=@Buyer,[Phone]=@Phone,[Address]=@Address,[Description]=@Description,[AddTime]=@AddTime,[UpdateTime]=@UpdateTime,[ConfirmTime]=@ConfirmTime,[SendTime]=@SendTime,[expresstype]=@expresstype,[expresscode]=@expresscode,[ordertype]=@ordertype,[RefundTime]=@RefundTime,[ReturnTime]=@ReturnTime,[Daili]=@Daili,[ShopId]=@ShopId,[GroupNo]=@GroupNo,[GroupNum]=@GroupNum,[HeadStatus]=@HeadStatus,[GroupStatus]=@GroupStatus where OrderId=@OrderId";
SqlParameter[] _param =
{
new SqlParameter("@OrderId", SqlDbType.Int),
new SqlParameter("@OrderCode", SqlDbType.VarChar),
new SqlParameter("@UserId", SqlDbType.Int),
new SqlParameter("@PaymentId", SqlDbType.Int),
new SqlParameter("@TotalPrice", SqlDbType.Decimal),
new SqlParameter("@Postage", SqlDbType.Decimal),
new SqlParameter("@Status", SqlDbType.Int),
new SqlParameter("@Consignee", SqlDbType.VarChar),
new SqlParameter("@LocationId", SqlDbType.Int),
new SqlParameter("@Buyer", SqlDbType.VarChar),
new SqlParameter("@Phone", SqlDbType.VarChar),
new SqlParameter("@Address", SqlDbType.VarChar),
new SqlParameter("@Description", SqlDbType.VarChar),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@ConfirmTime", SqlDbType.DateTime),
new SqlParameter("@SendTime", SqlDbType.DateTime),
new SqlParameter("@expresstype", SqlDbType.Int),
new SqlParameter("@expresscode", SqlDbType.VarChar),
new SqlParameter("@ordertype", SqlDbType.Int),
new SqlParameter("@RefundTime", SqlDbType.DateTime),
new SqlParameter("@ReturnTime", SqlDbType.DateTime),
new SqlParameter("@Daili", SqlDbType.VarChar),
new SqlParameter("@ShopId", SqlDbType.Int),
new SqlParameter("@GroupNo", SqlDbType.VarChar),
new SqlParameter("@GroupNum", SqlDbType.Int),
new SqlParameter("@HeadStatus", SqlDbType.Int),
new SqlParameter("@GroupStatus", SqlDbType.Int)
};
_param[0].Value = _T_OrdersModel.OrderId;
_param[1].Value = _T_OrdersModel.OrderCode;
_param[2].Value = _T_OrdersModel.UserId;
_param[3].Value = _T_OrdersModel.PaymentId;
_param[4].Value = _T_OrdersModel.TotalPrice;
_param[5].Value = _T_OrdersModel.Postage;
_param[6].Value = _T_OrdersModel.Status;
_param[7].Value = _T_OrdersModel.Consignee;
_param[8].Value = _T_OrdersModel.LocationId;
_param[9].Value = _T_OrdersModel.Buyer;
_param[10].Value = _T_OrdersModel.Phone;
_param[11].Value = _T_OrdersModel.Address;
_param[12].Value = _T_OrdersModel.Description;
_param[13].Value = _T_OrdersModel.AddTime;
_param[14].Value = _T_OrdersModel.UpdateTime;
_param[15].Value = _T_OrdersModel.ConfirmTime;
_param[16].Value = _T_OrdersModel.SendTime;
_param[17].Value = _T_OrdersModel.expresstype;
_param[18].Value = _T_OrdersModel.expresscode;
_param[19].Value = _T_OrdersModel.ordertype;
_param[20].Value = _T_OrdersModel.RefundTime;
_param[21].Value = _T_OrdersModel.ReturnTime;
_param[22].Value = _T_OrdersModel.Daili;
_param[23].Value = _T_OrdersModel.ShopId;
_param[24].Value = _T_OrdersModel.GroupNo;
_param[25].Value = _T_OrdersModel.GroupNum;
_param[26].Value = _T_OrdersModel.HeadStatus;
_param[27].Value = _T_OrdersModel.GroupStatus;
return(SqlHelper.ExecuteNonQuery(sp, CommandType.Text, sqlStr, _param));
}