public int Save()
{
int i = 0;
if (!HaveImported)
{
int payStatus = 1;
if (OrderType.Trim().Equals("现货未付"))
{
payStatus = 0;
}
string[,] insertParam = { { "flow_number", "varchar", flowNumber.Trim() },
{ "type", "varchar", OrderType.Trim() },
{ "open_id", "varchar", "" },
{ "member_name", "varchar", MemberName.Trim() },
{ "cell_number", "varchar", CellNumber.Trim() },
{ "price", "float", OrderPrice.ToString() },
{ "dragon_ball_used", "int", UsedDragonBallCount.ToString() },
{ "ticket_used_amount", "float", UsedTicketAmount.ToString().Trim() },
{ "real_paid_summary", "float", RealPaidAmount.ToString() },
{ "dragon_ball_rate", "float", DragonBallRate.ToString().Trim() },
{ "dragon_ball_generated", "int", GenerateDraonBallCount.ToString() },
{ "pay_status", "int", payStatus.ToString() },
{ "order_date", "datetime", Date.ToShortDateString() } };
i = DBHelper.InsertData("orders", insertParam);
if (i > 0)
{
foreach (OrderDetail dtl in orderDetails)
{
dtl.Save();
}
}
}
return(i);
}
public void TransferOrderAndPointsFromTempAccount()
{
//string tempOpenId = TempOpenId.Trim();
DataTable dtOriPoints = DBHelper.GetDataTable(" select * from point_prepare_imported where deal = 0 and cell_number = '" + CellNumber.Trim() + "' ");
foreach (DataRow drOriPoints in dtOriPoints.Rows)
{
try
{
int i = DBHelper.InsertData("user_point_balance",
new string[, ] {
{ "user_open_id", "varchar", OpenId.Trim() }, { "points", "int", drOriPoints["score"].ToString() },
{ "memo", "varchar", drOriPoints["source"].ToString() }, { "transact_date", "datetime", DateTime.Now.ToShortDateString() }
},
Util.conStr);
if (i == 1)
{
DBHelper.UpdateData("point_prepare_imported", new string[, ] {
{ "deal", "int", "1" }
},
new string[, ] {
{ "id", "int", drOriPoints["id"].ToString() }
}, Util.conStr.Trim());
}
}
catch
{
}
}
}
