/// <summary>
/// 增加一条数据
/// </summary>
public long Add(lgk.Model.tb_UserOrder model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_UserOrder(");
strSql.Append("Status,Flag,UserID,OrderCode,IntegralAmount,PurchaseAmount,SellAmount,BuyTime,order001,IsSettle,ReceivieAddress,Province,City,Country");
strSql.Append(") values (");
strSql.Append("@Status,@Flag,@UserID,@OrderCode,@IntegralAmount,@PurchaseAmount,@SellAmount,@BuyTime,@order001,@IsSettle,@ReceivieAddress,@Province,@City,@Country");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@Flag", SqlDbType.Int, 4),
new SqlParameter("@UserID", SqlDbType.BigInt, 8),
new SqlParameter("@OrderCode", SqlDbType.VarChar, 50),
new SqlParameter("@IntegralAmount", SqlDbType.Decimal, 9),
new SqlParameter("@PurchaseAmount", SqlDbType.Decimal, 9),
new SqlParameter("@SellAmount", SqlDbType.Decimal, 9),
new SqlParameter("@BuyTime", SqlDbType.DateTime),
new SqlParameter("@order001", SqlDbType.Int, 4),
new SqlParameter("@IsSettle", SqlDbType.Int, 4),
new SqlParameter("@ReceivieAddress", SqlDbType.VarChar, 500),
new SqlParameter("@Province", SqlDbType.VarChar, 50),
new SqlParameter("@City", SqlDbType.VarChar, 50),
new SqlParameter("@Country", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.Status;
parameters[1].Value = model.Flag;
parameters[2].Value = model.UserID;
parameters[3].Value = model.OrderCode;
parameters[4].Value = model.IntegralAmount;
parameters[5].Value = model.PurchaseAmount;
parameters[6].Value = model.SellAmount;
parameters[7].Value = model.BuyTime;
parameters[8].Value = model.order001;
parameters[9].Value = model.IsSettle;
parameters[10].Value = model.ReceivieAddress;
parameters[11].Value = model.Province;
parameters[12].Value = model.City;
parameters[13].Value = model.Country;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt64(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(lgk.Model.tb_UserOrder model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public long Add(lgk.Model.tb_UserOrder model)
{
return(dal.Add(model));
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <lgk.Model.tb_UserOrder> DataTableToList(DataTable dt)
{
List <lgk.Model.tb_UserOrder> modelList = new List <lgk.Model.tb_UserOrder>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
lgk.Model.tb_UserOrder model;
for (int n = 0; n < rowsCount; n++)
{
model = new lgk.Model.tb_UserOrder();
if (dt.Rows[n]["ID"].ToString() != "")
{
model.ID = long.Parse(dt.Rows[n]["ID"].ToString());
}
if (dt.Rows[n]["Status"].ToString() != "")
{
model.Status = int.Parse(dt.Rows[n]["Status"].ToString());
}
if (dt.Rows[n]["Flag"].ToString() != "")
{
model.Flag = int.Parse(dt.Rows[n]["Flag"].ToString());
}
if (dt.Rows[n]["SendTime"].ToString() != "")
{
model.SendTime = DateTime.Parse(dt.Rows[n]["SendTime"].ToString());
}
if (dt.Rows[n]["ReceiveTime"].ToString() != "")
{
model.ReceiveTime = DateTime.Parse(dt.Rows[n]["ReceiveTime"].ToString());
}
if (dt.Rows[n]["ApplyTime"].ToString() != "")
{
model.ApplyTime = DateTime.Parse(dt.Rows[n]["ApplyTime"].ToString());
}
if (dt.Rows[n]["FinishTime"].ToString() != "")
{
model.FinishTime = DateTime.Parse(dt.Rows[n]["FinishTime"].ToString());
}
if (dt.Rows[n]["IsSettle"].ToString() != "")
{
model.IsSettle = int.Parse(dt.Rows[n]["IsSettle"].ToString());
}
if (dt.Rows[n]["SettleTime"].ToString() != "")
{
model.SettleTime = DateTime.Parse(dt.Rows[n]["SettleTime"].ToString());
}
if (dt.Rows[n]["UserID"].ToString() != "")
{
model.UserID = long.Parse(dt.Rows[n]["UserID"].ToString());
}
model.OrderCode = dt.Rows[n]["OrderCode"].ToString();
if (dt.Rows[n]["IntegralAmount"].ToString() != "")
{
model.IntegralAmount = decimal.Parse(dt.Rows[n]["IntegralAmount"].ToString());
}
if (dt.Rows[n]["PurchaseAmount"].ToString() != "")
{
model.PurchaseAmount = decimal.Parse(dt.Rows[n]["PurchaseAmount"].ToString());
}
if (dt.Rows[n]["SellAmount"].ToString() != "")
{
model.SellAmount = decimal.Parse(dt.Rows[n]["SellAmount"].ToString());
}
if (dt.Rows[n]["BuyTime"].ToString() != "")
{
model.BuyTime = DateTime.Parse(dt.Rows[n]["BuyTime"].ToString());
}
if (dt.Rows[n]["order001"].ToString() != "")
{
model.order001 = int.Parse(dt.Rows[n]["order001"].ToString());
}
if (dt.Rows[n]["order002"].ToString() != "")
{
model.order002 = decimal.Parse(dt.Rows[n]["order002"].ToString());
}
if (dt.Rows[n]["ReceivieAddress"].ToString() != "")
{
model.ReceivieAddress = dt.Rows[n]["ReceivieAddress"].ToString();
}
if (dt.Rows[n]["Province"].ToString() != "")
{
model.Province = dt.Rows[n]["Province"].ToString();
}
if (dt.Rows[n]["City"].ToString() != "")
{
model.City = dt.Rows[n]["City"].ToString();
}
if (dt.Rows[n]["Country"].ToString() != "")
{
model.Country = dt.Rows[n]["Country"].ToString();
}
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(lgk.Model.tb_UserOrder model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_UserOrder set ");
strSql.Append(" Status = @Status , ");
strSql.Append(" Flag = @Flag , ");
strSql.Append(" SendTime = @SendTime , ");
strSql.Append(" ReceiveTime = @ReceiveTime , ");
strSql.Append(" ApplyTime = @ApplyTime , ");
strSql.Append(" FinishTime = @FinishTime , ");
strSql.Append(" IsSettle = @IsSettle , ");
strSql.Append(" SettleTime = @SettleTime , ");
strSql.Append(" UserID = @UserID , ");
strSql.Append(" OrderCode = @OrderCode , ");
strSql.Append(" IntegralAmount = @IntegralAmount , ");
strSql.Append(" PurchaseAmount = @PurchaseAmount , ");
strSql.Append(" SellAmount = @SellAmount , ");
strSql.Append(" BuyTime = @BuyTime , ");
strSql.Append(" order001 = @order001 , ");//
strSql.Append(" order002 = @order002 , ");
strSql.Append(" ReceivieAddress = @ReceivieAddress , ");
strSql.Append(" Province = @Province , ");
strSql.Append(" City = @City , ");
strSql.Append(" Country = @Country ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.BigInt, 8),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@Flag", SqlDbType.Int, 4),
new SqlParameter("@SendTime", SqlDbType.DateTime),
new SqlParameter("@ReceiveTime", SqlDbType.DateTime),
new SqlParameter("@ApplyTime", SqlDbType.DateTime),
new SqlParameter("@FinishTime", SqlDbType.DateTime),
new SqlParameter("@IsSettle", SqlDbType.Int, 4),
new SqlParameter("@SettleTime", SqlDbType.DateTime),
new SqlParameter("@UserID", SqlDbType.BigInt, 8),
new SqlParameter("@OrderCode", SqlDbType.VarChar, 50),
new SqlParameter("@IntegralAmount", SqlDbType.Decimal, 9),
new SqlParameter("@PurchaseAmount", SqlDbType.Decimal, 9),
new SqlParameter("@SellAmount", SqlDbType.Decimal, 9),
new SqlParameter("@BuyTime", SqlDbType.DateTime),
new SqlParameter("@order001", SqlDbType.Int, 4),
new SqlParameter("@order002", SqlDbType.Decimal, 9),
new SqlParameter("@ReceivieAddress", SqlDbType.VarChar, 500),
new SqlParameter("@Province", SqlDbType.VarChar, 50),
new SqlParameter("@City", SqlDbType.VarChar, 50),
new SqlParameter("@Country", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.Status;
parameters[2].Value = model.Flag;
parameters[3].Value = model.SendTime;
parameters[4].Value = model.ReceiveTime;
parameters[5].Value = model.ApplyTime;
parameters[6].Value = model.FinishTime;
parameters[7].Value = model.IsSettle;
parameters[8].Value = model.SettleTime;
parameters[9].Value = model.UserID;
parameters[10].Value = model.OrderCode;
parameters[11].Value = model.IntegralAmount;
parameters[12].Value = model.PurchaseAmount;
parameters[13].Value = model.SellAmount;
parameters[14].Value = model.BuyTime;
parameters[15].Value = model.order001;
parameters[16].Value = model.order002;
parameters[17].Value = model.ReceivieAddress;
parameters[18].Value = model.Province;
parameters[19].Value = model.City;
parameters[20].Value = model.Country;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public lgk.Model.tb_UserOrder GetModel(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID, Status, Flag, SendTime, ReceiveTime, ApplyTime, FinishTime, IsSettle, SettleTime, UserID, OrderCode, IntegralAmount, PurchaseAmount, SellAmount, BuyTime, order001, order002, ReceivieAddress, Province, City, Country ");
strSql.Append(" from tb_UserOrder ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
lgk.Model.tb_UserOrder model = new lgk.Model.tb_UserOrder();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = long.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["Status"].ToString() != "")
{
model.Status = int.Parse(ds.Tables[0].Rows[0]["Status"].ToString());
}
if (ds.Tables[0].Rows[0]["Flag"].ToString() != "")
{
model.Flag = int.Parse(ds.Tables[0].Rows[0]["Flag"].ToString());
}
if (ds.Tables[0].Rows[0]["SendTime"].ToString() != "")
{
model.SendTime = DateTime.Parse(ds.Tables[0].Rows[0]["SendTime"].ToString());
}
if (ds.Tables[0].Rows[0]["ReceiveTime"].ToString() != "")
{
model.ReceiveTime = DateTime.Parse(ds.Tables[0].Rows[0]["ReceiveTime"].ToString());
}
if (ds.Tables[0].Rows[0]["ApplyTime"].ToString() != "")
{
model.ApplyTime = DateTime.Parse(ds.Tables[0].Rows[0]["ApplyTime"].ToString());
}
if (ds.Tables[0].Rows[0]["FinishTime"].ToString() != "")
{
model.FinishTime = DateTime.Parse(ds.Tables[0].Rows[0]["FinishTime"].ToString());
}
if (ds.Tables[0].Rows[0]["IsSettle"].ToString() != "")
{
model.IsSettle = int.Parse(ds.Tables[0].Rows[0]["IsSettle"].ToString());
}
if (ds.Tables[0].Rows[0]["SettleTime"].ToString() != "")
{
model.SettleTime = DateTime.Parse(ds.Tables[0].Rows[0]["SettleTime"].ToString());
}
if (ds.Tables[0].Rows[0]["UserID"].ToString() != "")
{
model.UserID = long.Parse(ds.Tables[0].Rows[0]["UserID"].ToString());
}
model.OrderCode = ds.Tables[0].Rows[0]["OrderCode"].ToString();
if (ds.Tables[0].Rows[0]["IntegralAmount"].ToString() != "")
{
model.IntegralAmount = decimal.Parse(ds.Tables[0].Rows[0]["IntegralAmount"].ToString());
}
if (ds.Tables[0].Rows[0]["PurchaseAmount"].ToString() != "")
{
model.PurchaseAmount = decimal.Parse(ds.Tables[0].Rows[0]["PurchaseAmount"].ToString());
}
if (ds.Tables[0].Rows[0]["SellAmount"].ToString() != "")
{
model.SellAmount = decimal.Parse(ds.Tables[0].Rows[0]["SellAmount"].ToString());
}
if (ds.Tables[0].Rows[0]["BuyTime"].ToString() != "")
{
model.BuyTime = DateTime.Parse(ds.Tables[0].Rows[0]["BuyTime"].ToString());
}
if (ds.Tables[0].Rows[0]["order001"].ToString() != "")
{
model.order001 = int.Parse(ds.Tables[0].Rows[0]["order001"].ToString());
}
if (ds.Tables[0].Rows[0]["order002"].ToString() != "")
{
model.order002 = decimal.Parse(ds.Tables[0].Rows[0]["order002"].ToString());
}
if (ds.Tables[0].Rows[0]["ReceivieAddress"].ToString() != "")
{
model.ReceivieAddress = ds.Tables[0].Rows[0]["ReceivieAddress"].ToString();
}
if (ds.Tables[0].Rows[0]["Province"].ToString() != "")
{
model.Province = ds.Tables[0].Rows[0]["Province"].ToString();
}
if (ds.Tables[0].Rows[0]["City"].ToString() != "")
{
model.City = ds.Tables[0].Rows[0]["City"].ToString();
}
if (ds.Tables[0].Rows[0]["Country"].ToString() != "")
{
model.Country = ds.Tables[0].Rows[0]["Country"].ToString();
}
return(model);
}
else
{
return(null);
}
}
