protected override void OnStop()
{
try
{
IShiShiCaiDataGet.ShiShiCaiDataStop();
}
catch (Exception ex)
{
FileLog.WriteError("SSCService02 OnStop() ", ex.Message);
}
}
protected override void OnStart(string[] args)
{
try
{
Thread shishiCai01Thread = new Thread(ShiShiCai01ThreadWorking);
IBoolShiShiCai01ThreadWorking = true;
shishiCai01Thread.Start(this);
FileLog.WriteInfo("SSCService02", "SSCService02Thread Start()");
}
catch (Exception ex)
{
FileLog.WriteError("SSCService02 OnStart() ", ex.Message);
}
}
public static void ShiShiCai01ThreadWorking(object o)
{
try
{
SSCService02 shishicai01 = o as SSCService02;
if (shishicai01.IBoolShiShiCai01ThreadWorking)
{
shishicai01.IShiShiCaiDataGet.ShiShiCaiDataStartup();
}
FileLog.WriteInfo("SSCService02ThreadWorking() ", "SSCService02 Startup()");
}
catch (Exception ex)
{
FileLog.WriteError("SSCService02ThreadWorking() ", ex.Message);
}
}
/// <summary>
/// 更新数据库
/// AType==-1 做全天数据更新
/// 其它为单期数据更新
/// </summary>
public static bool UpateDataBase(List <PeriodDetail_101> AListPeriod, int AType = -1, string YY = "")
{
bool flag = true;
FileLog.WriteInfo("UpateDataBase", "AType=" + AType);
IDbConnection objConn;
IDbDataAdapter objAdapter;
DbCommandBuilder objCmdBuilder;
try
{
string strSql = string.Empty;
if (AType == -1)
{
strSql = string.Format("SELECT * from T_101_{1} where C004={0}", AListPeriod.First().DateNumber_004, YY);
FileLog.WriteInfo("UpateDataBase()", strSql);
}
else
{
strSql = string.Format("SELECT * from T_101_{1} where C001={0}", AListPeriod.Last().LongPeriod_001, YY);
FileLog.WriteInfo("UpateDataBase()", strSql);
}
objConn = DbHelperSQL.GetConnection(sqlConnect);
objAdapter = DbHelperSQL.GetDataAdapter(objConn, strSql);
objCmdBuilder = DbHelperSQL.GetCommandBuilder(objAdapter);
objCmdBuilder.ConflictOption = ConflictOption.OverwriteChanges;
objCmdBuilder.SetAllValues = false;
DataSet objDataSet = new DataSet();
objAdapter.Fill(objDataSet);
//1\写数据库
foreach (PeriodDetail_101 pp in AListPeriod)
{
DataRow drCurrent = objDataSet.Tables[0].Select(string.Format("C001={0}", pp.LongPeriod_001)).Count() > 0 ? objDataSet.Tables[0].Select(string.Format("C001={0}", pp.LongPeriod_001)).First() : null;
if (drCurrent != null) //更新
{
drCurrent.BeginEdit();
drCurrent["C002"] = pp.AwardNumber_002;
drCurrent["C050"] = pp.Wei5_050;
drCurrent["C040"] = pp.Wei4_040;
drCurrent["C030"] = pp.Wei3_030;
drCurrent["C020"] = pp.Wei2_020;
drCurrent["C010"] = pp.Wei1_010;
drCurrent["C003"] = pp.DateTimeInsert_003.ToString("yyyy/MM/dd HH:mm:ss");
drCurrent["C004"] = pp.DateNumber_004;
drCurrent["C005"] = pp.ShortPeriod_005;
drCurrent["C006"] = pp.DayInWeek_006;
drCurrent["C007"] = pp.BigOrSmall_007;
drCurrent["C008"] = pp.EvenODD_008;
drCurrent["C009"] = pp.AllSub_009;
drCurrent["C106"] = pp.CountBig_106;
drCurrent["C107"] = pp.CountSmall_107;
drCurrent["C108"] = pp.CountEven_108;
drCurrent["C109"] = pp.CountOdd_109;
drCurrent.EndEdit();
}
else //添加新行
{
DataRow drNewRow = objDataSet.Tables[0].NewRow();
drNewRow["C001"] = pp.LongPeriod_001;
drNewRow["C002"] = pp.AwardNumber_002;
drNewRow["C050"] = pp.Wei5_050;
drNewRow["C040"] = pp.Wei4_040;
drNewRow["C030"] = pp.Wei3_030;
drNewRow["C020"] = pp.Wei2_020;
drNewRow["C010"] = pp.Wei1_010;
drNewRow["C003"] = pp.DateTimeInsert_003.ToString("yyyy/MM/dd HH:mm:ss");
drNewRow["C004"] = pp.DateNumber_004;
drNewRow["C005"] = pp.ShortPeriod_005;
drNewRow["C006"] = pp.DayInWeek_006;
drNewRow["C007"] = pp.BigOrSmall_007;
drNewRow["C008"] = pp.EvenODD_008;
drNewRow["C009"] = pp.AllSub_009;
drNewRow["C106"] = pp.CountBig_106;
drNewRow["C107"] = pp.CountSmall_107;
drNewRow["C108"] = pp.CountEven_108;
drNewRow["C109"] = pp.CountOdd_109;
objDataSet.Tables[0].Rows.Add(drNewRow);
}
}
objAdapter.Update(objDataSet);
objDataSet.AcceptChanges();
}
catch (Exception e)
{
FileLog.WriteError("AutoShishiCaiDataGet() ", e.Message);
Thread.Sleep(5 * 60 * 1);
return(flag = false);
}
return(flag);
}
