public FormJobMainView(JobMain job,String keyName)
: this()
{
_keyName = keyName;
_Job = job;
InitView();
}
public static int JobInsert(JobMain job)
{
int needCheckcount = Int32.Parse(DataAccess.ExecuteScalar("select count(*) from DictSpecs").ToString());
String sqlstring = String.Format(@"Insert into JobMain(jobdate,userid,begintime,isUploaded,NeedCheckPosition,CheckPosition,PassPosition)
Values(getdate(),{0},getdate(),0,{1},0,0)", job.UserID, needCheckcount);
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 JobMain Create(Int32 id)
{
JobMain result;
if (id == 0)
{
result = new JobMain();
result.UserID = AppHelper.UserID;
result.ID= SaveJob(result);
}
else
result = FindJobMain(id);
return result;
}
public FormCheck(JobMain job) : this()
{
CurrentJob = job;
if (job.Items.Count > 0)
{
Int32 specsid = job.Items.Max(jobdetail => jobdetail.SpecsID);
Specs spec = DbFactory.FindByFilter("ID=" + specsid.ToString());
if (spec != null)
{
CurrentSpecs = spec;
InitView();
}
}
}
public FormCheck(JobMain job)
: this()
{
CurrentJob = job;
if (job.Items.Count > 0)
{
Int32 specsid = job.Items.Max(jobdetail => jobdetail.SpecsID);
Specs spec = DbFactory.FindByFilter("ID=" + specsid.ToString());
if (spec != null)
{
CurrentSpecs = spec;
InitView();
}
}
}
public FormCheck(JobMain job) : this()
{
CurrentJob = job;
if (job.Items.Count > 0)
{
//Int32 specsid = job.Items.Max(jobdetail => jobdetail.SpecsID);
//Specs spec = DbFactory.FindByFilter("ID=" + specsid.ToString(),job.IsFull);
//if (spec != null)
//{
// CurrentSpecs = spec;
// InitView();
//}
}
//this.EnableScaner();
}
public static JobMain Create(Int32 id)
{
JobMain result;
if (id == 0)
{
result = new JobMain();
result.UserID = AppHelper.UserID;
result.ID = SaveJob(result);
}
else
{
result = FindJobMain(id);
}
return(result);
}
public FormCheck(JobMain job)
: this()
{
CurrentJob = job;
if (job.Items.Count > 0)
{
//Int32 specsid = job.Items.Max(jobdetail => jobdetail.SpecsID);
//Specs spec = DbFactory.FindByFilter("ID=" + specsid.ToString(),job.IsFull);
//if (spec != null)
//{
// CurrentSpecs = spec;
// InitView();
//}
}
//this.EnableScaner();
}
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 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 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 FormJobMainView(JobMain job, String keyName) : this()
{
_keyName = keyName;
_Job = job;
InitView();
}
public static JobMain FindToDayJob()
{
JobMain result = FindJobMainBySQL(String.Format("select * from jobmain where NeedCheckPosition>CheckPosition and isuploaded=0 and Userid={0} and dateDiff(Day,jobDate,getdate())=0", AppHelper.UserID));
return(result);
}
public FormJobMainView(JobMain job)
: this()
{
_Job = job;
InitView();
}
public FormJobMainView(JobMain job) : this()
{
_Job = job;
InitView();
}
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 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 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;
}
}