public static string deleteData(string strDelIDs)
{
if (strDelIDs.Length == 0)
{
return("0");
}
string[] arrDelIDs = strDelIDs.Split(',');
bool isSuccess = true;
for (int i = 0; i < arrDelIDs.Length; i++)
{
TBaseMonitorTypeInfoVo objMonitorType = new TBaseMonitorTypeInfoVo();
objMonitorType.ID = arrDelIDs[i];
objMonitorType.IS_DEL = "1";
isSuccess = new TBaseMonitorTypeInfoLogic().Edit(objMonitorType);
}
if (isSuccess)
{
new PageBase().WriteLog("删除监测类别", "", new PageBase().LogInfo.UserInfo.USER_NAME + "删除监测类别" + arrDelIDs[0].ToString() + "成功！");
return("1");
}
else
{
return("0");
}
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tBaseMonitorTypeInfo">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TBaseMonitorTypeInfoVo tBaseMonitorTypeInfo)
{
string strSQL = SqlHelper.BuildUpdateExpress(tBaseMonitorTypeInfo, TBaseMonitorTypeInfoVo.T_BASE_MONITOR_TYPE_INFO_TABLE);
strSQL += string.Format(" where ID='{0}' ", tBaseMonitorTypeInfo.ID);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tBaseMonitorTypeInfo_UpdateSet">UpdateSet用户对象</param>
/// <param name="tBaseMonitorTypeInfo_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TBaseMonitorTypeInfoVo tBaseMonitorTypeInfo_UpdateSet, TBaseMonitorTypeInfoVo tBaseMonitorTypeInfo_UpdateWhere)
{
string strSQL = SqlHelper.BuildUpdateExpress(tBaseMonitorTypeInfo_UpdateSet, TBaseMonitorTypeInfoVo.T_BASE_MONITOR_TYPE_INFO_TABLE);
strSQL += this.BuildWhereStatement(tBaseMonitorTypeInfo_UpdateWhere);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 页面初始化
/// </summary>
private void InitDdl()
{
TBaseMonitorTypeInfoVo objMonitorType = new TBaseMonitorTypeInfoVo();
objMonitorType.IS_DEL = "0";
this.dllMonitorID.DataSource = new TBaseMonitorTypeInfoLogic().SelectByTable(objMonitorType);
this.dllMonitorID.DataTextField = TBaseMonitorTypeInfoVo.MONITOR_TYPE_NAME_FIELD;
this.dllMonitorID.DataValueField = TBaseMonitorTypeInfoVo.ID_FIELD;
this.dllMonitorID.DataBind();
this.ddlYear.Items.Add(GetItem(DateTime.Now.AddYears(-2).Year.ToString(), DateTime.Now.AddYears(-2).Year.ToString()));
this.ddlYear.Items.Add(GetItem(DateTime.Now.AddYears(-1).Year.ToString(), DateTime.Now.AddYears(-1).Year.ToString()));
this.ddlYear.Items.Add(GetItem(DateTime.Now.Year.ToString(), DateTime.Now.Year.ToString()));
this.ddlYear.Items.Add(GetItem(DateTime.Now.AddYears(1).Year.ToString(), DateTime.Now.AddYears(1).Year.ToString()));
this.ddlYear.Items.Add(GetItem(DateTime.Now.AddYears(2).Year.ToString(), DateTime.Now.AddYears(2).Year.ToString()));
this.ddlYear.Items.Add(GetItem(DateTime.Now.AddYears(3).Year.ToString(), DateTime.Now.AddYears(3).Year.ToString()));
this.ddlYear.SelectedIndex = -1;
this.ddlYear.Items.FindByValue(System.DateTime.Now.Year.ToString()).Selected = true;
this.ddlQuarter.Items.Add(GetItem("全年", "0"));
this.ddlQuarter.Items.Add(GetItem("上半年", "-1"));
this.ddlQuarter.Items.Add(GetItem("下半年", "-2"));
this.ddlQuarter.Items.Add(GetItem("第一季度", "1"));
this.ddlQuarter.Items.Add(GetItem("第二季度", "4"));
this.ddlQuarter.Items.Add(GetItem("第三季度", "7"));
this.ddlQuarter.Items.Add(GetItem("第四季度", "10"));
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tBaseMonitorTypeInfo">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TBaseMonitorTypeInfoVo tBaseMonitorTypeInfo, int iIndex, int iCount)
{
string strSQL = " select * from T_BASE_MONITOR_TYPE_INFO {0} ";
strSQL = String.Format(strSQL, BuildWhereStatement(tBaseMonitorTypeInfo));
return(SqlHelper.ExecuteDataTable(BuildPagerExpress <TBaseMonitorTypeInfoVo>(tBaseMonitorTypeInfo, strSQL, iIndex, iCount)));
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TBaseMonitorTypeInfoVo tBaseMonitorTypeInfo)
{
string strSQL = "delete from T_BASE_MONITOR_TYPE_INFO ";
strSQL += this.BuildWhereStatement(tBaseMonitorTypeInfo);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 获取下拉控件字典项JSON样式
/// </summary>
/// <returns></returns>
protected string getMonitorType()
{
TBaseMonitorTypeInfoVo objMonitorTypeVo = new TBaseMonitorTypeInfoVo();
objMonitorTypeVo.IS_DEL = "0";
DataTable dt = new TBaseMonitorTypeInfoLogic().SelectByTable(objMonitorTypeVo);
return(DataTableToJson(dt));
}
public static string GetMonitor(string strValue)
{
TBaseMonitorTypeInfoVo objtd = new TBaseMonitorTypeInfoVo();
objtd.IS_DEL = "0";
objtd.ID = strValue;
objtd = new TBaseMonitorTypeInfoLogic().Details(objtd);
return(objtd.MONITOR_TYPE_NAME);
}
/// <summary>
/// 获得监测类别
/// </summary>
/// <returns></returns>
public string getMonitorType()
{
TBaseMonitorTypeInfoVo TBaseMonitorTypeInfoVo = new TBaseMonitorTypeInfoVo();
TBaseMonitorTypeInfoVo.IS_DEL = "0";
DataTable dt = new TBaseMonitorTypeInfoLogic().SelectByTable(TBaseMonitorTypeInfoVo);
return(DataTableToJson(dt));
}
/// <summary>
/// 获取监测类型
/// </summary>
/// <returns></returns>
protected string getMonitorType()
{
string strReturn = "";
DataTable dt = new DataTable();
TBaseMonitorTypeInfoVo objMonitor = new TBaseMonitorTypeInfoVo();
objMonitor.IS_DEL = "0";
dt = new TBaseMonitorTypeInfoLogic().SelectByTable(objMonitor);
strReturn = DataTableToJson(dt);
return(strReturn);
}
public static List <object> GetMonitor()
{
List <object> reslut = new List <object>();
DataTable dtSt = new DataTable();
TBaseMonitorTypeInfoVo objtd = new TBaseMonitorTypeInfoVo();
objtd.IS_DEL = "0";
dtSt = new TBaseMonitorTypeInfoLogic().SelectByTable(objtd);
reslut = LigerGridSelectDataToJson(dtSt, dtSt.Rows.Count);
//reslut = gridDataToJson(dtSt, dtSt.Rows.Count, objtd);
return(reslut);
}
/// <summary>
/// 获得监测类别
/// </summary>
/// <returns>Json</returns>
protected string getMonitorType()
{
TBaseMonitorTypeInfoVo objMonitorType = new TBaseMonitorTypeInfoVo();
objMonitorType.IS_DEL = "0";
DataTable dt = new TBaseMonitorTypeInfoLogic().SelectByTable(objMonitorType);
DataRow dr = dt.NewRow();
dr["MONITOR_TYPE_NAME"] = "所有监测类别";
dt.Rows.InsertAt(dr, 0);
return(DataTableToJson(dt));
}
/// <summary>
/// 获取监测类别
/// </summary>
/// <param name="iIndex"></param>
/// <param name="iCount"></param>
/// <returns></returns>
public string GetMonitors(int iIndex, int iCount)
{
string reslut = "";
DataTable dtSt = new DataTable();
TBaseMonitorTypeInfoVo objtd = new TBaseMonitorTypeInfoVo();
objtd.IS_DEL = "0";
dtSt = new TBaseMonitorTypeInfoLogic().SelectByTable(objtd, iIndex, iCount);
int intTotalCount = new TBaseMonitorTypeInfoLogic().GetSelectResultCount(objtd);
reslut = LigerGridDataToJson(dtSt, intTotalCount);
return(reslut);
}
/// <summary>
/// 获取监测类别
/// </summary>
/// <param name="iIndex"></param>
/// <param name="iCount"></param>
/// <returns></returns>
public void GetMonitorsDutys( )
{
DataTable dtSt = new DataTable();
DataTable dtDict = new DataTable();
TBaseMonitorTypeInfoVo objtd = new TBaseMonitorTypeInfoVo();
objtd.IS_DEL = "0";
dtSt = new TBaseMonitorTypeInfoLogic().SelectByTable(objtd);
TSysDictVo objDit = new TSysDictVo();
objDit.DICT_TYPE = "duty_other";
dtDict = new TSysDictLogic().SelectByTable(objDit);
if (dtSt.Rows.Count > 0)
{
int Sum = 0;
foreach (DataRow drr in dtSt.Rows)
{
Sum++;
nodes = "{ Id:'" + drr["ID"].ToString() + "',pId:'0',Code:'" + drr["ID"] + "',Name:'" + drr["MONITOR_TYPE_NAME"] + "'";
if (Sum == 1)
{
nodes += " ,open:true},\r\n";
}
else
{
nodes += " },\r\n";
}
for (int i = 0; i < dtDict.Rows.Count; i++)
{
nodes += "{ Id:'" + dtDict.Rows[i]["ID"] + "',pId:'" + drr["ID"] + "',Code:'" + dtDict.Rows[i]["DICT_CODE"].ToString() + "',Name:'" + dtDict.Rows[i]["DICT_TEXT"].ToString() + "'";
if (i == dtDict.Rows.Count - 1)
{
nodes += "}\r\n";
}
else
{
nodes += "},\r\n";
}
}
treenodes.Add(nodes);
}
}
string rootNode = "{ Id:'0',pId:'',Code:'0',Name:'监测类别岗位职责集合',open:true},";
varNodes = "[" + rootNode + "" + String.Join(",\r\n", treenodes.ToArray()) + "]";
}
public static List <object> GetMonitor()
{
List <object> reslut = new List <object>();
DataTable dtSt = new DataTable();
TBaseMonitorTypeInfoVo objtd = new TBaseMonitorTypeInfoVo();
objtd.IS_DEL = "0";
objtd.SORT_FIELD = "SORT_NUM";
objtd.SORT_TYPE = "ASC";
dtSt = new TBaseMonitorTypeInfoLogic().SelectByTable(objtd);
dtSt.DefaultView.Sort = "SORT_NUM ASC";
DataTable dtTemp = dtSt.DefaultView.ToTable();
reslut = LigerGridSelectDataToJson(dtTemp, dtTemp.Rows.Count);
return(reslut);
}
//获取监测类别数据
private void GetData()
{
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
int intPageIdx = Convert.ToInt32(Request.Params["page"]);
int intPagesize = Convert.ToInt32(Request.Params["pagesize"]);
TBaseMonitorTypeInfoVo objMonitorType = new TBaseMonitorTypeInfoVo();
objMonitorType.IS_DEL = "0";
objMonitorType.SORT_FIELD = "SORT_NUM";
objMonitorType.SORT_TYPE = "asc";
TBaseMonitorTypeInfoLogic logicMonitorType = new TBaseMonitorTypeInfoLogic();
int intTotalCount = logicMonitorType.GetSelectResultCount(objMonitorType);;//总计的数据条数
DataTable dt = logicMonitorType.SelectByTable(objMonitorType, intPageIdx, intPagesize);
string strJson = CreateToJson(dt, intTotalCount);
Response.Write(strJson);
}
//获取点位信息
private string getPointList()
{
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
//当前页面
int intPageIndex = Convert.ToInt32(Request.Params["page"]);
//每页记录数
int intPageSize = Convert.ToInt32(Request.Params["pagesize"]);
if (strSortname == null || strSortname.Length < 0)
{
strSortname = TBaseCompanyPointVo.NUM_FIELD;
}
string strCompanyID = Request.Params["CompanyID"];
if (strCompanyID.Length == 0)
{
return("");
}
TBaseCompanyPointVo objPoint = new TBaseCompanyPointVo();
objPoint.IS_DEL = "0";
objPoint.COMPANY_ID = strCompanyID;
objPoint.SORT_FIELD = strSortname;
objPoint.SORT_TYPE = strSortorder;
DataTable dt = new TBaseCompanyPointLogic().SelectByTable(objPoint, intPageIndex, intPageSize);
for (int i = 0; i < dt.Rows.Count; i++)
{
TBaseMonitorTypeInfoVo MonitorTypeInfoVo = new TBaseMonitorTypeInfoVo();
MonitorTypeInfoVo = new TBaseMonitorTypeInfoLogic().Details(dt.Rows[i]["MONITOR_ID"].ToString());
dt.Rows[i]["REMARK1"] = MonitorTypeInfoVo.REMARK1;
}
int intTotalCount = new TBaseCompanyPointLogic().GetSelectResultCount(objPoint);
string strJson = CreateToJson(dt, intTotalCount);
return(strJson);
}
public static string EditData(string strID, string strMONITOR_TYPE_NAME, string strDESCRIPTION, string strSORT_NUM)
{
bool isSuccess = true;
TBaseMonitorTypeInfoVo objMonitorType = new TBaseMonitorTypeInfoVo();
objMonitorType.ID = strID;
objMonitorType.MONITOR_TYPE_NAME = strMONITOR_TYPE_NAME;
objMonitorType.DESCRIPTION = strDESCRIPTION.Length > 0 ? strDESCRIPTION : ConstValues.SpecialCharacter.EmptyValuesFillChar;
objMonitorType.SORT_NUM = strSORT_NUM;
isSuccess = new TBaseMonitorTypeInfoLogic().Edit(objMonitorType);
if (isSuccess)
{
new PageBase().WriteLog("修改监测类别", "", new PageBase().LogInfo.UserInfo.USER_NAME + "修改监测类别" + objMonitorType.ID + "成功！");
return("1");
}
else
{
return("0");
}
}
public static string AddData(string strMONITOR_TYPE_NAME, string strDESCRIPTION, string strSORT_NUM)
{
bool isSuccess = true;
TBaseMonitorTypeInfoVo objMonitorType = new TBaseMonitorTypeInfoVo();
objMonitorType.ID = GetSerialNumber("t_base_monitor_type_info_id");
objMonitorType.IS_DEL = "0";
objMonitorType.MONITOR_TYPE_NAME = strMONITOR_TYPE_NAME;
objMonitorType.DESCRIPTION = strDESCRIPTION;
objMonitorType.SORT_NUM = strSORT_NUM;
isSuccess = new TBaseMonitorTypeInfoLogic().Create(objMonitorType);
if (isSuccess)
{
new PageBase().WriteLog("新增监测类别", "", new PageBase().LogInfo.UserInfo.USER_NAME + "新增监测类别" + objMonitorType.ID + "成功！");
return("1");
}
else
{
return("0");
}
}
protected void BindList()
{
TBaseItemInfoVo objItem = new TBaseItemInfoVo();
objItem.IS_DEL = "0";
string monitor_type = new TMisMonitorSubtaskLogic().Details(this.Request["SubtaskID"].ToString()).MONITOR_ID;
//黄进军 添加 20150417
//如果是环境质量监测类型项目，我们需要把他们变为废水或废气项目，因为系统中只设置了废水、废气、噪声等项目类型
TBaseMonitorTypeInfoVo tmtype = new TBaseMonitorTypeInfoVo();
tmtype = new TBaseMonitorTypeInfoLogic().Details(monitor_type);
if (tmtype.REMARK1 != null || tmtype.REMARK1 != "")
{
objItem.MONITOR_ID = tmtype.REMARK1;
}
else
{
objItem.MONITOR_ID = monitor_type;
}
List <TBaseItemInfoVo> lstItem = new TBaseItemInfoLogic().SelectByObject(objItem, 0, 0);
lstItem.Sort(delegate(TBaseItemInfoVo a, TBaseItemInfoVo b) { return(a.ORDER_NUM.CompareTo(b.ORDER_NUM)); });
this.ListBox1.DataSource = lstItem;
this.ListBox1.DataValueField = TBaseItemInfoVo.ID_FIELD;
this.ListBox1.DataTextField = TBaseItemInfoVo.ITEM_NAME_FIELD;
this.ListBox1.DataBind();
TMisMonitorTaskItemVo objPointItem = new TMisMonitorTaskItemVo();
objPointItem.IS_DEL = "0";
objPointItem.TASK_POINT_ID = new TMisMonitorSampleInfoLogic().Details(this.Request["PointID"].ToString()).POINT_ID;
List <TMisMonitorTaskItemVo> lstPointItem = new TMisMonitorTaskItemLogic().SelectByObject(objPointItem, 0, 0);
string strPointItemIDs = "";
for (int i = 0; i < lstPointItem.Count; i++)
{
strPointItemIDs += "," + lstPointItem[i].ITEM_ID;
}
strPointItemIDs = strPointItemIDs + ",";
for (int i = lstItem.Count - 1; i >= 0; i--)
{
if (!strPointItemIDs.Contains(lstItem[i].ID))
{
lstItem.RemoveAt(i);
}
}
this.ListBox2.DataSource = lstItem;
this.ListBox2.DataValueField = TBaseItemInfoVo.ID_FIELD;
this.ListBox2.DataTextField = TBaseItemInfoVo.ITEM_NAME_FIELD;
this.ListBox2.DataBind();
for (int i = 0; i < ListBox2.Items.Count; i++)
{
ListItem item = ListBox2.Items[i];
ListBox1.Items.Remove(item);
}
}
/// <summary>
/// 获取 未确认的监测报告
/// </summary>
/// <returns></returns>
protected string GetReportInfo(string strTabType)
{
string result = "";
int intTotalCount = 0;
//页数
int pageIndex = Int32.Parse(Request.Params["page"].ToString());
//分页数
int pageSize = Int32.Parse(Request.Params["pagesize"].ToString());
DataTable dtEval = new DataTable();
//监测任务对象
TMisMonitorTaskVo objTask = new TMisMonitorTaskVo();
//创建标准JSON数据
objTask.SORT_FIELD = Request.Params["sortname"];
objTask.SORT_TYPE = Request.Params["sortorder"];
//过滤条件
//委托类型
objTask.CONTRACT_TYPE = !String.IsNullOrEmpty(Request.Params["srhContractType"]) ? Request.Params["srhContractType"].ToString() : "";
//委托书编号
objTask.CONTRACT_CODE = !String.IsNullOrEmpty(Request.Params["srhContractCode"]) ? Request.Params["srhContractCode"].ToString() : "";
//项目名称
objTask.PROJECT_NAME = !String.IsNullOrEmpty(Request.Params["srhProjectName"]) ? Request.Params["srhProjectName"].ToString() : "";
//任务单号
objTask.TICKET_NUM = !String.IsNullOrEmpty(Request.Params["srhTaskCode"]) ? Request.Params["srhTaskCode"].ToString() : "";
//任务状态
objTask.TASK_STATUS = "09";
//确认状态 未确认
objTask.COMFIRM_STATUS = strTabType;
if (!base.LogInfo.UserInfo.REAL_NAME.Contains("管理员") && strType == "QY")
{
//过滤处理人
objTask.REPORT_HANDLE = base.LogInfo.UserInfo.ID;
}
dtEval = new TMisMonitorTaskLogic().SelectByTable(objTask, pageIndex, pageSize);
//添加监测类型
TMisContractVo objContractVo = new TMisContractVo();
TBaseMonitorTypeInfoVo objMonitorTypeVo = new TBaseMonitorTypeInfoVo();
DataTable dt = new DataTable();
string[] objType;
string strTypeName = "";
for (int i = 0; i < dtEval.Rows.Count; i++)
{
strTypeName = "";
//objTask = null;
if (string.IsNullOrEmpty(dtEval.Rows[i]["CONTRACT_ID"].ToString()))
{
TMisMonitorSubtaskVo tMisMonitorSubtaskVo = new TMisMonitorSubtaskVo();
tMisMonitorSubtaskVo.TASK_ID = dtEval.Rows[i]["ID"].ToString();
DataTable dtTemp = new TMisMonitorSubtaskLogic().SelectByTable(tMisMonitorSubtaskVo);
objType = new string[dtTemp.Rows.Count];
for (int j = 0; j < dtTemp.Rows.Count; j++)
{
objType[j] = dtTemp.Rows[j]["MONITOR_ID"].ToString();
}
List <string> listTemp = objType.ToList <string>();
objType = listTemp.Distinct().ToArray <string>();
}
else
{
objContractVo = new TMisContractLogic().Details(dtEval.Rows[i]["CONTRACT_ID"].ToString());
objType = objContractVo.TEST_TYPES.Split(';');
}
for (int j = 0; j < objType.Length; j++)
{
objMonitorTypeVo = new TBaseMonitorTypeInfoLogic().Details(objType[j]);
strTypeName += objMonitorTypeVo.MONITOR_TYPE_NAME + ",";
}
dtEval.Rows[i]["REMARK1"] = strTypeName.TrimEnd(',');
}
intTotalCount = new TMisMonitorTaskLogic().GetSelectResultCount(objTask);
//处理现场项目任务 现场项目任务未审核完成时将报告任务移除
result = LigerGridDataToJson(dtEval, intTotalCount);
return(result);
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tBaseMonitorTypeInfo">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TBaseMonitorTypeInfoVo> SelectByObject(TBaseMonitorTypeInfoVo tBaseMonitorTypeInfo, int iIndex, int iCount)
{
string strSQL = String.Format("select * from T_BASE_MONITOR_TYPE_INFO " + this.BuildWhereStatement(tBaseMonitorTypeInfo));
return(SqlHelper.ExecuteObjectList(tBaseMonitorTypeInfo, BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tBaseMonitorTypeInfo">对象条件</param>
/// <returns>对象</returns>
public TBaseMonitorTypeInfoVo Details(TBaseMonitorTypeInfoVo tBaseMonitorTypeInfo)
{
string strSQL = String.Format("select * from T_BASE_MONITOR_TYPE_INFO " + this.BuildWhereStatement(tBaseMonitorTypeInfo));
return(SqlHelper.ExecuteObject(new TBaseMonitorTypeInfoVo(), strSQL));
}
/// <summary>
/// 根据对象构造条件语句
/// </summary>
/// <param name="tBaseMonitorTypeInfo"></param>
/// <returns></returns>
public string BuildWhereStatement(TBaseMonitorTypeInfoVo tBaseMonitorTypeInfo)
{
StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 ");
if (null != tBaseMonitorTypeInfo)
{
//ID
if (!String.IsNullOrEmpty(tBaseMonitorTypeInfo.ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ID = '{0}'", tBaseMonitorTypeInfo.ID.ToString()));
}
//监测类别名称
if (!String.IsNullOrEmpty(tBaseMonitorTypeInfo.MONITOR_TYPE_NAME.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND MONITOR_TYPE_NAME = '{0}'", tBaseMonitorTypeInfo.MONITOR_TYPE_NAME.ToString()));
}
////监测类别样品编码规则
//if (!String.IsNullOrEmpty(tBaseMonitorTypeInfo.IDENTIFY_CODE.ToString().Trim()))
//{
// strWhereStatement.Append(string.Format(" AND IDENTIFY_CODE = '{0}'", tBaseMonitorTypeInfo.IDENTIFY_CODE.ToString()));
//}
//监测类别描述
if (!String.IsNullOrEmpty(tBaseMonitorTypeInfo.DESCRIPTION.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND DESCRIPTION = '{0}'", tBaseMonitorTypeInfo.DESCRIPTION.ToString()));
}
//使用状态(0为启用、1为停用)
if (!String.IsNullOrEmpty(tBaseMonitorTypeInfo.IS_DEL.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND IS_DEL = '{0}'", tBaseMonitorTypeInfo.IS_DEL.ToString()));
}
//排列属性
if (!String.IsNullOrEmpty(tBaseMonitorTypeInfo.SORT_NUM.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND SORT_NUM = '{0}'", tBaseMonitorTypeInfo.SORT_NUM.ToString()));
}
//备注1
if (!String.IsNullOrEmpty(tBaseMonitorTypeInfo.REMARK1.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tBaseMonitorTypeInfo.REMARK1.ToString()));
}
//备注2
if (!String.IsNullOrEmpty(tBaseMonitorTypeInfo.REMARK2.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tBaseMonitorTypeInfo.REMARK2.ToString()));
}
//备注3
if (!String.IsNullOrEmpty(tBaseMonitorTypeInfo.REMARK3.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tBaseMonitorTypeInfo.REMARK3.ToString()));
}
//备注4
if (!String.IsNullOrEmpty(tBaseMonitorTypeInfo.REMARK4.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK4 = '{0}'", tBaseMonitorTypeInfo.REMARK4.ToString()));
}
//备注5
if (!String.IsNullOrEmpty(tBaseMonitorTypeInfo.REMARK5.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK5 = '{0}'", tBaseMonitorTypeInfo.REMARK5.ToString()));
}
}
return(strWhereStatement.ToString());
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tBaseMonitorTypeInfo">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TBaseMonitorTypeInfoVo tBaseMonitorTypeInfo)
{
string strSQL = "select Count(*) from T_BASE_MONITOR_TYPE_INFO " + this.BuildWhereStatement(tBaseMonitorTypeInfo);
return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL)));
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tBaseMonitorTypeInfo">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TBaseMonitorTypeInfoVo tBaseMonitorTypeInfo, int iIndex, int iCount)
{
return(access.SelectByTable(tBaseMonitorTypeInfo, iIndex, iCount));
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tBaseMonitorTypeInfo">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TBaseMonitorTypeInfoVo> SelectByObject(TBaseMonitorTypeInfoVo tBaseMonitorTypeInfo, int iIndex, int iCount)
{
return(access.SelectByObject(tBaseMonitorTypeInfo, iIndex, iCount));
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="tBaseMonitorTypeInfo">对象</param>
/// <returns>是否成功</returns>
public bool Create(TBaseMonitorTypeInfoVo tBaseMonitorTypeInfo)
{
string strSQL = SqlHelper.BuildInsertExpress(tBaseMonitorTypeInfo, TBaseMonitorTypeInfoVo.T_BASE_MONITOR_TYPE_INFO_TABLE);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tBaseMonitorTypeInfo"></param>
/// <returns></returns>
public DataTable SelectByTable(TBaseMonitorTypeInfoVo tBaseMonitorTypeInfo)
{
string strSQL = "select * from T_BASE_MONITOR_TYPE_INFO " + this.BuildWhereStatement(tBaseMonitorTypeInfo);
return(SqlHelper.ExecuteDataTable(strSQL));
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tBaseMonitorTypeInfo">对象条件</param>
/// <returns>对象</returns>
public TBaseMonitorTypeInfoVo Details(TBaseMonitorTypeInfoVo tBaseMonitorTypeInfo)
{
return(access.Details(tBaseMonitorTypeInfo));
}
