/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tBaseCompanyPointItem">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TBaseCompanyPointItemVo tBaseCompanyPointItem)
{
string strSQL = SqlHelper.BuildUpdateExpress(tBaseCompanyPointItem, TBaseCompanyPointItemVo.T_BASE_COMPANY_POINT_ITEM_TABLE);
strSQL += string.Format(" where ID='{0}' ", tBaseCompanyPointItem.ID);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
//获取指定点位的监测项目信息
private string getItemList()
{
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
int intPageIdx = Convert.ToInt32(Request.Params["page"]);
int intPagesize = Convert.ToInt32(Request.Params["pagesize"]);
string strSelPointID = (Request.Params["pId"] != null) ? Request.Params["pId"] : "";
if (strSelPointID.Length <= 0)
{
return("");
}
if (strSortname == null || strSortname.Length < 0)
{
strSortname = TBaseCompanyPointItemVo.ID_FIELD;
}
TBaseCompanyPointItemVo objPointItem = new TBaseCompanyPointItemVo();
objPointItem.IS_DEL = "0";
objPointItem.POINT_ID = strSelPointID;
objPointItem.SORT_FIELD = strSortname;
objPointItem.SORT_TYPE = strSortorder;
TBaseCompanyPointItemLogic logicPointItem = new TBaseCompanyPointItemLogic();
int intTotalCount = logicPointItem.GetSelectResultCount(objPointItem);;//总计的数据条数
DataTable dt = logicPointItem.SelectByTable(objPointItem, intPageIdx, intPagesize);
string strJson = CreateToJson(dt, intTotalCount);
return(strJson);
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tBaseCompanyPointItem_UpdateSet">UpdateSet用户对象</param>
/// <param name="tBaseCompanyPointItem_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TBaseCompanyPointItemVo tBaseCompanyPointItem_UpdateSet, TBaseCompanyPointItemVo tBaseCompanyPointItem_UpdateWhere)
{
string strSQL = SqlHelper.BuildUpdateExpress(tBaseCompanyPointItem_UpdateSet, TBaseCompanyPointItemVo.T_BASE_COMPANY_POINT_ITEM_TABLE);
strSQL += this.BuildWhereStatement(tBaseCompanyPointItem_UpdateWhere);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TBaseCompanyPointItemVo tBaseCompanyPointItem)
{
string strSQL = "delete from T_BASE_COMPANY_POINT_ITEM ";
strSQL += this.BuildWhereStatement(tBaseCompanyPointItem);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 根据企业点位ID 获取当前点位下的所有监测项目
/// </summary>
/// <param name="tBaseCompanyPointItem"></param>
/// <returns></returns>
public DataTable SelectItemsForPoint(TBaseCompanyPointItemVo tBaseCompanyPointItem)
{
string strSQL = String.Format(@"SELECT A.POINT_ID,B.ID,B.ITEM_NAME,MONITOR_ID FROM T_BASE_COMPANY_POINT_ITEM A INNER JOIN T_BASE_ITEM_INFO B ON B.ID=A.ITEM_ID AND B.IS_DEL='0'");
if (!String.IsNullOrEmpty(tBaseCompanyPointItem.POINT_ID))
{
strSQL += String.Format(" AND A.POINT_ID='{0}'", tBaseCompanyPointItem.POINT_ID);
}
return(SqlHelper.ExecuteDataTable(strSQL));
}
public static string CopyPointItem(string strCopyID, string strPastID)
{
bool isSuccess = true;
TBaseCompanyPointItemVo objPointItemCopy = new TBaseCompanyPointItemVo();
objPointItemCopy.IS_DEL = "0";
objPointItemCopy.POINT_ID = strCopyID;
DataTable dtCopy = new TBaseCompanyPointItemLogic().SelectByTable(objPointItemCopy);
TBaseCompanyPointItemVo objPointItemPast = new TBaseCompanyPointItemVo();
objPointItemPast.IS_DEL = "0";
objPointItemPast.POINT_ID = strPastID;
DataTable dtPast = new TBaseCompanyPointItemLogic().SelectByTable(objPointItemPast);
string strIsExistItem = "";
for (int i = 0; i < dtPast.Rows.Count; i++)
{
strIsExistItem += "," + dtPast.Rows[i]["ITEM_ID"].ToString();
}
strIsExistItem += strIsExistItem.Length > 0 ? "," : "";
for (int i = 0; i < dtCopy.Rows.Count; i++)
{
DataRow dr = dtCopy.Rows[i];
string strCopyItemID = dr["ITEM_ID"].ToString();
if (!strIsExistItem.Contains(strCopyItemID))
{
TBaseCompanyPointItemVo objPointItem = new TBaseCompanyPointItemVo();
objPointItem.ID = GetSerialNumber("t_base_company_point_item_id");
objPointItem.IS_DEL = "0";
objPointItem.POINT_ID = strPastID;
objPointItem.ITEM_ID = strCopyItemID;
isSuccess = new TBaseCompanyPointItemLogic().Create(objPointItem);
if (isSuccess)
{
new PageBase().WriteLog("新增监测点位明细表", "", new PageBase().LogInfo.UserInfo.USER_NAME + "新增监测点位明细表" + objPointItem.ID + "成功");
}
}
}
if (isSuccess)
{
return("1");
}
else
{
return("0");
}
}
protected void BindList()
{
TBaseItemInfoVo objItem = new TBaseItemInfoVo();
objItem.IS_DEL = "0";
objItem.MONITOR_ID = this.Request["MonitorType"].ToString();
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();
TBaseCompanyPointItemVo objPointItem = new TBaseCompanyPointItemVo();
objPointItem.IS_DEL = "0";
objPointItem.POINT_ID = this.Request["PointID"].ToString();
List <TBaseCompanyPointItemVo> lstPointItem = new TBaseCompanyPointItemLogic().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);
}
}
public static string SaveDataItem(string strPointID, string strSelItem_IDs)
{
bool isSuccess = true;
string[] arrSelItemId = strSelItem_IDs.Split(',');
TBaseCompanyPointItemVo objPointItemSet = new TBaseCompanyPointItemVo();
objPointItemSet.IS_DEL = "1";
TBaseCompanyPointItemVo objPointItemWhere = new TBaseCompanyPointItemVo();
objPointItemWhere.IS_DEL = "0";
objPointItemWhere.POINT_ID = strPointID;
if (new TBaseCompanyPointItemLogic().Edit(objPointItemSet, objPointItemWhere))
{
new PageBase().WriteLog("删除监测点位明细表", "", new PageBase().LogInfo.UserInfo.USER_NAME + "删除监测点位" + strPointID + "的明细表成功");
}
if (strSelItem_IDs.Length > 0)
{
for (int i = 0; i < arrSelItemId.Length; i++)
{
TBaseCompanyPointItemVo objPointItem = new TBaseCompanyPointItemVo();
objPointItem.ID = GetSerialNumber("t_base_company_point_item_id");
objPointItem.IS_DEL = "0";
objPointItem.POINT_ID = strPointID;
objPointItem.ITEM_ID = arrSelItemId[i];
isSuccess = new TBaseCompanyPointItemLogic().Create(objPointItem);
if (isSuccess)
{
new PageBase().WriteLog("新增监测点位明细表", "", new PageBase().LogInfo.UserInfo.USER_NAME + "新增监测点位明细表" + objPointItem.ID + "成功");
}
}
}
if (isSuccess)
{
return("1");
}
else
{
return("0");
}
}
protected void btnImport_Click(object sender, EventArgs e)
{
bool isSuccess = false;
if (this.importFiles.PostedFile.ContentLength <= 0)
{
return;
}
Stream stream = this.importFiles.FileContent;
HSSFWorkbook hssfworkbook = new HSSFWorkbook(stream);
ISheet sheet = hssfworkbook.GetSheet("Sheet1");
string strSql = "";
ArrayList list = new ArrayList();
DataTable dt = RenderFromExcel(sheet, 0);
TBaseCompanyInfoVo CompanyInfoVo = new TBaseCompanyInfoVo();
string strCompanyID = "";
TBaseCompanyPointVo CompanyPointVo = new TBaseCompanyPointVo();
string strCompanyPointID = "";
TBaseCompanyPointItemVo CompanyPointItemVo = new TBaseCompanyPointItemVo();
string strCompanyPointItemID = "";
string[] strArr;
for (int i = 0; i < dt.Rows.Count; i++)
{
strCompanyID = "";
strCompanyPointID = "";
strCompanyPointItemID = "";
CompanyInfoVo = new TBaseCompanyInfoVo();
CompanyInfoVo.COMPANY_NAME = dt.Rows[i][0].ToString().Trim();
CompanyInfoVo.IS_DEL = "0";
CompanyInfoVo = new TBaseCompanyInfoLogic().SelectByObject(CompanyInfoVo);
strCompanyID = CompanyInfoVo.ID;
if (strCompanyID == "")
{
strCompanyID = GetSerialNumber("Company_Id");
CompanyInfoVo.ID = strCompanyID;
CompanyInfoVo.COMPANY_NAME = dt.Rows[i][0].ToString().Trim();
CompanyInfoVo.IS_DEL = "0";
new TBaseCompanyInfoLogic().Create(CompanyInfoVo);
}
CompanyPointVo = new TBaseCompanyPointVo();
CompanyPointVo.COMPANY_ID = strCompanyID;
CompanyPointVo.POINT_NAME = dt.Rows[i][3].ToString().Trim();
CompanyPointVo.MONITOR_ID = dt.Rows[i][4].ToString().Trim();
CompanyPointVo.IS_DEL = "0";
CompanyPointVo = new TBaseCompanyPointLogic().SelectByObject(CompanyPointVo);
strCompanyPointID = CompanyPointVo.ID;
if (strCompanyPointID == "")
{
strCompanyPointID = GetSerialNumber("t_base_company_point_id");
CompanyPointVo.ID = strCompanyPointID;
CompanyPointVo.COMPANY_ID = strCompanyID;
CompanyPointVo.POINT_NAME = dt.Rows[i][3].ToString().Trim();
CompanyPointVo.MONITOR_ID = dt.Rows[i][4].ToString().Trim();
CompanyPointVo.SAMPLE_DAY = dt.Rows[i][1].ToString().Trim();
CompanyPointVo.SAMPLE_FREQ = dt.Rows[i][2].ToString().Trim();
CompanyPointVo.IS_DEL = "0";
new TBaseCompanyPointLogic().Create(CompanyPointVo);
}
else
{
CompanyPointVo.SAMPLE_DAY = dt.Rows[i][1].ToString().Trim();
CompanyPointVo.SAMPLE_FREQ = dt.Rows[i][2].ToString().Trim();
new TBaseCompanyPointLogic().Edit(CompanyPointVo);
}
strArr = dt.Rows[i][5].ToString().Trim().Split(',');
for (int j = 0; j < strArr.Length; j++)
{
strCompanyPointItemID = "";
CompanyPointItemVo = new TBaseCompanyPointItemVo();
CompanyPointItemVo.POINT_ID = strCompanyPointID;
CompanyPointItemVo.ITEM_ID = strArr[j].ToString().Trim();
CompanyPointItemVo.IS_DEL = "0";
CompanyPointItemVo = new TBaseCompanyPointItemLogic().SelectByObject(CompanyPointItemVo);
strCompanyPointItemID = CompanyPointItemVo.ID;
if (strCompanyPointItemID == "")
{
strCompanyPointItemID = GetSerialNumber("t_base_company_point_item_id");
CompanyPointItemVo.ID = strCompanyPointItemID;
CompanyPointItemVo.POINT_ID = strCompanyPointID;
CompanyPointItemVo.ITEM_ID = strArr[j].ToString().Trim();
CompanyPointItemVo.IS_DEL = "0";
new TBaseCompanyPointItemLogic().Create(CompanyPointItemVo);
}
}
}
labMsg.Text = "导入成功!!!!!!!!!!!!!!!!!!";
}
/// <summary>
/// 根据企业点位ID 获取当前点位下的所有监测项目
/// </summary>
/// <param name="tBaseCompanyPointItem"></param>
/// <returns></returns>
public DataTable SelectItemsForPoint(TBaseCompanyPointItemVo tBaseCompanyPointItem)
{
return(access.SelectItemsForPoint(tBaseCompanyPointItem));
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="tBaseCompanyPointItem">对象</param>
/// <returns>是否成功</returns>
public bool Create(TBaseCompanyPointItemVo tBaseCompanyPointItem)
{
string strSQL = SqlHelper.BuildInsertExpress(tBaseCompanyPointItem, TBaseCompanyPointItemVo.T_BASE_COMPANY_POINT_ITEM_TABLE);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 根据对象特征获取单一对象
/// </summary>
/// <param name="tBaseCompanyPointItem">对象</param>
/// <returns></returns>
public TBaseCompanyPointItemVo SelectByObject(TBaseCompanyPointItemVo tBaseCompanyPointItem)
{
return(access.SelectByObject(tBaseCompanyPointItem));
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tBaseCompanyPointItem">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TBaseCompanyPointItemVo tBaseCompanyPointItem, int iIndex, int iCount)
{
return(access.SelectByTable(tBaseCompanyPointItem, iIndex, iCount));
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tBaseCompanyPointItem"></param>
/// <returns></returns>
public DataTable SelectByTable(TBaseCompanyPointItemVo tBaseCompanyPointItem)
{
return(access.SelectByTable(tBaseCompanyPointItem));
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="sysRole">对象</param>
/// <returns>是否成功</returns>
public bool Create(TBaseCompanyPointItemVo tBaseCompanyPointItem)
{
return(access.Create(tBaseCompanyPointItem));
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tBaseCompanyPointItem">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TBaseCompanyPointItemVo> SelectByObject(TBaseCompanyPointItemVo tBaseCompanyPointItem, int iIndex, int iCount)
{
return(access.SelectByObject(tBaseCompanyPointItem, iIndex, iCount));
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tBaseCompanyPointItem">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TBaseCompanyPointItemVo> SelectByObject(TBaseCompanyPointItemVo tBaseCompanyPointItem, int iIndex, int iCount)
{
string strSQL = String.Format("select * from T_BASE_COMPANY_POINT_ITEM " + this.BuildWhereStatement(tBaseCompanyPointItem));
return(SqlHelper.ExecuteObjectList(tBaseCompanyPointItem, BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tBaseCompanyPointItem">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TBaseCompanyPointItemVo tBaseCompanyPointItem)
{
string strSQL = "select Count(*) from T_BASE_COMPANY_POINT_ITEM " + this.BuildWhereStatement(tBaseCompanyPointItem);
return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL)));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tBaseCompanyPointItem">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TBaseCompanyPointItemVo tBaseCompanyPointItem)
{
return(access.Edit(tBaseCompanyPointItem));
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TBaseCompanyPointItemVo tBaseCompanyPointItem)
{
return(access.Delete(tBaseCompanyPointItem));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tBaseCompanyPointItem_UpdateSet">UpdateSet用户对象</param>
/// <param name="tBaseCompanyPointItem_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TBaseCompanyPointItemVo tBaseCompanyPointItem_UpdateSet, TBaseCompanyPointItemVo tBaseCompanyPointItem_UpdateWhere)
{
return(access.Edit(tBaseCompanyPointItem_UpdateSet, tBaseCompanyPointItem_UpdateWhere));
}
/// <summary>
/// 根据对象构造条件语句
/// </summary>
/// <param name="tBaseCompanyPointItem"></param>
/// <returns></returns>
public string BuildWhereStatement(TBaseCompanyPointItemVo tBaseCompanyPointItem)
{
StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 ");
if (null != tBaseCompanyPointItem)
{
//ID
if (!String.IsNullOrEmpty(tBaseCompanyPointItem.ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ID = '{0}'", tBaseCompanyPointItem.ID.ToString()));
}
//监测点ID
if (!String.IsNullOrEmpty(tBaseCompanyPointItem.POINT_ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND POINT_ID = '{0}'", tBaseCompanyPointItem.POINT_ID.ToString()));
}
//监测项目ID
if (!String.IsNullOrEmpty(tBaseCompanyPointItem.ITEM_ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ITEM_ID = '{0}'", tBaseCompanyPointItem.ITEM_ID.ToString()));
}
//已选条件项ID
if (!String.IsNullOrEmpty(tBaseCompanyPointItem.CONDITION_ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND CONDITION_ID = '{0}'", tBaseCompanyPointItem.CONDITION_ID.ToString()));
}
//条件项类型（1，国标；2，行标；3，地标）
if (!String.IsNullOrEmpty(tBaseCompanyPointItem.CONDITION_TYPE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND CONDITION_TYPE = '{0}'", tBaseCompanyPointItem.CONDITION_TYPE.ToString()));
}
//国标上限
if (!String.IsNullOrEmpty(tBaseCompanyPointItem.ST_UPPER.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ST_UPPER = '{0}'", tBaseCompanyPointItem.ST_UPPER.ToString()));
}
//国标下限
if (!String.IsNullOrEmpty(tBaseCompanyPointItem.ST_LOWER.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ST_LOWER = '{0}'", tBaseCompanyPointItem.ST_LOWER.ToString()));
}
//删除标记
if (!String.IsNullOrEmpty(tBaseCompanyPointItem.IS_DEL.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND IS_DEL = '{0}'", tBaseCompanyPointItem.IS_DEL.ToString()));
}
//备注1
if (!String.IsNullOrEmpty(tBaseCompanyPointItem.REMARK1.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tBaseCompanyPointItem.REMARK1.ToString()));
}
//备注2
if (!String.IsNullOrEmpty(tBaseCompanyPointItem.REMARK2.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tBaseCompanyPointItem.REMARK2.ToString()));
}
//备注3
if (!String.IsNullOrEmpty(tBaseCompanyPointItem.REMARK3.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tBaseCompanyPointItem.REMARK3.ToString()));
}
//备注4
if (!String.IsNullOrEmpty(tBaseCompanyPointItem.REMARK4.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK4 = '{0}'", tBaseCompanyPointItem.REMARK4.ToString()));
}
//备注5
if (!String.IsNullOrEmpty(tBaseCompanyPointItem.REMARK5.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK5 = '{0}'", tBaseCompanyPointItem.REMARK5.ToString()));
}
}
return(strWhereStatement.ToString());
}
public TBaseCompanyPointItemLogic(TBaseCompanyPointItemVo _tBaseCompanyPointItem)
{
tBaseCompanyPointItem = _tBaseCompanyPointItem;
access = new TBaseCompanyPointItemAccess();
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tBaseCompanyPointItem">对象条件</param>
/// <returns>对象</returns>
public TBaseCompanyPointItemVo Details(TBaseCompanyPointItemVo tBaseCompanyPointItem)
{
string strSQL = String.Format("select * from T_BASE_COMPANY_POINT_ITEM " + this.BuildWhereStatement(tBaseCompanyPointItem));
return(SqlHelper.ExecuteObject(new TBaseCompanyPointItemVo(), strSQL));
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tBaseCompanyPointItem">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TBaseCompanyPointItemVo tBaseCompanyPointItem)
{
return(access.GetSelectResultCount(tBaseCompanyPointItem));
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tBaseCompanyPointItem"></param>
/// <returns></returns>
public DataTable SelectByTable(TBaseCompanyPointItemVo tBaseCompanyPointItem)
{
string strSQL = "select * from T_BASE_COMPANY_POINT_ITEM " + this.BuildWhereStatement(tBaseCompanyPointItem);
return(SqlHelper.ExecuteDataTable(strSQL));
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tBaseCompanyPointItem">对象条件</param>
/// <returns>对象</returns>
public TBaseCompanyPointItemVo Details(TBaseCompanyPointItemVo tBaseCompanyPointItem)
{
return(access.Details(tBaseCompanyPointItem));
}
