/// <summary> /// 增加一条数据 /// </summary> public int Add(E_tb_TypeDict model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_TypeDict("); strSql.Append("SubjectID,TypeName,ParentID,TypeLevel,Directions)"); strSql.Append(" values ("); strSql.Append("@SubjectID,@TypeName,@ParentID,@TypeLevel,@Directions)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@SubjectID", SqlDbType.Int, 4), new SqlParameter("@TypeName", SqlDbType.NVarChar, 50), new SqlParameter("@ParentID", SqlDbType.Int, 4), new SqlParameter("@TypeLevel", SqlDbType.Int, 4), new SqlParameter("@Directions", SqlDbType.NVarChar, 200) }; parameters[0].Value = model.SubjectID; parameters[1].Value = model.TypeName; parameters[2].Value = model.ParentID; parameters[3].Value = model.TypeLevel; parameters[4].Value = model.Directions; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 获得数据列表 /// </summary> public List <E_tb_TypeDict> DataTableToList(DataTable dt) { List <E_tb_TypeDict> modelList = new List <E_tb_TypeDict>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { E_tb_TypeDict model; for (int n = 0; n < rowsCount; n++) { model = new E_tb_TypeDict(); if (dt.Rows[n]["TypeID"].ToString() != "") { model.TypeID = int.Parse(dt.Rows[n]["TypeID"].ToString()); } if (dt.Rows[n]["SubjectID"].ToString() != "") { model.SubjectID = int.Parse(dt.Rows[n]["SubjectID"].ToString()); } model.TypeName = dt.Rows[n]["TypeName"].ToString(); if (dt.Rows[n]["ParentID"].ToString() != "") { model.ParentID = int.Parse(dt.Rows[n]["ParentID"].ToString()); } if (dt.Rows[n]["TypeLevel"].ToString() != "") { model.TypeLevel = int.Parse(dt.Rows[n]["TypeLevel"].ToString()); } model.Directions = dt.Rows[n]["Directions"].ToString(); modelList.Add(model); } } return(modelList); }
/// <summary> /// 显示详情页 /// </summary> /// <param name="EditType">编辑类型</param> /// <returns>返回编辑结果</returns> public JsonResult TypeDictEdit(E_tb_TypeDict eTypeDict, string EditType, int?InfoID) { if (EditType == "Edit") { eTypeDict = tTypeDict.GetModel(Convert.ToInt32(InfoID)); } eTypeDict.EditType = EditType; return(Json(eTypeDict, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 得到一个对象实体 /// </summary> public E_tb_TypeDict GetModel(int TypeID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 TypeID,SubjectID,TypeName,ParentID,TypeLevel,Directions from tb_TypeDict "); strSql.Append(" where TypeID=@TypeID"); SqlParameter[] parameters = { new SqlParameter("@TypeID", SqlDbType.Int, 4) }; parameters[0].Value = TypeID; E_tb_TypeDict model = new E_tb_TypeDict(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["TypeID"].ToString() != "") { model.TypeID = int.Parse(ds.Tables[0].Rows[0]["TypeID"].ToString()); } if (ds.Tables[0].Rows[0]["SubjectID"].ToString() != "") { model.SubjectID = int.Parse(ds.Tables[0].Rows[0]["SubjectID"].ToString()); } if (ds.Tables[0].Rows[0]["TypeName"] != null) { model.TypeName = ds.Tables[0].Rows[0]["TypeName"].ToString(); } if (ds.Tables[0].Rows[0]["ParentID"].ToString() != "") { model.ParentID = int.Parse(ds.Tables[0].Rows[0]["ParentID"].ToString()); } if (ds.Tables[0].Rows[0]["TypeLevel"].ToString() != "") { model.TypeLevel = int.Parse(ds.Tables[0].Rows[0]["TypeLevel"].ToString()); } if (ds.Tables[0].Rows[0]["Directions"] != null) { model.Directions = ds.Tables[0].Rows[0]["Directions"].ToString(); } return(model); } else { return(null); } }
/// <summary> /// 保存类别信息 /// 作者:小朱 /// </summary> /// <param name="eNews">要处理的对象</param> /// <returns>返回是否处理成功</returns> public string Save(E_tb_TypeDict eTypeDict) { string msg = "0"; if (eTypeDict.EditType == "Add") { eTypeDict.TypeLevel = 0; if (eTypeDict.ParentID > 0) { eTypeDict.TypeLevel = tTypeDict.GetModel(eTypeDict.ParentID).TypeLevel + 1; } tTypeDict.Add(eTypeDict); msg = "1"; } else { tTypeDict.Update(eTypeDict); msg = "1"; } return(msg); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(E_tb_TypeDict model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_TypeDict set "); strSql.Append("SubjectID=@SubjectID,"); strSql.Append("TypeName=@TypeName,"); strSql.Append("ParentID=@ParentID,"); strSql.Append("TypeLevel=@TypeLevel,"); strSql.Append("Directions=@Directions"); strSql.Append(" where TypeID=@TypeID"); SqlParameter[] parameters = { new SqlParameter("@SubjectID", SqlDbType.Int, 4), new SqlParameter("@TypeName", SqlDbType.NVarChar, 50), new SqlParameter("@ParentID", SqlDbType.Int, 4), new SqlParameter("@TypeLevel", SqlDbType.Int, 4), new SqlParameter("@Directions", SqlDbType.NVarChar, 200), new SqlParameter("@TypeID", SqlDbType.Int, 4) }; parameters[0].Value = model.SubjectID; parameters[1].Value = model.TypeName; parameters[2].Value = model.ParentID; parameters[3].Value = model.TypeLevel; parameters[4].Value = model.Directions; parameters[5].Value = model.TypeID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
// // GET: /TypeDict/ /// <summary> /// 类别字典列表 /// </summary> /// <param name="eTypeDict">类别实体</param> /// <returns></returns> public ActionResult TypeDictList(E_tb_TypeDict eTypeDict) { //一级模板 string LoopTemplate = @"<ul id='row1'> <li class='WidthID'>{$id}</li> <li class='WidthName'>{$imglist}<a href='javascript:void(0);' onclick='rowView({$id})'><img src='{$IcoImg}' id='Icon{$id}'/>{$TypeName}</a></li> <li class='WidthOperate'> <a href='javascript:void(0);' onclick='Add({$id})'>添加子类</a> | <a href='javascript:void(0);' onclick='Edit({$id})'>修改</a> | <a href='javascript:void(0);' onclick='Delete({$id})'>删除</a> </li> </ul>"; //子模板 string SubTemplate = "<div class='displaynone' id='SubItem{0}'>{1}</div>"; StringBuilder TypeHtml = new StringBuilder(); DataRow[] RowList = tTypeDict.GetList("ParentID=0 and SubjectID=" + eTypeDict.SubjectID).Tables[0].Select(); string SubTypeHtml = AddTypeHtml(RowList, LoopTemplate, SubTemplate); TypeHtml.Append(SubTypeHtml); ViewData["TypeHtml"] = TypeHtml.ToString(); return(View(eTypeDict)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(E_tb_TypeDict model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(E_tb_TypeDict model) { return(dal.Add(model)); }
T_tb_Area tArea = new T_tb_Area(); //区域/单位 public ActionResult TestReportView(E_tb_TestReport eTestReport) { ViewData["ReportDataList"] = tTestReportData.GetList("ReportID=" + eTestReport.ReportID).Tables[0]; //检验数据 eTestReport = tTestReport.GetModel(eTestReport.ReportID); E_tb_TypeDict eTypeDict = tTypeDict.GetModel(Convert.ToInt32(eTestReport.TestType)); eTestReport.TestTypeName = (eTypeDict != null ? eTypeDict.TypeName : ""); E_tb_InPersonnel eInPersonnel = new E_tb_InPersonnel(); if (eTestReport.ApprovalPersonnelID != null && eTestReport.ApprovalPersonnelID > 0) { eInPersonnel = tInPersonnel.GetModel(Convert.ToInt32(eTestReport.ApprovalPersonnelID)); if (eInPersonnel != null) { eTestReport.ApprovalPersonnelName = eInPersonnel.PersonnelName; } } if (eTestReport.examinePersonnelID != null && eTestReport.examinePersonnelID > 0) { eInPersonnel = tInPersonnel.GetModel(Convert.ToInt32(eTestReport.examinePersonnelID)); if (eInPersonnel != null) { eTestReport.examinePersonnelName = eInPersonnel.PersonnelName; } } if (eTestReport.MainTestPersonnelID != null && eTestReport.MainTestPersonnelID > 0) { eInPersonnel = tInPersonnel.GetModel(Convert.ToInt32(eTestReport.MainTestPersonnelID)); if (eInPersonnel != null) { eTestReport.MainTestPersonnelName = eInPersonnel.PersonnelName; } } //eTestReport.SampleName = Regex.Replace(eTestReport.SampleName, @"[^\u4e00-\u9fa5]", ""); if (eTestReport.SampleName.ToString().IndexOf(')') > -1) { eTestReport.SampleName = eTestReport.SampleName.ToString().Substring(0, eTestReport.SampleName.ToString().IndexOf(')') + 1); } else if (eTestReport.SampleName.ToString().IndexOf(')') > -1) { eTestReport.SampleName = eTestReport.SampleName.ToString().Substring(0, eTestReport.SampleName.ToString().IndexOf(')') + 1); } else { eTestReport.SampleName = Regex.Replace(eTestReport.SampleName, @"[^\u4e00-\u9fa5|(|)]", ""); } var sampleModel = new BLL.tb_SampleBLL().GetModelList(" sampleNum = '" + eTestReport.SampleNum + "'").FirstOrDefault(); ViewBag._cydw = "none"; ViewBag._sydw = "none"; ViewBag._scjdw = ""; if (sampleModel != null) { if (sampleModel.isDetection) { eTestReport.ToSampleMode = "抽样"; ViewBag._cydw = ""; ViewBag._scjdw = eTestReport.SamplingCompany; eTestReport.Department = "/"; } else { eTestReport.ToSampleMode = "送样"; ViewBag._sydw = ""; eTestReport.SamplingCompany = "/"; ViewBag._scjdw = eTestReport.Department; } } if (String.IsNullOrEmpty(eTestReport.Specifications)) { eTestReport.Specifications = "/"; } if (String.IsNullOrEmpty(eTestReport.Packing)) { eTestReport.Packing = "/"; } if (String.IsNullOrEmpty(eTestReport.productNum)) { eTestReport.productNum = "/"; } ViewBag._IssuedTime = ""; if (eTestReport.IssuedTime != null) { ViewBag._IssuedTime = eTestReport.IssuedTime.Value.ToString("yyyy/MM/dd"); } var _orlist = new BLL.OriginalRecord.T_tb_OriginalRecord().GetModelList(" RecordID in (" + eTestReport.RecordIDS + ")"); String _projectIds = ""; int _tempProjectId = 0; for (int i = 0; i < _orlist.Count; i++) { if (_tempProjectId == _orlist[i].ProjectID) { continue; } if (String.IsNullOrEmpty(_projectIds)) { _projectIds = _orlist[i].ProjectID.ToString(); } else { _projectIds += "," + _orlist[i].ProjectID.ToString(); } } eTestReport.TestBasis = ""; var _projectlist = new BLL.Laboratory.T_tb_Project().GetModelList(" ProjectID in (" + _projectIds + ")"); foreach (var item in _projectlist) { if (String.IsNullOrEmpty(eTestReport.TestBasis)) { eTestReport.TestBasis = item.ExpeMethod; } else { eTestReport.TestBasis += "," + item.ExpeMethod; } } ViewBag.AreaName = tArea.GetModel(int.Parse(eTestReport.AreaID.ToString())).TestReportName; return(View(eTestReport)); }