/// <summary>
/// �ϴ��ɼ�
/// </summary>
/// <returns></returns>
public int UploadSKRecs()
{
DataSet SKEptRecs = new DataSet();
Access SKDB = new Access();
//��ˢ�����ϴ�
SKDB.AddTableInDataSet(SKEptRecs, "SKRecs", "select * from SKRecs where IsToRemote=false order by id");
//if (SKWS.SetSKRecs(SKEptRecs))
if (einterface.SetSKRecs(SKEptRecs))
{
int RecsNum = SKEptRecs.Tables["SKRecs"].Rows.Count;
string UpdateRecIDs = "";
StateBar.Visible = true;
StateBar.Step = 1;
StateBar.Maximum = RecsNum;
ShowActionInfo(string.Format("�ϴ�ˢ����¼��{0}", RecsNum));
for (int i = 0; i < RecsNum; i++)
{
DataRow SKRec = SKEptRecs.Tables["SKRecs"].Rows[i];
UpdateRecIDs += (UpdateRecIDs == "" ? "" : ",") + SKRec["ID"].ToString();
StateBar.Value = i;
}
if (UpdateRecIDs != "")
SKDB.ExecuteSQL(string.Format("update SKRecs set IsToRemote=true where ID in ({0})", UpdateRecIDs));
StateBar.Visible = false;
StateBar.Value = 0;
ShowActionInfo("");
return RecsNum;
}
else return 0;
}
public void TestModeSK()
{
Access SKDB=new Access();
OleDbDataReader TmpReader=SKDB.ExecuteQuery("select count(*) from lawyers");
int LawyerCnt;
while(true)
{
TmpReader.Read();
LawyerCnt= Convert.ToInt32(TmpReader.GetValue(0).ToString());
TmpReader.Close();
Logger.LogInfo("SKProcess��ϵͳ������" + LawyerCnt + "����ʦ");
if (LawyerCnt > 0)
{
break;
}
Thread.Sleep(10000);
}
Random rm=new Random();
while(true)
{
int TMBH=rm.Next(1,LawyerCnt);
DateTime DT=DateTime.Now;
DataSet RMRecs=new DataSet();
Access AccessDB=new Access();
AccessDB.AddTableInDataSet(RMRecs,"Recs",string.Format("select top {0} bh from lawyers order by bh",TMBH));
string sql = string.Format("insert into yskq(bh,rq,sj,SKMode) values({0},'{1}','{2}','ģ��')",
RMRecs.Tables["Recs"].Rows[TMBH - 1][0].ToString(),
DT.ToString("yyyy-MM-dd"),
DT.ToString("HH-mm-ss"));
// System.Windows.Forms.MessageBox.Show(sql);
SKDB.ExecuteSQL(sql);
Thread.Sleep(2000);
}
/* public void TestModeSK()
{
Access SKDB=new Access();
OleDbDataReader TmpReader=SKDB.ExecuteQuery("select min(bh) ,max(bh) from lawyers");
while (!TmpReader.HasRows)
{
TmpReader=SKDB.ExecuteQuery("select min(bh) ,max(bh) from lawyers");
}
TmpReader.Read();
int MinBH= Convert.ToInt32(TmpReader.GetValue(0).ToString()),MaxBH= Convert.ToInt32(TmpReader.GetValue(1).ToString());
TmpReader.Close();
Random rm=new Random();
while(true)
{
int TMBH=rm.Next(MinBH,MaxBH);
DateTime DT=DateTime.Now;
SKDB.ExecuteSQL(string.Format("insert into yskq(bh,rq,sj) values({0},'{1}','{2}')",TMBH,DT.ToString("yyyy-MM-dd"),DT.ToString("HH-mm-ss")));
Thread.Sleep(6000);
}
*/
}
