/// <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()); } }