{

public class JobMain

{

public Int32 ID { get; set; }

public DateTime JobDate { get; set; }

public Int32 UserID { get; set; }

public DateTime BeginTime { get; set; }

public DateTime EndTime { get; set; }

public String IpAddress { get; set; }

public Boolean IsUploaded { get; set; }

public DateTime UploadDateTime { get; set; }

public Int32 NeedCheckPosition { get; set; }

public Int32 CheckPosition { get; set; }

public Int32 PassPosition { get; set; }

public bool IsFull { get; set; }

public String TrainCode { get; set; }

public List<JobDetail> _Items;

public List<JobDetail> Items

{

get

{

if (_Items == null)

_Items = new List<JobDetail>();

return _Items;

}

}

public JobDetail FindBySpecsID(int specsid)

{

foreach (JobDetail detail in Items)

{

if (detail.SpecsID == specsid)

return detail;

}

return null;

}

public void SetCheckToSpecs(Specs spec)

{

JobDetail detail = FindBySpecsID(spec.ID);

if (detail != null)

{

foreach (string kv in detail.CheckDetailList.Split(','))

{

String[] checkresults = kv.Split('=');

if (checkresults.Length == 2)

{

int spid = Int32.Parse(checkresults[0]);

String checkresult = checkresults[1].Trim();

bool ispass = checkresult.Substring(0, 1) == "1" ? true : false;

string note = "";

if (checkresult.Length > 2)

{

note = checkresult.Substring(2, checkresult.Length - 2);

}

SpecsDetail spdetail = spec.FindByID(spid);

if (spdetail != null)

{

spdetail.isChecked = ispass;

spdetail.isDone = true;

spdetail.Note = note;

}

}

}

spec.IsCheckAll = true;

detail.BarCode = spec.BarCode;

}

}

}

public class JobDetail

{

public Int32 ID { get; set; }

public Int32 JobID { get; set; }

public Int32 SpecsID { get; set; }

public DateTime CheckTime { get; set; }

public Boolean isChecked { get; set; }

public String CheckDetailList { get; set; }

public String BarCode { get; set; }

}

public class SpecsDetail

{

public Int32 ID { get; set; }

public Int32 SpecsID { get; set; }

public String CheckDetail { get; set; }

public String CheckMethod { get; set; }

public String SpecifiedSizeHeight { get; set; }

public String KnockPosition { get; set; }

public String Note { get; set; }

public bool IsFull { get; set; }

public bool isChecked { get; set; }

public bool isDone { get; set; }

public SpecsDetail()

{ }

public SpecsDetail(int id, int specsID, string checkdetail, string checkmethod, string sh, string knock, bool ischeck,bool isfull)

{

ID = id;

SpecsID = specsID;

CheckDetail = checkdetail;

SpecifiedSizeHeight = sh;

CheckMethod = checkmethod;

KnockPosition = knock;

isChecked= ischeck;

IsFull = isfull;

}

}

public class Specs

{

public Int32 ID { get; set; }

public String Seciton { get; set; }

public String CheckPosition { get; set; }

public String CheckMethod { get; set; }

public String BarCode { get; set; }

public Int32 Sequence { get; set; }

public bool IsFull { get; set; }

public Boolean IsCheckAll { get; set; }

private List<SpecsDetail> _items ;

public List<SpecsDetail> Items

{

get

{

if (_items == null)

_items = new List<SpecsDetail>();

return _items;

}

}

public SpecsDetail FindByID(int detailID)

{

SpecsDetail result = null;

foreach (SpecsDetail detail in Items)

{

if (detail.ID == detailID)

{

result = detail;

break;

}

}

return result;

//return Items.Single(detail => detail.ID == detailID);

}

public String CheckDetailList

{

get

{

return String.Join(",", Items.Select<SpecsDetail, String>(detail => string.Format("{0}={1}${2}", detail.ID, detail.isChecked ? 1 : 0,detail.Note)).ToArray());

}

}

}

public class DbFactory

{

public static Specs FindBySequence(int sequ,bool isFull)

{

return FindByFilter(String.Format("sequence={0}",sequ),isFull);

}

public static Specs Find(String barcode,Boolean isFull)

{

return FindByFilter(String.Format("ltrim(rtrim(barcode))='{0}'",barcode.Trim()),isFull);

}

public static Specs FindByFilter(String sFilter,Boolean isFull)

{

Specs result = new Specs();

using (IDataReader dr = DataAccess.ExecuteReader(String.Format("select * from DictSpecs where {0}", sFilter)))

{

if (dr.Read())

{

result.BarCode = (dr["barcode"]==DBNull.Value)?"":dr["barcode"].ToString();

result.ID = Int32.Parse(dr["ID"].ToString());

result.Sequence = Int32.Parse(dr["Sequence"].ToString());

result.Seciton = dr["Section"].ToString();

result.CheckPosition = dr["CheckPosition"].ToString();

result.CheckMethod = dr["CheckMethod"].ToString();

result.IsFull = (dr["IsFull"] == DBNull.Value) ? false : Boolean.Parse(dr["IsFull"].ToString());

dr.Close();

}

else

{

return null;

}

}

string sqlstring = String.Format("select * from DictSpecsItems where DictSpecsID={0}", result.ID);

if (isFull==false)

sqlstring = String.Format("select * from DictSpecsItems where DictSpecsID={0} and IsFull<>1", result.ID);

using (IDataReader dr = DataAccess.ExecuteReader(sqlstring))

{

while (dr.Read())

{

SpecsDetail detail = new SpecsDetail();

detail.ID=Int32.Parse(dr["id"].ToString());

detail.SpecsID=result.ID;

detail.SpecifiedSizeHeight=(dr["SpecifiedSizeHeight"] == DBNull.Value) ? "" : dr["SpecifiedSizeHeight"].ToString();

detail.CheckDetail=dr["CheckDetail"].ToString();

detail.CheckMethod=(dr["CheckMethod"] == DBNull.Value) ? result.CheckMethod : dr["CheckMethod"].ToString();

detail.KnockPosition =(dr["KnockPosition"] == DBNull.Value) ? "" : dr["KnockPosition"].ToString();

detail.IsFull = (dr["IsFull"] == DBNull.Value) ? false : Boolean.Parse(dr["IsFull"].ToString());

result.Items.Add(detail);

}

}

return result;

}

public static bool SaveSpecs(Specs spec)

{

return false;

}

public static JobMain Create(Int32 id,bool isFull)

{

JobMain result;

if (id == 0)

{

result = new JobMain();

result.UserID = AppHelper.UserID;

result.IsFull = isFull;

result.ID= SaveJob(result);

}

else

result = FindJobMain(id);

return result;

}

public static JobMain FindJobMainBySQL(String sqlString)

{

JobMain result = new JobMain();

using (IDataReader dr = DataAccess.ExecuteReader(sqlString))

{

if (dr.Read())

{

result.ID = Int32.Parse(dr["ID"].ToString());

result.JobDate = DateTime.Parse(dr["JobDate"].ToString());

result.UserID = Int32.Parse(dr["UserID"].ToString());

result.BeginTime = DateTime.Parse(dr["beginTime"].ToString());

result.EndTime = (dr["EndTime"] == DBNull.Value) ? default(DateTime) : DateTime.Parse(dr["EndTime"].ToString());

result.IsUploaded = (dr["IsUploaded"] == DBNull.Value) ? false : Boolean.Parse(dr["isUploaded"].ToString());

result.NeedCheckPosition = (dr["NeedCheckPosition"] == DBNull.Value) ? 0 : Int32.Parse(dr["NeedCheckPosition"].ToString());

result.CheckPosition = (dr["CheckPosition"] == DBNull.Value) ? 0 : Int32.Parse(dr["CheckPosition"].ToString());

result.PassPosition = (dr["PassPosition"] == DBNull.Value) ? 0 : Int32.Parse(dr["PassPosition"].ToString());

result.IsFull = (dr["IsFull"] == DBNull.Value) ? false : Boolean.Parse(dr["IsFull"].ToString());

result.TrainCode = (dr["TrainCode"] == DBNull.Value) ? "" : dr["TrainCode"].ToString();

dr.Close();

}

else

return null;

}

using (IDataReader dr = DataAccess.ExecuteReader(String.Format("Select * from JobDetail where Jobid={0}", result.ID)))

{

while (dr.Read())

{

JobDetail item = new JobDetail();

item.ID = Int32.Parse(dr["ID"].ToString());

item.JobID = result.ID;

item.SpecsID = Int32.Parse(dr["SpecsID"].ToString());

item.CheckTime = (dr["CheckTime"] == DBNull.Value) ? default(DateTime) : DateTime.Parse(dr["CheckTime"].ToString());

item.isChecked = (dr["isChecked"] == DBNull.Value) ? false : Boolean.Parse(dr["isChecked"].ToString());

item.CheckDetailList = (dr["CheckDetailList"] == DBNull.Value) ? "" : dr["checkDetailList"].ToString();

item.BarCode = (dr["BarCode"] == DBNull.Value) ? "" : dr["BarCode"].ToString();

result.Items.Add(item);

}

dr.Close();

}

return result;

}

public static JobMain FindJobMain(Int32 id)

{

return FindJobMainBySQL(String.Format("select * from jobMain where ID={0}", id));

}

public static int JobInsert(JobMain job)

{

string sqlstring = "select count(*) from DictSpecs";

if (job.IsFull == false)

sqlstring = "select count(*) from DictSpecs where isFull<>1";

int needCheckcount = Int32.Parse(DataAccess.ExecuteScalar(sqlstring).ToString());

sqlstring = String.Format(@"Insert into JobMain(jobdate,userid,begintime,isUploaded,NeedCheckPosition,CheckPosition,PassPosition,IsFull)

Values(getdate(),{0},getdate(),0,{1},0,0,{2})", job.UserID,needCheckcount,job.IsFull?1:0);

DataAccess.ExecuteNonQuery(sqlstring);

int result = Int32.Parse(DataAccess.ExecuteScalar("Select max(id) from jobmain").ToString());

job.ID = result;

job.NeedCheckPosition = needCheckcount;

return result;

}

public static int JobDetailUpdate(JobDetail detail)

{

return DataAccess.ExecuteNonQuery(String.Format(@"Update jobDetail set ischecked={0},checkTime='{1}',checkDetailList=

'{2}',BarCode='{5}' where jobid={3} and specsID={4} ",

detail.isChecked ? 1 : 0,

detail.CheckTime,

detail.CheckDetailList,

detail.JobID,

detail.SpecsID,

detail.BarCode));

}

public static int JobDetailInsert(JobDetail detail)

{

String sqlstring = string.Format(@"Insert into jobDetail (jobid,specsID,checkTime,ischecked,checkdetailList,barCode)

Values({0},{1},'{2}',{3},'{4}','{5}') ",

detail.JobID,

detail.SpecsID,

detail.CheckTime,

detail.isChecked ? 1 : 0,

detail.CheckDetailList,

detail.BarCode);

DataAccess.ExecuteNonQuery(sqlstring);

int result = Int32.Parse(DataAccess.ExecuteScalar("select max(id) from jobdetail").ToString());

int checkP = Int32.Parse(DataAccess.ExecuteScalar(String.Format("select count(*) from jobdetail where jobid={0}",detail.JobID)).ToString());

sqlstring = String.Format("Update JobMain set CheckPosition={1} where id={0}", detail.JobID, checkP);

if (detail.isChecked)

sqlstring = String.Format("Update JobMain set CheckPosition={1},PassPosition=PassPosition+1 where id={0}", detail.JobID, checkP);

DataAccess.ExecuteNonQuery(sqlstring);

return result;

}

public static int SaveJob(JobMain job)

{

StringBuilder sqlList = new StringBuilder();

if (job.ID == 0)

{

int result = JobInsert(job);

return result;

}

else

{

foreach (JobDetail detail in job.Items)

{

if (detail.ID > 0)

sqlList.AppendFormat(@"Update jobDetail set ischecked={0},checkTime='{1}',checkDetailList=

'{2}' where jobid={3} and specsID={4} ",

detail.isChecked ? 1 : 0,

detail.CheckTime,

detail.CheckDetailList,

detail.JobID,

detail.SpecsID);

else

sqlList.AppendFormat(@"Insert into jobDetail (jobid,specsID,checkTime,ischecked,checkdetailList)

Values({0},{1},'{2}',{3},'{4}','{5}') ",

job.ID,

detail.SpecsID,

detail.CheckTime,

detail.isChecked ? 1 : 0,

detail.CheckDetailList,

detail.BarCode);

DataAccess.ExecuteNonQuery(sqlList.ToString());

}

return 1;

}

}

public static JobMain FindToDayJob(bool isfull)

{

JobMain result = FindJobMainBySQL(String.Format("select * from jobmain where NeedCheckPosition>CheckPosition and isuploaded=0 and Userid={0} and dateDiff(Day,jobDate,getdate())=0 and isfull={1}",

AppHelper.UserID,isfull?1:0));

return result;

}

public static bool DeleteJobMain(JobMain job)

{

int result = DataAccess.ExecuteNonQuery(String.Format("delete from jobdetail where jobid={0}", job.ID));

result = DataAccess.ExecuteNonQuery(String.Format("delete from jobmain where id={0}", job.ID));

return result > 0;

}

public static bool UpdateSpecsBarCode(Specs spec, String barcode)

{

int result = DataAccess.ExecuteNonQuery(String.Format("Update DictSpecs set barcode='{0}' where id={1}", barcode, spec.ID));

return result == 1;

}

}