/// <summary> /// 获得数据列表 /// </summary> public List <E_tb_ExpePlan> DataTableToList(DataTable dt) { List <E_tb_ExpePlan> modelList = new List <E_tb_ExpePlan>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { E_tb_ExpePlan model; for (int n = 0; n < rowsCount; n++) { model = new E_tb_ExpePlan(); if (dt.Rows[n]["PlanID"].ToString() != "") { model.PlanID = int.Parse(dt.Rows[n]["PlanID"].ToString()); } if (dt.Rows[n]["PlanTypeID"].ToString() != "") { model.PlanTypeID = int.Parse(dt.Rows[n]["PlanTypeID"].ToString()); } if (dt.Rows[n]["ProjectID"].ToString() != "") { model.ProjectID = int.Parse(dt.Rows[n]["ProjectID"].ToString()); } if (dt.Rows[n]["SampleID"].ToString() != "") { model.SampleID = int.Parse(dt.Rows[n]["SampleID"].ToString()); } if (dt.Rows[n]["InspectTime"].ToString() != "") { model.InspectTime = DateTime.Parse(dt.Rows[n]["InspectTime"].ToString()); } model.InspectPlace = dt.Rows[n]["InspectPlace"].ToString(); model.InspectMethod = dt.Rows[n]["InspectMethod"].ToString(); if (dt.Rows[n]["HeadPersonnelID"].ToString() != "") { model.HeadPersonnelID = int.Parse(dt.Rows[n]["HeadPersonnelID"].ToString()); } model.TaskNo = dt.Rows[n]["TaskNo"].ToString(); if (dt.Rows[n]["Status"].ToString() != "") { model.Status = int.Parse(dt.Rows[n]["Status"].ToString()); } model.Remark = dt.Rows[n]["Remark"].ToString(); if (dt.Rows[n]["AreaID"].ToString() != "") { model.AreaID = int.Parse(dt.Rows[n]["AreaID"].ToString()); } if (dt.Rows[n]["EditPersonnelID"].ToString() != "") { model.EditPersonnelID = int.Parse(dt.Rows[n]["EditPersonnelID"].ToString()); } if (dt.Rows[n]["UpdateTime"].ToString() != "") { model.UpdateTime = DateTime.Parse(dt.Rows[n]["UpdateTime"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 保存实验室信息 /// 作者:小朱 /// </summary> /// <param name="eExpePlan">要处理的对象</param> /// <returns>返回是否处理成功</returns> public JsonResult Save(E_tb_ExpePlan eExpePlan) { string msg = ""; bool result = false; eExpePlan.UpdateTime = DateTime.Now; eExpePlan.EditPersonnelID = CurrentUserInfo.PersonnelID; eExpePlan.AreaID = CurrentUserInfo.AreaID; if (eExpePlan.EditType == "Add") { eExpePlan.Status = 2;//2:未完成 if (tExpePlan.IsExistsTaskNo(eExpePlan.TaskNo) > 0) { msg = "任务单号已存在!"; } else { tExpePlan.Add(eExpePlan); msg = "添加成功"; result = true; } } else { tExpePlan.Update(eExpePlan); msg = "修改成功"; result = true; } return(Json(new { result = result, msg = msg })); }
public JsonResult AddExpePlan(E_tb_ExpePlan eExpePlan) { E_tb_Project eProject = tProject.GetModel((int)eExpePlan.ProjectID); eExpePlan.InspectMethod = eProject.ExpeMethod; eExpePlan.PlanTypeID = 1;//默认为计划内 eExpePlan.HeadPersonnelID = CurrentUserInfo.PersonnelID; eExpePlan.TaskNo = CreateTaskNoList(eExpePlan.ProjectID.ToString(), eExpePlan.SampleID.ToString()); eExpePlan.Status = 2; eExpePlan.AreaID = CurrentUserInfo.AreaID; eExpePlan.EditPersonnelID = CurrentUserInfo.PersonnelID; eExpePlan.UpdateTime = DateTime.Now; eExpePlan.InspectPlace = tArea.GetModel((int)CurrentUserInfo.AreaID).AreaName; string str = ""; int ExpePlanID = 0; if (tExpePlan.IsExistsTaskNo(eExpePlan.TaskNo) > 0) { str = "任务单号重复!"; } else { ExpePlanID = tExpePlan.Add(eExpePlan); str = ExpePlanID > 0 ? "OK" : "添加失败!"; } return(Json(new { msg = str, id = ExpePlanID }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 获取符合要求的样品详情 /// </summary> /// <param name="model">查询实体</param> /// <returns>返回对应实体信息</returns> public E_tb_ExpePlan GetExpePlanInfo(E_tb_ExpePlan model) { StringBuilder strWhere = new StringBuilder(); if (model.SampleID > 0) //样品ID { strWhere.AddWhere($"SampleID={model.SampleID}"); } if (model.ProjectID > 0) //项目ID { strWhere.AddWhere($"ProjectID={model.ProjectID}"); } if (!string.IsNullOrEmpty(model.TaskNo)) //样品编号 { strWhere.AddWhere($"TaskNo='{model.TaskNo}'"); } StringBuilder strSql = new StringBuilder(); strSql.Append($@"select top 1 * from tb_ExpePlan {strWhere.ToString()}"); using (IDbConnection conn = new SqlConnection(PubConstant.GetConnectionString())) { model = conn.Query <E_tb_ExpePlan>(strSql.ToString(), model)?.FirstOrDefault(); } return(model); }
/// <summary> /// 显示详情页 /// </summary> /// <param name="EditType">编辑类型</param> /// <returns>返回编辑结果</returns> public ActionResult ExpePlanEdit(E_tb_ExpePlan eExpePlan, string EditType, int?InfoID) { ViewData["PlanTypeList"] = this.GetPlanTypeList(false); ViewData["ProjectList"] = PageTools.GetSelectList(tProject.GetList("").Tables[0], "ProjectID", "ProjectName", false); ViewData["PersonnelList"] = PageTools.GetSelectList(tInPersonnel.GetList(" AreaID=" + CurrentUserInfo.AreaID.ToString()).Tables[0], "PersonnelID", "PersonnelName", false); //ViewData["SampleList"] = PageTools.GetSelectList(tSample.GetList(" (handleUser='' or handleUser is null) order by id ").Tables[0], "id", "name", false); ViewBag.PersonnelID = CurrentUserInfo.PersonnelID; ViewBag.AreaAddr = tArea.GetModel(int.Parse(CurrentUserInfo.AreaID.ToString())).AreaName; ViewBag.SampleID = 0; ViewBag.ProjectID = 0; if (EditType == "Edit") { eExpePlan = tExpePlan.GetModel(Convert.ToInt32(InfoID)); ViewBag.SampleID = eExpePlan.SampleID; ViewBag.ProjectID = eExpePlan.ProjectID; } //默认获取前200条数据,避免因option过多导致加载过慢 List <tb_Sample> SampleList = _dSample.GetModelList(400, "id,name", " where handleUser=0", eExpePlan.SampleID != null ? Convert.ToInt32(eExpePlan.SampleID) : 0); ViewData["SampleList"] = SampleList; eExpePlan.EditType = EditType; return(View(eExpePlan)); }
/// <summary> /// 生成原始记录 /// </summary> /// <param name="PlanID">实验计划ID</param> /// <returns>返回生成结果</returns> public JsonResult CreateOriginalRecord(int PlanID) { E_tb_ExpePlan eExpePlan = _dExpePlan.GetModel(PlanID); E_tb_Project eProject = _dProject.GetModel(Convert.ToInt32(eExpePlan.ProjectID)); //定义原始记录实体 E_tb_OriginalRecord eOriginalRecord = new E_tb_OriginalRecord(); eOriginalRecord.ProjectID = eExpePlan.ProjectID; eOriginalRecord.TaskNo = eExpePlan.TaskNo; eOriginalRecord.DetectTime = eExpePlan.InspectTime; eOriginalRecord.DetectPersonnelID = CurrentUserInfo.PersonnelID; //提前给定最终文件保存名称 eOriginalRecord.FilePath = "OriginalRecordFile/LIMS" + DateTime.Now.ToString("yyyyMMddhhmmss") + "." + eProject.FilePath.Split('.')[1]; eOriginalRecord.Contents = ""; eOriginalRecord.AreaID = CurrentUserInfo.AreaID; eOriginalRecord.EditPersonnelID = CurrentUserInfo.PersonnelID; eOriginalRecord.SampleID = eExpePlan.SampleID; //默认给第一个标准, 后续可修改 eOriginalRecord.InsStand = eProject.InsStand.Split('、')[0].ToString(); bool result = _dOriginalRecord.Add(eOriginalRecord) > 0; return(Json(new { result = result, msg = "生成成功!" }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 保存实验室信息 /// 作者:小朱 /// </summary> /// <param name="eExpePlan">要处理的对象</param> /// <returns>返回是否处理成功</returns> public string Save(E_tb_ExpePlan eExpePlan) { string msg = "0"; eExpePlan.UpdateTime = DateTime.Now; eExpePlan.EditPersonnelID = CurrentUserInfo.PersonnelID; eExpePlan.AreaID = CurrentUserInfo.AreaID; if (eExpePlan.EditType == "Add") { eExpePlan.Status = 0; if (tExpePlan.IsExistsTaskNo(eExpePlan.TaskNo) > 0) { msg = "2"; } else { tExpePlan.Add(eExpePlan); msg = "1"; } } else { tExpePlan.Update(eExpePlan); msg = "1"; } return(msg); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(E_tb_ExpePlan model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_ExpePlan("); strSql.Append("PlanTypeID,ProjectID,SampleID,InspectTime,InspectPlace,InspectMethod,HeadPersonnelID,TaskNo,Status,Remark,AreaID,EditPersonnelID,UpdateTime)"); strSql.Append(" values ("); strSql.Append("@PlanTypeID,@ProjectID,@SampleID,@InspectTime,@InspectPlace,@InspectMethod,@HeadPersonnelID,@TaskNo,@Status,@Remark,@AreaID,@EditPersonnelID,@UpdateTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@PlanTypeID", SqlDbType.Int, 4), new SqlParameter("@ProjectID", SqlDbType.Int, 4), new SqlParameter("@SampleID", SqlDbType.Int, 4), new SqlParameter("@InspectTime", SqlDbType.DateTime), new SqlParameter("@InspectPlace", SqlDbType.NVarChar, 100), new SqlParameter("@InspectMethod", SqlDbType.NVarChar), new SqlParameter("@HeadPersonnelID", SqlDbType.Int, 4), new SqlParameter("@TaskNo", SqlDbType.NVarChar, 50), new SqlParameter("@Status", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.Text), new SqlParameter("@AreaID", SqlDbType.Int, 4), new SqlParameter("@EditPersonnelID", SqlDbType.Int, 4), new SqlParameter("@UpdateTime", SqlDbType.DateTime) }; parameters[0].Value = model.PlanTypeID; parameters[1].Value = model.ProjectID; parameters[2].Value = model.SampleID; parameters[3].Value = model.InspectTime; parameters[4].Value = model.InspectPlace; parameters[5].Value = model.InspectMethod; parameters[6].Value = model.HeadPersonnelID; parameters[7].Value = model.TaskNo; parameters[8].Value = model.Status; parameters[9].Value = model.Remark; parameters[10].Value = model.AreaID; parameters[11].Value = model.EditPersonnelID; parameters[12].Value = model.UpdateTime; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
// // GET: /DetectProject/ public ActionResult ExpePlanList(E_tb_ExpePlan eExpePlan) { ViewData["PlanTypeList"] = this.GetPlanTypeList(true); ViewData["ProjectList"] = PageTools.GetSelectList(tProject.GetList("").Tables[0], "ProjectID", "ProjectName", true); ViewData["AreaList"] = PageTools.GetSelectList(tArea.GetList("").Tables[0], "AreaID", "AreaName", true); if (Request["ApprovalPersonnelName"] != null) { ViewData["ApprovalPersonnelName"] = Request["ApprovalPersonnelName"].ToString(); } else { ViewData["ApprovalPersonnelName"] = ""; } ViewBag._userName = CurrentUserInfo.UserName; eExpePlan.AreaID = CurrentUserInfo.AreaID; ViewBag.IsDisabled = (CurrentUserInfo.RoleID != 1) ? "true" : "false"; //权限判断 return(View(eExpePlan)); }
/// <summary> /// 显示详情页 /// </summary> /// <param name="EditType">编辑类型</param> /// <returns>返回编辑结果</returns> public ActionResult ExpePlanEdit(E_tb_ExpePlan eExpePlan, string EditType, int?InfoID) { ViewData["PlanTypeList"] = this.GetPlanTypeList(false); ViewData["ProjectList"] = PageTools.GetSelectList(tProject.GetList("").Tables[0], "ProjectID", "ProjectName", false); ViewData["PersonnelList"] = PageTools.GetSelectList(tInPersonnel.GetList(" AreaID=" + CurrentUserInfo.AreaID.ToString()).Tables[0], "PersonnelID", "PersonnelName", false); ViewData["SampleList"] = PageTools.GetSelectList(tSample.GetList(" handleUser='' order by id ").Tables[0], "id", "name", false); ViewBag.PersonnelID = CurrentUserInfo.PersonnelID; ViewBag.AreaAddr = tArea.GetModel(int.Parse(CurrentUserInfo.AreaID.ToString())).AreaName; ViewBag.SampleID = 0; ViewBag.ProjectID = 0; if (EditType == "Edit") { eExpePlan = tExpePlan.GetModel(Convert.ToInt32(InfoID)); ViewBag.SampleID = eExpePlan.SampleID; ViewBag.ProjectID = eExpePlan.ProjectID; } eExpePlan.EditType = EditType; return(View(eExpePlan)); }
/// <summary> /// 获取实验计划列表 /// </summary> /// <param name="eExpePlan">查询实体</param> /// <returns>返回对应数据集合</returns> public List <E_tb_ExpePlan> GetExpePlanList(E_tb_ExpePlan eExpePlan) { List <E_tb_ExpePlan> list = new List <E_tb_ExpePlan>(); //拼接查询条件 StringBuilder strwhere = new StringBuilder(); if (eExpePlan.SampleID > 0) //样品ID { strwhere.AddWhere($"SampleID={eExpePlan.SampleID}"); } //主查询Sql StringBuilder search = new StringBuilder(); search.AppendFormat(@"select A.*,B.ProjectName from tb_ExpePlan as A left join tb_Project as B on A.ProjectID=B.ProjectID {0} ", strwhere.ToString()); //执行查询语句 using (IDbConnection conn = new SqlConnection(PubConstant.GetConnectionString())) { list = conn.Query <E_tb_ExpePlan>(search.ToString(), eExpePlan)?.ToList(); } return(list); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(E_tb_ExpePlan model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(E_tb_ExpePlan model) { return(dal.Add(model)); }
/// <summary> /// 更新检验报告 /// </summary> /// <param name="eOriginalRecord"></param> /// <param name="eExpePlan"></param> public JsonResult UpdateTestReport(int RecordID) { E_tb_OriginalRecord eOriginalRecord = _dOriginalRecord.GetModel(new E_tb_OriginalRecord() { RecordID = RecordID }); E_tb_ExpePlan eExpePlan = _dExpePlan.GetExpePlanInfo(new E_tb_ExpePlan() { TaskNo = eOriginalRecord.TaskNo }); tb_Sample eSample = tSample.GetModel(eOriginalRecord.SampleID.Value); string productNum = eSample.protNum;//产品批次 E_tb_TestReport eTestReport = null; var tempmodel = tTestReport.GetModelList(" A.SampleNum = '" + eSample.sampleNum + "'"); if (tempmodel != null && tempmodel.Count > 0) { eTestReport = tempmodel.First(); eTestReport.SampleNum = eSample.sampleNum; //样品编号 eTestReport.SampleName = eSample.name; //样品名称 } if (eTestReport == null) { eTestReport = new E_tb_TestReport(); eTestReport.productNum = productNum; //批次号 eTestReport.SampleNum = eSample.sampleNum; //样品编号 eTestReport.SampleName = eSample.name; //样品名称 eTestReport.ProductionTime = eSample.productDate; //生产日期 eTestReport.Specifications = eSample.modelType; //规格型号 eTestReport.ShelfLife = eSample.expirationDate; //保质期 string Department = "/"; if (eSample.isDetection) { Department = eSample.detectionCompany; } else { var client = new BLL.ClientManage.T_tb_ClientManage().GetModel(Convert.ToInt32(eSample.InspectCompany)); Department = (client != null ? client.ClientName : ""); } eTestReport.Department = Department; //送/抽检单位 eTestReport.SendTestAddress = eSample.InspectAddress; //送检单位地址 eTestReport.SamplingPlace = eSample.detectionAdress; //抽样地点 eTestReport.SamplingCompany = eSample.detectionCompany; //抽样单位 eTestReport.SamplingPersonnel = eSample.detectionUser; //抽样者 eTestReport.Packing = eSample.packaging; //包装形式 eTestReport.SamplingTime = eSample.detectionDate; //抽样日期 eTestReport.TestBasis = new BLL.Laboratory.T_tb_Project().GetModel(eOriginalRecord.ProjectID.Value).ExpeMethod; eTestReport.TestTime = eOriginalRecord.DetectTime; //检验日期 DataTable dt = tOriginalRecord.GetRecordIDListBySampleID(int.Parse(eExpePlan.SampleID.ToString())); string RecordIDS = ""; if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { RecordIDS += dt.Rows[i]["RecordID"].ToString() + ","; } RecordIDS = RecordIDS.TrimEnd(','); } eTestReport.RecordIDS = RecordIDS;//原始记录IDS DataTable dtExpePlan = tExpePlan.GetList("SampleID=" + eExpePlan.SampleID.ToString()).Tables[0]; string TaskNoS = ""; if (dtExpePlan != null && dtExpePlan.Rows.Count > 0) { for (int i = 0; i < dtExpePlan.Rows.Count; i++) { TaskNoS += dtExpePlan.Rows[i]["PlanID"].ToString() + ","; } TaskNoS = TaskNoS.TrimEnd(','); } eTestReport.TaskNoS = TaskNoS;//任务单号 对应的检验计划IDS eTestReport.EditPersonnelID = CurrentUserInfo.PersonnelID; eTestReport.AreaID = CurrentUserInfo.AreaID; eTestReport.AddTime = Convert.ToDateTime(DateTime.Now.ToShortDateString()); eTestReport.UpdateTime = DateTime.Now; eTestReport.ReportID = tTestReport.Add(eTestReport); } else { DataTable dt = tOriginalRecord.GetRecordIDListBySampleID(int.Parse(eExpePlan.SampleID.ToString())); string RecordIDS = ""; if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { RecordIDS += dt.Rows[i]["RecordID"].ToString() + ","; } RecordIDS = RecordIDS.TrimEnd(','); } eTestReport.RecordIDS = RecordIDS;//原始记录IDS DataTable dtExpePlan = tExpePlan.GetList("SampleID=" + eExpePlan.SampleID.ToString()).Tables[0]; string TaskNoS = ""; if (dtExpePlan != null && dtExpePlan.Rows.Count > 0) { for (int i = 0; i < dtExpePlan.Rows.Count; i++) { TaskNoS += dtExpePlan.Rows[i]["PlanID"].ToString() + ","; } TaskNoS = TaskNoS.TrimEnd(','); } eTestReport.TaskNoS = TaskNoS;//任务单号 对应的检验计划IDS eTestReport.AreaID = CurrentUserInfo.AreaID; eTestReport.EditPersonnelID = CurrentUserInfo.PersonnelID; eTestReport.UpdateTime = DateTime.Now; eTestReport.TestBasis = new BLL.Laboratory.T_tb_Project().GetModel(eOriginalRecord.ProjectID.Value).ExpeMethod; tTestReport.Update(eTestReport); } //更新检验报告数据 List <E_tb_TestReportData> eTestReportDataList = tTestReportData.GetModelList("RecordFilePath='" + eOriginalRecord.FilePath + "'"); if (eTestReportDataList != null) { E_tb_Project eProject = tProject.GetModel(Convert.ToInt32(eOriginalRecord.ProjectID)); if (eProject.IsPesCheck != null && int.Parse(eProject.IsPesCheck.ToString()) == 1)//判断是否为农药残留检查项目 { foreach (E_tb_TestReportData eTestReportData in eTestReportDataList) { eTestReportData.RecordID = eOriginalRecord.RecordID; //原始记录ID eTestReportData.ReportID = eTestReport.ReportID; //检验报告ID eTestReportData.TestStandard = eProject.ExpeMethod; //检验标准 if (!String.IsNullOrEmpty(eOriginalRecord.InsStand)) { String[] strs = eOriginalRecord.InsStand.Split(':'); if (strs == null || strs.Length <= 2) { strs = eOriginalRecord.InsStand.Split(':'); } if (strs != null && strs.Length >= 2) { String str = strs[1]; int result = 0; if (!String.IsNullOrEmpty(str)) { // 正则表达式剔除非数字字符(不包含小数点.) str = Regex.Replace(str, @"[^\d.\d]", ""); // 如果是数字,则转换为decimal类型 if (Regex.IsMatch(str, @"^[+-]?\d*[.]?\d*$")) { result = int.Parse(str); } if (!String.IsNullOrEmpty(eTestReportData.TestResult)) { Decimal _testResult = Convert.ToDecimal(eTestReportData.TestResult); if (_testResult <= result) { eTestReportData.QualifiedLevel = "合格"; } else { eTestReportData.QualifiedLevel = "不合格"; } } } } } tTestReportData.Update(eTestReportData); } } else { foreach (E_tb_TestReportData eTestReportData in eTestReportDataList) { eTestReportData.RecordID = eOriginalRecord.RecordID; //原始记录ID eTestReportData.ReportID = eTestReport.ReportID; //检验报告ID eTestReportData.TestName = eProject.ProjectName; //检验名称/检验项目名称 eTestReportData.TestStandard = eProject.ExpeMethod; //检验标准 if (!String.IsNullOrEmpty(eOriginalRecord.InsStand)) { String[] strs = eOriginalRecord.InsStand.Split(':'); if (strs == null || strs.Length <= 2) { strs = eOriginalRecord.InsStand.Split(':'); } if (strs != null && strs.Length >= 2) { String str = strs[1]; int result = 0; if (!String.IsNullOrEmpty(str)) { // 正则表达式剔除非数字字符(不包含小数点.) str = Regex.Replace(str, @"[^\d.\d]", ""); // 如果是数字,则转换为decimal类型 if (Regex.IsMatch(str, @"^[+-]?\d*[.]?\d*$") && !string.IsNullOrEmpty(str)) { result = int.Parse(str); } if (!String.IsNullOrEmpty(eTestReportData.TestResult) && !string.IsNullOrEmpty(str)) { Decimal _testResult = Convert.ToDecimal(eTestReportData.TestResult); if (_testResult <= result) { eTestReportData.QualifiedLevel = "合格"; } else { eTestReportData.QualifiedLevel = "不合格"; } } } } } tTestReportData.Update(eTestReportData); } } } return(Json(new { result = true, msg = "更新成功!" }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(E_tb_ExpePlan model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_ExpePlan set "); strSql.Append("PlanTypeID=@PlanTypeID,"); strSql.Append("ProjectID=@ProjectID,"); strSql.Append("SampleID=@SampleID,"); strSql.Append("InspectTime=@InspectTime,"); strSql.Append("InspectPlace=@InspectPlace,"); strSql.Append("InspectMethod=@InspectMethod,"); strSql.Append("HeadPersonnelID=@HeadPersonnelID,"); strSql.Append("TaskNo=@TaskNo,"); strSql.Append("Status=@Status,"); strSql.Append("Remark=@Remark,"); strSql.Append("AreaID=@AreaID,"); strSql.Append("EditPersonnelID=@EditPersonnelID,"); strSql.Append("UpdateTime=@UpdateTime"); strSql.Append(" where PlanID=@PlanID"); SqlParameter[] parameters = { new SqlParameter("@PlanTypeID", SqlDbType.Int, 4), new SqlParameter("@ProjectID", SqlDbType.Int, 4), new SqlParameter("@SampleID", SqlDbType.Int, 4), new SqlParameter("@InspectTime", SqlDbType.DateTime), new SqlParameter("@InspectPlace", SqlDbType.NVarChar, 100), new SqlParameter("@InspectMethod", SqlDbType.NVarChar), new SqlParameter("@HeadPersonnelID", SqlDbType.Int, 4), new SqlParameter("@TaskNo", SqlDbType.NVarChar, 50), new SqlParameter("@Status", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.Text), new SqlParameter("@AreaID", SqlDbType.Int, 4), new SqlParameter("@EditPersonnelID", SqlDbType.Int, 4), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@PlanID", SqlDbType.Int, 4) }; parameters[0].Value = model.PlanTypeID; parameters[1].Value = model.ProjectID; parameters[2].Value = model.SampleID; parameters[3].Value = model.InspectTime; parameters[4].Value = model.InspectPlace; parameters[5].Value = model.InspectMethod; parameters[6].Value = model.HeadPersonnelID; parameters[7].Value = model.TaskNo; parameters[8].Value = model.Status; parameters[9].Value = model.Remark; parameters[10].Value = model.AreaID; parameters[11].Value = model.EditPersonnelID; parameters[12].Value = model.UpdateTime; parameters[13].Value = model.PlanID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public E_tb_ExpePlan GetModel(int PlanID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 PlanID,PlanTypeID,ProjectID,SampleID,InspectTime,InspectPlace,InspectMethod,HeadPersonnelID,TaskNo,Status,Remark,AreaID,EditPersonnelID,UpdateTime from tb_ExpePlan "); strSql.Append(" where PlanID=@PlanID"); SqlParameter[] parameters = { new SqlParameter("@PlanID", SqlDbType.Int, 4) }; parameters[0].Value = PlanID; E_tb_ExpePlan model = new E_tb_ExpePlan(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["PlanID"].ToString() != "") { model.PlanID = int.Parse(ds.Tables[0].Rows[0]["PlanID"].ToString()); } if (ds.Tables[0].Rows[0]["PlanTypeID"].ToString() != "") { model.PlanTypeID = int.Parse(ds.Tables[0].Rows[0]["PlanTypeID"].ToString()); } if (ds.Tables[0].Rows[0]["ProjectID"].ToString() != "") { model.ProjectID = int.Parse(ds.Tables[0].Rows[0]["ProjectID"].ToString()); } if (ds.Tables[0].Rows[0]["SampleID"].ToString() != "") { model.SampleID = int.Parse(ds.Tables[0].Rows[0]["SampleID"].ToString()); } if (ds.Tables[0].Rows[0]["InspectTime"].ToString() != "") { model.InspectTime = DateTime.Parse(ds.Tables[0].Rows[0]["InspectTime"].ToString()); } if (ds.Tables[0].Rows[0]["InspectPlace"] != null) { model.InspectPlace = ds.Tables[0].Rows[0]["InspectPlace"].ToString(); } if (ds.Tables[0].Rows[0]["InspectMethod"] != null) { model.InspectMethod = ds.Tables[0].Rows[0]["InspectMethod"].ToString(); } if (ds.Tables[0].Rows[0]["HeadPersonnelID"].ToString() != "") { model.HeadPersonnelID = int.Parse(ds.Tables[0].Rows[0]["HeadPersonnelID"].ToString()); } if (ds.Tables[0].Rows[0]["TaskNo"] != null) { model.TaskNo = ds.Tables[0].Rows[0]["TaskNo"].ToString(); } if (ds.Tables[0].Rows[0]["Status"].ToString() != "") { model.Status = int.Parse(ds.Tables[0].Rows[0]["Status"].ToString()); } if (ds.Tables[0].Rows[0]["Remark"] != null) { model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString(); } if (ds.Tables[0].Rows[0]["AreaID"].ToString() != "") { model.AreaID = int.Parse(ds.Tables[0].Rows[0]["AreaID"].ToString()); } if (ds.Tables[0].Rows[0]["EditPersonnelID"].ToString() != "") { model.EditPersonnelID = int.Parse(ds.Tables[0].Rows[0]["EditPersonnelID"].ToString()); } if (ds.Tables[0].Rows[0]["UpdateTime"].ToString() != "") { model.UpdateTime = DateTime.Parse(ds.Tables[0].Rows[0]["UpdateTime"].ToString()); } return(model); } else { return(null); } }