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