/// <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("过账失败！");
}
}
