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 { } } }