/// <summary> /// 增加一条数据 /// </summary> public void Add(KFB_LHCKPSD model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into KFB_LHCKPSD("); strSql.Append("N_NO,N_TERM,N_STARTTIME,N_TBHSTOPTIME,N_OTHERSTOPTIME,N_OTHERSHOWTIME,N_FLAG,N_OPEN,N_TBH,N_TT,N_TH,N_QCP,N_234,N_JS,N_MONEY,N_DATE)"); strSql.Append(" values ("); strSql.Append(":N_NO,:N_TERM,:N_STARTTIME,:N_TBHSTOPTIME,:N_OTHERSTOPTIME,:N_OTHERSHOWTIME,:N_FLAG,:N_OPEN,:N_TBH,:N_TT,:N_TH,:N_QCP,:N_234,:N_JS,:N_MONEY,:N_DATE)"); OracleParameter[] parameters = { new OracleParameter(":N_NO", OracleType.Number, 10), new OracleParameter(":N_TERM", OracleType.Number, 4), new OracleParameter(":N_STARTTIME", OracleType.DateTime), new OracleParameter(":N_TBHSTOPTIME", OracleType.Number, 4), new OracleParameter(":N_OTHERSTOPTIME", OracleType.Number, 4), new OracleParameter(":N_OTHERSHOWTIME", OracleType.Number, 4), new OracleParameter(":N_FLAG", OracleType.Number, 4), new OracleParameter(":N_OPEN", OracleType.Number, 4), new OracleParameter(":N_TBH", OracleType.Number, 4), new OracleParameter(":N_TT", OracleType.Number, 4), new OracleParameter(":N_TH", OracleType.Number, 4), new OracleParameter(":N_QCP", OracleType.Number, 4), new OracleParameter(":N_234", OracleType.Number, 4), new OracleParameter(":N_JS", OracleType.Number, 4), new OracleParameter(":N_MONEY", OracleType.Float, 22), new OracleParameter(":N_DATE", OracleType.DateTime) }; parameters[0].Value = model.N_NO; parameters[1].Value = model.N_TERM; parameters[2].Value = model.N_STARTTIME; parameters[3].Value = model.N_TBHSTOPTIME; parameters[4].Value = model.N_OTHERSTOPTIME; parameters[5].Value = model.N_OTHERSHOWTIME; parameters[6].Value = model.N_FLAG; parameters[7].Value = model.N_OPEN; parameters[8].Value = model.N_TBH; parameters[9].Value = model.N_TT; parameters[10].Value = model.N_TH; parameters[11].Value = model.N_QCP; parameters[12].Value = model.N_234; parameters[13].Value = model.N_JS; parameters[14].Value = model.N_MONEY; parameters[15].Value = model.N_DATE; DbHelperOra.ExecuteSql(strSql.ToString(), parameters); }
protected void btgz_Click(object sender, EventArgs e) { try { DataTable DT = new DataTable(); DT = objDailyDB.GetModel().Tables[0]; int strcxbb = int.Parse(DT.Rows[0]["N_CXBB"].ToString()); if (!strcxbb.Equals(1)) { objDailyDB.UpdateCXBB(1); } Button btkf = ((Button)sender); int index = ((System.Web.UI.WebControls.GridViewRow)(btkf.Parent.Parent)).RowIndex; string strid = ((Label)this.gridGZ.Rows[index].Cells[0].FindControl("lbzwrq")).Text; //插入oldbill表中數 // Hashtable htb = new Hashtable(); ArrayList strar = new ArrayList(); ArrayList par = new ArrayList(); //更新彩票 objDailyDB.TranCPType(strid, strar, par); //插入oldbill表中數 objDailyDB.InsertOld(strid, strar, par); //刪除bill表數 objDailyDB.dele(strid, strar, par); //删除旧的比赛 objDailyDB.InsertOldBALL(strid, strar, par); objDailyDB.deleBALL(strid, strar, par); //時事跟新過賬記錄 objDailyDB.TranLiveType(strid, strar, par); //赛马 objDailyDB.InsertSMOld(strid, strar, par); objDailyDB.deleSM(strid, strar, par); ////時事像old中新增資料,刪除livejl中的資料 //o_PTZD.InsertOldLive(strid, strar, par); //o_PTZD.deleLive(strid, strar, par); //更新帳務日 //更新過 objDailyDB.trans(strid, mUserID, strar, par); //更新六合彩 大乐透 string[] strlx = new string[] { "lhc", "dlt" }; for (int i = 0; i < strlx.Length; i++) { objDailyDB.delelhc(strlx[i].ToString(), strar, par); } KFB_LHCKPSD mo_LHCKPSD = new KFB_LHCKPSD(); //取出未封盘 if (!objDailyDB.Exists(0, 0)) { objDailyDB.upFlag("1"); mo_LHCKPSD.N_NO = Comm.GetNO(); mo_LHCKPSD.N_TERM = objDailyDB.GetMaxNo() + 1; mo_LHCKPSD.N_STARTTIME = DateTime.Now; mo_LHCKPSD.N_TBHSTOPTIME = 5; mo_LHCKPSD.N_OTHERSHOWTIME = 5; mo_LHCKPSD.N_OTHERSTOPTIME = 5; mo_LHCKPSD.N_MONEY = 100; mo_LHCKPSD.N_DATE = DateTime.Now; mo_LHCKPSD.N_FLAG = 0; mo_LHCKPSD.N_OPEN = 0; mo_LHCKPSD.N_TBH = 0; mo_LHCKPSD.N_TT = 0; mo_LHCKPSD.N_TH = 0; mo_LHCKPSD.N_QCP = 0; mo_LHCKPSD.N_234 = 0; mo_LHCKPSD.N_JS = 0; objDailyDB.Add(mo_LHCKPSD); } KFB_DLTKPSD mo_DLTKPSD = new KFB_DLTKPSD(); //取出未封盘 if (!objDailyDB.ExistsTK(0, 0)) { objDailyDB.upFlagTK("1"); mo_DLTKPSD.N_NO = Comm.GetNO(); mo_DLTKPSD.N_TERM = objDailyDB.GetTKNO() + 1; mo_DLTKPSD.N_STARTTIME = DateTime.Now; mo_DLTKPSD.N_TBHSTOPTIME = 5; mo_DLTKPSD.N_OTHERSHOWTIME = 5; mo_DLTKPSD.N_OTHERSTOPTIME = 5; mo_DLTKPSD.N_MONEY = 100; mo_DLTKPSD.N_DATE = DateTime.Now; mo_DLTKPSD.N_FLAG = 0; mo_DLTKPSD.N_OPEN = 0; mo_DLTKPSD.N_TBH = 0; mo_DLTKPSD.N_TT = 0; mo_DLTKPSD.N_TH = 0; mo_DLTKPSD.N_QCP = 0; mo_DLTKPSD.N_234 = 0; mo_DLTKPSD.N_JS = 0; objDailyDB.AddTK(mo_DLTKPSD); } objDailyDB.ExecuteSqlTran(strar, par); objDailyDB.UpdateCXBB(strcxbb); ShowMsg("过账成功!"); } catch (Exception ex) { this.WriteLog(ex.ToString()); ShowMsg("过账失败!"); } }