private bool InsertJob(MODEL.Criteria.job job, List <MODEL.Criteria.jobDetail> lstJobDetail)
{
BLL.job _BLL = new BLL.job();
int ret;
ret = _BLL.Insert_Job(job);
if (ret == 1)
{
int k;
k = lstJobDetail.Count();
for (int i = 0; i < k; i++)
{
MODEL.Criteria.jobDetail jdt = new MODEL.Criteria.jobDetail();
jdt = (MODEL.Criteria.jobDetail)lstJobDetail[i];
jdt.job_id = job.job_id;
jdt.job_name = job.job_name;
_BLL.Insert_JobDetail(jdt);
}
}
return(true);
}
public List <MODEL.jobDetail> getJobDetail(MODEL.Criteria.jobDetail criteria)
{
DataSet ds = new DataSet();
String sql;
sql = "Select * From job_detail where show_=1";
Class.clsDB db = new Class.clsDB();
ds = db.ExecuteDataSet(sql);
db.Close();
return(ds.Tables[0].AsEnumerable().Select(s => new MODEL.jobDetail
{
job_id = s.Field <string>("job_id"),
//place_get_job = s.Field<string>("place_get_job"),
//container_type = s.Field<string>("container_type"),
//container_dim = s.Field<string>("container_dim"),
}).ToList());
}
public int Insert_JobDetail(MODEL.Criteria.jobDetail criteria)
{
try
{
Class.clsDB db = new Class.clsDB();
string sql;
sql = "Insert into job_trailer_detail ( ";
sql += "job_id,";
sql += "job_name,";
sql += "place_get_job ,";
sql += "container_type,";
sql += "container_dim,";
sql += "cust_dest,";
sql += "code_name ,";
sql += "appointed_time,";
sql += "doc_no,";
sql += "place_send_job,";
sql += "send_company,";
sql += "place_type,";
sql += "remark) VALUES('";
sql += criteria.job_id + "',";
sql += "'" + criteria.job_name + "',";
sql += "'" + criteria.place_get_job + "',";
sql += "'" + criteria.container_type + "',";
sql += "'" + criteria.container_dim + "',";
sql += "'" + criteria.cust_dest + "',";
sql += "'" + criteria.code_name + "',";
sql += "'" + criteria.appointed_time + "',";
sql += "'" + criteria.doc_no + "',";
sql += "'" + criteria.place_send_job + "',";
sql += "'" + criteria.send_company + "',";
sql += "'" + criteria.place_type + "',";
sql += "'" + criteria.remark + "')";
int ret;
ret = db.ExecuteNonQuery(sql);
db.Close();
return(ret);
}
catch (Exception ex)
{
return(0);
}
}
public int Insert_JobDetail(MODEL.Criteria.jobDetail criteria)
{
return(_DAL.Insert_JobDetail(criteria));
}
