/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Hownet.Model.DepartmentTaskMain model)
{
dal.Update(model);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <Hownet.Model.DepartmentTaskMain> DataTableToList(DataTable dt)
{
List <Hownet.Model.DepartmentTaskMain> modelList = new List <Hownet.Model.DepartmentTaskMain>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Hownet.Model.DepartmentTaskMain model;
for (int n = 0; n < rowsCount; n++)
{
model = new Hownet.Model.DepartmentTaskMain();
if (dt.Rows[n]["ID"].ToString() != "")
{
model.ID = int.Parse(dt.Rows[n]["ID"].ToString());
}
else
{
model.ID = 0;
}
if (dt.Rows[n]["DepartmentID"].ToString() != "")
{
model.DepartmentID = int.Parse(dt.Rows[n]["DepartmentID"].ToString());
}
else
{
model.DepartmentID = 0;
}
if (dt.Rows[n]["TaskID"].ToString() != "")
{
model.TaskID = int.Parse(dt.Rows[n]["TaskID"].ToString());
}
else
{
model.TaskID = 0;
}
if (dt.Rows[n]["DateTime"].ToString() != "")
{
model.DateTime = DateTime.Parse(dt.Rows[n]["DateTime"].ToString());
}
else
{
model.DateTime = DateTime.Parse("1900-1-1");
}
if (dt.Rows[n]["LastDate"].ToString() != "")
{
model.LastDate = DateTime.Parse(dt.Rows[n]["LastDate"].ToString());
}
else
{
model.LastDate = DateTime.Parse("1900-1-1");
}
model.Remark = dt.Rows[n]["Remark"].ToString();
if (dt.Rows[n]["Num"].ToString() != "")
{
model.Num = int.Parse(dt.Rows[n]["Num"].ToString());
}
else
{
model.Num = 0;
}
if (dt.Rows[n]["IsEnd"].ToString() != "")
{
model.IsEnd = int.Parse(dt.Rows[n]["IsEnd"].ToString());
}
else
{
model.IsEnd = 0;
}
if (dt.Rows[n]["PWID"].ToString() != "")
{
model.PWID = int.Parse(dt.Rows[n]["PWID"].ToString());
}
else
{
model.PWID = 0;
}
model.A = int.Parse(dt.Rows[n]["A"].ToString());
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Hownet.Model.DepartmentTaskMain model)
{
return(dal.Add(model));
}
/// <summary>
/// 用于显示工序执行情况
/// </summary>
/// <param name="TaskID">生产单ID</param>
/// <returns></returns>
public DataSet GetWorkListByPW(int TaskID, int PWMID, int MaterielID, int TaskDepID)
{
try
{
Hownet.BLL.WorkTicket bllWT = new WorkTicket();
Hownet.BLL.ProductWorkingInfo bllPWI = new ProductWorkingInfo();
DataSet ds = new DataSet();
//if (TaskDepID == 0)
ds = dal.GetWorkListByPW(TaskID);
//else
//ds = dal.GetDepWorkListByPW(TaskDepID);
if (ds.Tables[0].Rows.Count > 0)
{
ds.Tables[0].Columns.Add("EmpDate", typeof(string));
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (ds.Tables[0].Rows[i]["DateTime"].ToString() != "" && (DateTime)(ds.Tables[0].Rows[i]["DateTime"]) != DateTime.Parse("1900-1-1"))
{
ds.Tables[0].Rows[i]["EmpDate"] = ds.Tables[0].Rows[i]["EmployeeName"].ToString() + "/" + ((DateTime)(ds.Tables[0].Rows[i]["DateTime"])).ToString();
}
else
{
ds.Tables[0].Rows[i]["EmpDate"] = " ";
}
}
}
DataTable dtPWI = new DataTable();
if (TaskDepID == 0)
{
dtPWI = bllPWI.GetProWorkListByPW(PWMID, MaterielID).Tables[0];
}
else
{
Hownet.BLL.DepartmentTaskMain bllDTM = new DepartmentTaskMain();
Hownet.Model.DepartmentTaskMain modDtm = bllDTM.GetModel(TaskDepID);
dtPWI = bllPWI.GetProWorkListByPW(modDtm.PWID, MaterielID).Tables[0];
}
DataTable dt = bllWT.GetWorkList(TaskID, TaskDepID).Tables[0].Copy();
if (dtPWI.Rows.Count > 0)
{
for (int i = 0; i < dtPWI.Rows.Count; i++)
{
try
{
dt.Columns.Add(dtPWI.Rows[i]["WorkingName"].ToString(), typeof(string));
for (int j = 0; j < dt.Rows.Count; j++)
{
object box = dt.Rows[j]["箱号"];
object wor = dtPWI.Rows[i]["ID"];
DataRow[] drs = ds.Tables[0].Select("(MainID=" + dt.Rows[j]["ID"] + ") And (WorkingID=" + dtPWI.Rows[i]["WorkingID"] + ")");
if (drs.Length > 0)
{
object obj = drs[0]["EmpDate"];
dt.Rows[j][dtPWI.Rows[i]["WorkingName"].ToString()] = drs[0]["EmpDate"];
}
}
}
catch
{
}
}
}
DataSet dsss = new DataSet();
dsss.Tables.Add(dt);
return(dsss);
}
catch (Exception ex)
{
return(new DataSet());
}
}
