public void UpLoadJob()
{
using (IDataReader dr = DataAccess.ExecuteReader("select * from jobMain where isUploaded=0"))
{
while (dr.Read())
{
String jobdate = dr["jobDate"].ToString();
Int32 userid = Int32.Parse(dr["UserID"].ToString());
string begintime = dr["BeginTime"] == DBNull.Value ? "" : dr["BeginTime"].ToString();
string endtime = dr["EndTime"] == DBNull.Value ? "" : dr["EndTime"].ToString();
string ipAddress = dr["ipAddress"] == DBNull.Value ? "" : dr["ipAddress"].ToString();
Int32 needcheckposition = dr["NeedCheckPosition"] == DBNull.Value ? 0 : Int32.Parse(dr["NeedCheckPosition"].ToString());
Int32 CheckPosition = dr["CheckPosition"] == DBNull.Value ? 0 : Int32.Parse(dr["CheckPosition"].ToString());
Int32 PassPosition = dr["PassPosition"] == DBNull.Value ? 0 : Int32.Parse(dr["PassPosition"].ToString());
Int32 id = Int32.Parse(dr["ID"].ToString());
List <String> list = new List <string>();
using (IDataReader detaildr = DataAccess.ExecuteReader("select * from JobDetail where jobid=" + id.ToString()))
{
while (detaildr.Read())
{
list.Add(string.Format("{0}|{1}|{2}",
detaildr["SpecsID"].ToString(),
detaildr["CheckTime"].ToString(),
detaildr["CheckDetailList"].ToString()));
}
detaildr.Close();
}
string childlist = string.Join("@", list.ToArray());
_Service.UploadJob(jobdate, userid, begintime, endtime, ipAddress, needcheckposition, CheckPosition, PassPosition, childlist);
}
dr.Close();
}
}
public void UpLoadJob()
{
List <int> successList = new List <int>();
try
{
using (IDataReader dr = DataAccess.ExecuteReader("select * from jobMain where isUploaded=0"))
{
int id = 0;
while (dr.Read())
{
String jobdate = dr["jobDate"].ToString();
Int32 userid = Int32.Parse(dr["UserID"].ToString());
string begintime = dr["BeginTime"] == DBNull.Value ? "" : dr["BeginTime"].ToString();
string endtime = dr["EndTime"] == DBNull.Value ? "" : dr["EndTime"].ToString();
string ipAddress = dr["ipAddress"] == DBNull.Value ? "" : dr["ipAddress"].ToString();
Int32 needcheckposition = dr["NeedCheckPosition"] == DBNull.Value ? 0 : Int32.Parse(dr["NeedCheckPosition"].ToString());
Int32 CheckPosition = dr["CheckPosition"] == DBNull.Value ? 0 : Int32.Parse(dr["CheckPosition"].ToString());
Int32 PassPosition = dr["PassPosition"] == DBNull.Value ? 0 : Int32.Parse(dr["PassPosition"].ToString());
id = Int32.Parse(dr["ID"].ToString());
String isfull = (dr["IsFull"] != DBNull.Value) ? dr["IsFull"].ToString() : "0";
string TrainCode = (dr["TrainCode"] == DBNull.Value) ? "" : dr["TrainCode"].ToString();
List <String> list = new List <string>();
using (IDataReader detaildr = DataAccess.ExecuteReader("select * from JobDetail where jobid=" + id.ToString()))
{
while (detaildr.Read())
{
list.Add(string.Format("{0}|{1}|{2}|{3}",
detaildr["SpecsID"].ToString(),
detaildr["CheckTime"].ToString(),
detaildr["CheckDetailList"].ToString(),
detaildr["BarCode"].ToString()));
if (detaildr["BarCode"] != DBNull.Value)
{
TrainCode = detaildr["BarCode"].ToString().Trim();
}
}
detaildr.Close();
}
string childlist = string.Join("@", list.ToArray());
if (TrainCode.Length == AppHelper.BarCodeDim)
{
TrainCode = TrainCode.Substring(4, 3);
}
_Service.UploadJob(jobdate, userid, begintime, endtime, ipAddress, needcheckposition, CheckPosition, PassPosition, childlist, isfull == "1" ? true : false, TrainCode);
successList.Add(id);
}
dr.Close();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (successList.Count > 0)
{
DataAccess.ExecuteNonQuery(String.Format("Delete from jobmain where id in ({0})", String.Join(",", successList.Select(jid => jid.ToString()).ToArray())));
DataAccess.ExecuteNonQuery(String.Format("Delete from jobDetail where jobid in ({0})", String.Join(",", successList.Select(jid => jid.ToString()).ToArray())));
}
}
}
