/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tBaseApparatusInfo">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TBaseApparatusInfoVo tBaseApparatusInfo)
{
string strSQL = SqlHelper.BuildUpdateExpress(tBaseApparatusInfo, TBaseApparatusInfoVo.T_BASE_APPARATUS_INFO_TABLE);
strSQL += string.Format(" where ID='{0}' ", tBaseApparatusInfo.ID);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tBaseApparatusInfo">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TBaseApparatusInfoVo tBaseApparatusInfo, int iIndex, int iCount)
{
string strSQL = " select * from T_BASE_APPARATUS_INFO {0} ";
strSQL = String.Format(strSQL, BuildWhereStatement(tBaseApparatusInfo));
return(SqlHelper.ExecuteDataTable(BuildPagerExpress(tBaseApparatusInfo, strSQL, iIndex, iCount)));
}
/// <summary>
/// 自定义查询 Create By Castle(胡方扬) 2012-11-19
/// </summary>
/// <param name="tBaseApparatusInfo">对象</param>
/// <param name="iIndex">起始页</param>
/// <param name="iCount">条数</param>
/// <returns></returns>
public DataTable SelectDefinedTadble(TBaseApparatusInfoVo tBaseApparatusInfo, int iIndex, int iCount)
{
string strSQL = String.Format("SELECT * FROM T_BASE_APPARATUS_INFO WHERE IS_DEL='{0}'", tBaseApparatusInfo.IS_DEL);
if (!String.IsNullOrEmpty(tBaseApparatusInfo.APPARATUS_CODE))
{
strSQL += String.Format(" AND APPARATUS_CODE LIKE '%{0}%'", tBaseApparatusInfo.APPARATUS_CODE);
}
if (!String.IsNullOrEmpty(tBaseApparatusInfo.NAME))
{
strSQL += String.Format(" AND NAME LIKE '%{0}%'", tBaseApparatusInfo.NAME);
}
if (!String.IsNullOrEmpty(tBaseApparatusInfo.MODEL))
{
strSQL += String.Format(" AND MODEL LIKE '%{0}%'", tBaseApparatusInfo.MODEL);
}
if (!String.IsNullOrEmpty(tBaseApparatusInfo.FITTINGS_PROVIDER))
{
strSQL += String.Format(" AND FITTINGS_PROVIDER LIKE '%{0}%'", tBaseApparatusInfo.FITTINGS_PROVIDER);
}
return(SqlHelper.ExecuteDataTable(BuildPagerExpress(tBaseApparatusInfo, strSQL, iIndex, iCount)));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tBaseApparatusInfo_UpdateSet">UpdateSet用户对象</param>
/// <param name="tBaseApparatusInfo_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TBaseApparatusInfoVo tBaseApparatusInfo_UpdateSet, TBaseApparatusInfoVo tBaseApparatusInfo_UpdateWhere)
{
string strSQL = SqlHelper.BuildUpdateExpress(tBaseApparatusInfo_UpdateSet, TBaseApparatusInfoVo.T_BASE_APPARATUS_INFO_TABLE);
strSQL += this.BuildWhereStatement(tBaseApparatusInfo_UpdateWhere);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 获取自定义查询结果总数 Create By Castle(胡方扬) 2012-11-19
/// </summary>
/// <param name="tBaseApparatusInfo">对象</param>
/// <returns></returns>
public int GetSelecDefinedtResultCount(TBaseApparatusInfoVo tBaseApparatusInfo)
{
string strSQL = String.Format("SELECT * FROM T_BASE_APPARATUS_INFO WHERE IS_DEL='{0}'", tBaseApparatusInfo.IS_DEL);
if (!String.IsNullOrEmpty(tBaseApparatusInfo.APPARATUS_CODE))
{
strSQL += String.Format(" AND APPARATUS_CODE LIKE '%{0}%'", tBaseApparatusInfo.APPARATUS_CODE);
}
if (!String.IsNullOrEmpty(tBaseApparatusInfo.NAME))
{
strSQL += String.Format(" AND NAME LIKE '%{0}%'", tBaseApparatusInfo.NAME);
}
if (!String.IsNullOrEmpty(tBaseApparatusInfo.MODEL))
{
strSQL += String.Format(" AND MODEL LIKE '%{0}%'", tBaseApparatusInfo.MODEL);
}
if (!String.IsNullOrEmpty(tBaseApparatusInfo.FITTINGS_PROVIDER))
{
strSQL += String.Format(" AND FITTINGS_PROVIDER LIKE '%{0}%'", tBaseApparatusInfo.FITTINGS_PROVIDER);
}
return(SqlHelper.ExecuteDataTable(strSQL).Rows.Count);
}
/// <summary>
/// 增加数据
/// </summary>
/// <returns></returns>
public string frmAdd()
{
bool isSuccess = false;
TBaseApparatusInfoVo TBaseApparatusInfoVo = autoBindRequest(Request, new TBaseApparatusInfoVo());
TBaseApparatusInfoVo.ID = GetSerialNumber("Apparatus_Id");
TBaseApparatusInfoVo.IS_DEL = "0";
TBaseApparatusInfoVo iApparatusInfoVo = new TBaseApparatusInfoVo();
iApparatusInfoVo.APPARATUS_CODE = TBaseApparatusInfoVo.APPARATUS_CODE;
iApparatusInfoVo.IS_DEL = "0";
iApparatusInfoVo = new TBaseApparatusInfoLogic().Details(iApparatusInfoVo);
if (iApparatusInfoVo.ID.Length > 0)
{
isSuccess = false;
}
else
{
isSuccess = new TBaseApparatusInfoLogic().Create(TBaseApparatusInfoVo);
if (isSuccess)
{
WriteLog(i3.ValueObject.ObjectBase.LogType.AddApparatusInfo, "", LogInfo.UserInfo.USER_NAME + "添加仪器信息" + TBaseApparatusInfoVo.ID + "成功！");
}
}
return(isSuccess == true ? "1" : "0");
}
/// <summary>
/// 获取仪器信息
/// </summary>
/// <returns></returns>
private string getApparatusInfo()
{
int intTotalCount = 0;
DataTable dt = new DataTable();
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
//当前页面
int intPageIndex = Convert.ToInt32(Request.Params["page"]);
//每页记录数
int intPageSize = Convert.ToInt32(Request.Params["pagesize"]);
TBaseApparatusInfoVo TBaseApparatusInfoVo = new TBaseApparatusInfoVo();
TBaseApparatusInfoVo.IS_DEL = "0";
TBaseApparatusInfoVo.SORT_FIELD = strSortname;
TBaseApparatusInfoVo.SORT_TYPE = strSortorder;
//自定义查询使用
TBaseApparatusInfoVo.APPARATUS_CODE = !String.IsNullOrEmpty(Request.Params["srhApparatus_Code"]) ? Request.Params["srhApparatus_Code"].ToString() : "";
TBaseApparatusInfoVo.NAME = !String.IsNullOrEmpty(Request.Params["srh_Name"]) ? Request.Params["srh_Name"].ToString() : "";;
TBaseApparatusInfoVo.MODEL = !String.IsNullOrEmpty(Request.Params["srh_Model"]) ? Request.Params["srh_Model"].ToString() : "";;
TBaseApparatusInfoVo.FITTINGS_PROVIDER = !String.IsNullOrEmpty(Request.Params["srhProvider"]) ? Request.Params["srhProvider"].ToString() : "";;
intTotalCount = new TBaseApparatusInfoLogic().GetSelecDefinedtResultCount(TBaseApparatusInfoVo);
dt = new TBaseApparatusInfoLogic().SelectDefinedTadble(TBaseApparatusInfoVo, intPageIndex, intPageSize);
string strJson = CreateToJson(dt, intTotalCount);
return(strJson);
}
/// <summary>
/// 获取仪器信息
/// </summary>
/// <returns></returns>
private string getApparatusWarn()
{
int intTotalCount = 0;
DataTable dt = new DataTable();
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
//当前页面
int intPageIndex = Convert.ToInt32(Request.Params["page"]);
//每页记录数
int intPageSize = Convert.ToInt32(Request.Params["pagesize"]);
TBaseApparatusInfoVo TBaseApparatusInfoVo = new TBaseApparatusInfoVo();
TBaseApparatusInfoVo.IS_DEL = "0";
TBaseApparatusInfoVo.SORT_FIELD = strSortname;
TBaseApparatusInfoVo.SORT_TYPE = strSortorder;
string strAction = Request.Params["action"];
if (strAction == "ident")
{
//检定报警
dt = new TBaseApparatusInfoLogic().SelectByTable(TBaseApparatusInfoVo, intPageIndex, intPageSize, 2, 1);
intTotalCount = new TBaseApparatusInfoLogic().GetSelectResultCount(TBaseApparatusInfoVo, 2, 1);
}
else
{
//报废报警
dt = new TBaseApparatusInfoLogic().SelectByTable(TBaseApparatusInfoVo, intPageIndex, intPageSize, 2);
intTotalCount = dt.Rows.Count;
}
string strJson = CreateToJson(dt, intTotalCount);
return(strJson);
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TBaseApparatusInfoVo tBaseApparatusInfo)
{
string strSQL = "delete from T_BASE_APPARATUS_INFO ";
strSQL += this.BuildWhereStatement(tBaseApparatusInfo);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 加载数据
/// </summary>
/// <returns></returns>
public string frmLoadData()
{
TBaseApparatusInfoVo TBaseApparatusInfoVo = new TBaseApparatusInfoVo();
TBaseApparatusInfoVo.ID = Request["id"].ToString();
TBaseApparatusInfoVo.IS_DEL = "0";
TBaseApparatusInfoVo TBaseApparatusInfoVoTemp = new TBaseApparatusInfoLogic().Details(TBaseApparatusInfoVo);
return(ToJson(TBaseApparatusInfoVoTemp));
}
/// <summary>
/// 修改数据
/// </summary>
/// <returns></returns>
public string frmUpdate()
{
TBaseApparatusInfoVo TBaseApparatusInfoVo = autoBindRequest(Request, new TBaseApparatusInfoVo());
TBaseApparatusInfoVo.ID = Request["id"].ToString();
TBaseApparatusInfoVo.IS_DEL = "0";
bool isSuccess = new TBaseApparatusInfoLogic().Edit(TBaseApparatusInfoVo);
if (isSuccess)
{
WriteLog(i3.ValueObject.ObjectBase.LogType.EditApparatusInfo, "", LogInfo.UserInfo.USER_NAME + "修改仪器信息" + TBaseApparatusInfoVo.ID + "成功！");
}
return(isSuccess == true ? "1" : "0");
}
/// <summary>
/// 获取对象DataTable Create By weilin 2013-07-24
/// </summary>
/// <param name="tBaseApparatusInfo">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <param name="intIsMonth">1，按月，本月要报废；2，按季度，本季度要报废；3，提前一个月要报废；</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TBaseApparatusInfoVo tBaseApparatusInfo, int iIndex, int iCount, int intIsMonth)
{
string strStartTime = "";
string strEndTime = "";
GetEndTime(intIsMonth, ref strStartTime, ref strEndTime);
string strSQL = " select *";
strSQL += ",case when SCRAP_TIME < '{1}' then '1' else '0' end as is_SCRAP_TIME";
strSQL += " from T_BASE_APPARATUS_INFO {0} ";
strSQL = String.Format(strSQL, BuildWhereStatement(tBaseApparatusInfo) + " and SCRAP_TIME < '" + strEndTime + "'", strEndTime);
return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount)));
}
public static string deleteApparatusInfo(string strValue)
{
TBaseApparatusInfoVo TBaseApparatusInfoVo = new TBaseApparatusInfoVo();
TBaseApparatusInfoVo.ID = strValue;
TBaseApparatusInfoVo.IS_DEL = "1";
bool isSuccess = new TBaseApparatusInfoLogic().Edit(TBaseApparatusInfoVo);
if (isSuccess)
{
new i3.View.PageBase().WriteLog(i3.ValueObject.ObjectBase.LogType.DelApparatusInfo, "", new i3.View.PageBase().LogInfo.UserInfo.USER_NAME + "删除仪器信息" + TBaseApparatusInfoVo.ID + "成功！");
}
return(isSuccess == true ? "1" : "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);
TBaseApparatusInfoVo tav = new TBaseApparatusInfoVo();
//string[] strArr;
for (int i = 0; i < dt.Rows.Count; i++)
{
tav.ID = GetSerialNumber("Apparatus_Id"); //ID
tav.IS_DEL = "0"; //是否删除 0=否，1=是
tav.APPARATUS_CODE = dt.Rows[i + 2][0].ToString().Trim(); //仪器编号
tav.NAME = dt.Rows[i + 2][1].ToString().Trim(); //仪器名称
tav.MODEL = dt.Rows[i + 2][3].ToString().Trim(); //型号规格
tav.MEASURING_RANGE = dt.Rows[i + 2][4].ToString().Trim(); //测量范围
tav.EXPANDED_UNCETAINTY = dt.Rows[i + 2][5].ToString().Trim(); //不确定度
tav.FITTINGS_PROVIDER = dt.Rows[i + 2][6].ToString().Trim(); //供应商
tav.SERIAL_NO = dt.Rows[i + 2][7].ToString().Trim(); //出厂编号
tav.BUY_TIME = dt.Rows[i + 2][8].ToString().Trim(); //购买时间
tav.REMARK2 = dt.Rows[i + 2][9].ToString().Trim(); //金额
tav.POSITION = dt.Rows[i + 2][10].ToString().Trim(); //放置地点（新地点）
tav.REMARK3 = dt.Rows[i + 2][11].ToString().Trim(); //放置地点（旧地点）
new TBaseApparatusInfoLogic().Create(tav);
}
labMsg.Text = "导入成功!!!!!!!!!!!!!!!!!!";
}
/// <summary>
/// 根据对象构造条件语句
/// </summary>
/// <param name="tBaseApparatusInfo"></param>
/// <param name="intIsMonth">1，按月，本月要检定；2，按季度，本季度要检定；3，提前一个月要检定；</param>
/// <param name="intSrcType">1，全部；2，仅检定/校准时间；3，仅期间核查时间；</param>
/// <returns></returns>
public string BuildWhereStatementEx(TBaseApparatusInfoVo tBaseApparatusInfo, int intIsMonth, int intSrcType)
{
StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 ");
if (null != tBaseApparatusInfo)
{
#region other srh condiction
//ID
if (!String.IsNullOrEmpty(tBaseApparatusInfo.ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ID = '{0}'", tBaseApparatusInfo.ID.ToString()));
}
//仪器编号
if (!String.IsNullOrEmpty(tBaseApparatusInfo.APPARATUS_CODE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND APPARATUS_CODE = '{0}'", tBaseApparatusInfo.APPARATUS_CODE.ToString()));
}
//档案类别
if (!String.IsNullOrEmpty(tBaseApparatusInfo.ARCHIVES_TYPE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ARCHIVES_TYPE = '{0}'", tBaseApparatusInfo.ARCHIVES_TYPE.ToString()));
}
//类别1(辅助，非辅助)
if (!String.IsNullOrEmpty(tBaseApparatusInfo.SORT1.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND SORT1 = '{0}'", tBaseApparatusInfo.SORT1.ToString()));
}
//类别2(l流量计，离子计,汽车尾气.......)
if (!String.IsNullOrEmpty(tBaseApparatusInfo.SORT2.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND SORT2 = '{0}'", tBaseApparatusInfo.SORT2.ToString()));
}
//所属仪器或者项目
if (!String.IsNullOrEmpty(tBaseApparatusInfo.BELONG_TO.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND BELONG_TO = '{0}'", tBaseApparatusInfo.BELONG_TO.ToString()));
}
//仪器名称
if (!String.IsNullOrEmpty(tBaseApparatusInfo.NAME.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND NAME = '{0}'", tBaseApparatusInfo.NAME.ToString()));
}
//规格型号
if (!String.IsNullOrEmpty(tBaseApparatusInfo.MODEL.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND MODEL = '{0}'", tBaseApparatusInfo.MODEL.ToString()));
}
//出厂编号
if (!String.IsNullOrEmpty(tBaseApparatusInfo.SERIAL_NO.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND SERIAL_NO = '{0}'", tBaseApparatusInfo.SERIAL_NO.ToString()));
}
//仪器供应商
if (!String.IsNullOrEmpty(tBaseApparatusInfo.APPARATUS_PROVIDER.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND APPARATUS_PROVIDER = '{0}'", tBaseApparatusInfo.APPARATUS_PROVIDER.ToString()));
}
//配件供应商
if (!String.IsNullOrEmpty(tBaseApparatusInfo.FITTINGS_PROVIDER.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND FITTINGS_PROVIDER = '{0}'", tBaseApparatusInfo.FITTINGS_PROVIDER.ToString()));
}
//仪器供应商网址
if (!String.IsNullOrEmpty(tBaseApparatusInfo.WEB_SITE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND WEB_SITE = '{0}'", tBaseApparatusInfo.WEB_SITE.ToString()));
}
//仪器性能(合格,一级合格,正常)
if (!String.IsNullOrEmpty(tBaseApparatusInfo.CAPABILITY.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND CAPABILITY = '{0}'", tBaseApparatusInfo.CAPABILITY.ToString()));
}
//联系人
if (!String.IsNullOrEmpty(tBaseApparatusInfo.LINK_MAN.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND LINK_MAN = '{0}'", tBaseApparatusInfo.LINK_MAN.ToString()));
}
//联系电话
if (!String.IsNullOrEmpty(tBaseApparatusInfo.LINK_PHONE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND LINK_PHONE = '{0}'", tBaseApparatusInfo.LINK_PHONE.ToString()));
}
//邮编
if (!String.IsNullOrEmpty(tBaseApparatusInfo.POST.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND POST = '{0}'", tBaseApparatusInfo.POST.ToString()));
}
//联系地址
if (!String.IsNullOrEmpty(tBaseApparatusInfo.ADDRESS.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ADDRESS = '{0}'", tBaseApparatusInfo.ADDRESS.ToString()));
}
//量值溯源方式(校准、自校、检定)
if (!String.IsNullOrEmpty(tBaseApparatusInfo.CERTIFICATE_TYPE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND CERTIFICATE_TYPE = '{0}'", tBaseApparatusInfo.CERTIFICATE_TYPE.ToString()));
}
//溯源结果(合格，不合格)
if (!String.IsNullOrEmpty(tBaseApparatusInfo.TRACE_RESULT.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND TRACE_RESULT = '{0}'", tBaseApparatusInfo.TRACE_RESULT.ToString()));
}
//检定方式(不检，来检,送检,暂不能检，不详)
if (!String.IsNullOrEmpty(tBaseApparatusInfo.TEST_MODE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND TEST_MODE = '{0}'", tBaseApparatusInfo.TEST_MODE.ToString()));
}
//校正周期
if (!String.IsNullOrEmpty(tBaseApparatusInfo.VERIFY_CYCLE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND VERIFY_CYCLE = '{0}'", tBaseApparatusInfo.VERIFY_CYCLE.ToString()));
}
//使用科室
if (!String.IsNullOrEmpty(tBaseApparatusInfo.DEPT.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND DEPT = '{0}'", tBaseApparatusInfo.DEPT.ToString()));
}
//保管人
if (!String.IsNullOrEmpty(tBaseApparatusInfo.KEEPER.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND KEEPER = '{0}'", tBaseApparatusInfo.KEEPER.ToString()));
}
//放置地点
if (!String.IsNullOrEmpty(tBaseApparatusInfo.POSITION.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND POSITION = '{0}'", tBaseApparatusInfo.POSITION.ToString()));
}
//使用状况(在用，未用)
if (!String.IsNullOrEmpty(tBaseApparatusInfo.STATUS.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND STATUS = '{0}'", tBaseApparatusInfo.STATUS.ToString()));
}
//档案上传地址
if (!String.IsNullOrEmpty(tBaseApparatusInfo.ARCHIVES_ADDRESS.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ARCHIVES_ADDRESS = '{0}'", tBaseApparatusInfo.ARCHIVES_ADDRESS.ToString()));
}
//最近检定/校准时间
if (!String.IsNullOrEmpty(tBaseApparatusInfo.BEGIN_TIME.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND BEGIN_TIME = '{0}'", tBaseApparatusInfo.BEGIN_TIME.ToString()));
}
//扩展不确定度
if (!String.IsNullOrEmpty(tBaseApparatusInfo.EXPANDED_UNCETAINTY.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND EXPANDED_UNCETAINTY = '{0}'", tBaseApparatusInfo.EXPANDED_UNCETAINTY.ToString()));
}
//测量范围
if (!String.IsNullOrEmpty(tBaseApparatusInfo.MEASURING_RANGE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND MEASURING_RANGE = '{0}'", tBaseApparatusInfo.MEASURING_RANGE.ToString()));
}
//检定单位
if (!String.IsNullOrEmpty(tBaseApparatusInfo.EXAMINE_DEPARTMENT.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND EXAMINE_DEPARTMENT = '{0}'", tBaseApparatusInfo.EXAMINE_DEPARTMENT.ToString()));
}
//检定单位电话
if (!String.IsNullOrEmpty(tBaseApparatusInfo.DEPARTMENT_PHONE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND DEPARTMENT_PHONE = '{0}'", tBaseApparatusInfo.DEPARTMENT_PHONE.ToString()));
}
//检定单位联系人
if (!String.IsNullOrEmpty(tBaseApparatusInfo.DEPARTMENT_LINKMAN.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND DEPARTMENT_LINKMAN = '{0}'", tBaseApparatusInfo.DEPARTMENT_LINKMAN.ToString()));
}
//期间核查方式
if (!String.IsNullOrEmpty(tBaseApparatusInfo.VERIFICATION_WAY.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND VERIFICATION_WAY = '{0}'", tBaseApparatusInfo.VERIFICATION_WAY.ToString()));
}
//期间核查结果
if (!String.IsNullOrEmpty(tBaseApparatusInfo.VERIFICATION_RESULT.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND VERIFICATION_RESULT = '{0}'", tBaseApparatusInfo.VERIFICATION_RESULT.ToString()));
}
//最近期间核查时间
if (!String.IsNullOrEmpty(tBaseApparatusInfo.VERIFICATION_BEGIN_TIME.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND VERIFICATION_BEGIN_TIME = '{0}'", tBaseApparatusInfo.VERIFICATION_BEGIN_TIME.ToString()));
}
//备注1
if (!String.IsNullOrEmpty(tBaseApparatusInfo.IS_DEL.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND IS_DEL = '{0}'", tBaseApparatusInfo.IS_DEL.ToString()));
}
//备注1
if (!String.IsNullOrEmpty(tBaseApparatusInfo.REMARK1.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tBaseApparatusInfo.REMARK1.ToString()));
}
//备注2
if (!String.IsNullOrEmpty(tBaseApparatusInfo.REMARK2.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tBaseApparatusInfo.REMARK2.ToString()));
}
//备注3
if (!String.IsNullOrEmpty(tBaseApparatusInfo.REMARK3.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tBaseApparatusInfo.REMARK3.ToString()));
}
//备注4
if (!String.IsNullOrEmpty(tBaseApparatusInfo.REMARK4.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK4 = '{0}'", tBaseApparatusInfo.REMARK4.ToString()));
}
//备注5
if (!String.IsNullOrEmpty(tBaseApparatusInfo.REMARK5.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK5 = '{0}'", tBaseApparatusInfo.REMARK5.ToString()));
}
#endregion
string strStartTime = "";
string strEndTime = "";
GetEndTime(intIsMonth, ref strStartTime, ref strEndTime);
if (intSrcType == 1)
{
strWhereStatement.Append(string.Format(" AND (END_TIME < '{0}'", strEndTime));
strWhereStatement.Append(string.Format(" OR VERIFICATION_END_TIME < '{0}')", strEndTime));
}
if (intSrcType == 2)
{
strWhereStatement.Append(string.Format(" AND END_TIME < '{0}'", strEndTime));
}
if (intSrcType == 3)
{
strWhereStatement.Append(string.Format(" AND VERIFICATION_END_TIME < '{0}'", strEndTime));
}
}
return(strWhereStatement.ToString());
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TBaseApparatusInfoVo tBaseApparatusInfo)
{
return(access.Delete(tBaseApparatusInfo));
}
/// <summary>
/// 自定义查询 Create By Castle(胡方扬) 2012-11-19
/// </summary>
/// <param name="tBaseEvaluationInfo">对象</param>
/// <param name="iIndex">起始页</param>
/// <param name="iCount">条数</param>
/// <returns></returns>
public DataTable SelectDefinedTadble(TBaseApparatusInfoVo tBaseApparatusInfo, int iIndex, int iCount)
{
return(access.SelectDefinedTadble(tBaseApparatusInfo, iIndex, iCount));
}
/// <summary>
/// 获取对象DataTable Create By weilin 2013-07-24
/// </summary>
/// <param name="tBaseApparatusInfo">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <param name="intIsMonth">1，按月，本月要检定；2，按季度，本季度要检定；3，提前一个月要检定；</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TBaseApparatusInfoVo tBaseApparatusInfo, int iIndex, int iCount, int intIsMonth)
{
return(access.SelectByTable(tBaseApparatusInfo, iIndex, iCount, intIsMonth));
}
protected void ExcelExportIn(string excelFilePath)
{
try
{
#region excel 打开工作簿
FileStream file = new FileStream(excelFilePath, FileMode.Open, FileAccess.Read);
HSSFWorkbook hssfworkbook = new HSSFWorkbook(file);
ISheet mySheet = hssfworkbook.GetSheetAt(0);
#endregion
//选择导入的信息
string strExportIndex = this.SelectExportInfo.SelectedValue;
//定义错误日志
//string strLog = "";
//定义错误数
int ErrorCount = 0;
//定义导入对象数组
ArrayList arrVo = new ArrayList();
if (strExportIndex == "0")//仪器
{
for (int i = 1; ; i++)
{
IRow row = mySheet.GetRow(i);
if (row == null)
{
break;
}
string cell1 = row.GetCell(1) != null?row.GetCell(1).ToString() : ""; //名称
string cell2 = row.GetCell(2) != null?row.GetCell(2).ToString() : ""; //性别
string cell3 = row.GetCell(3) != null?row.GetCell(3).ToString() : ""; //年龄
string cell4 = row.GetCell(4) != null?row.GetCell(4).ToString() : ""; //出生
string cell5 = row.GetCell(5) != null?row.GetCell(5).ToString() : ""; //身份证
string cell6 = row.GetCell(6) != null?row.GetCell(6).ToString() : ""; //政治面貌
string cell7 = row.GetCell(7) != null?row.GetCell(7).ToString() : ""; //学历
string cell8 = row.GetCell(8) != null?row.GetCell(8).ToString() : ""; //专业
string cell9 = row.GetCell(9) != null?row.GetCell(9).ToString() : ""; //职称
string cell10 = row.GetCell(10) != null?row.GetCell(10).ToString() : ""; //城市
string cell11 = row.GetCell(11) != null?row.GetCell(11).ToString() : ""; //单位
string cell12 = row.GetCell(12) != null?row.GetCell(12).ToString() : ""; //参加工作时间
TBaseApparatusInfoVo objvo = new TBaseApparatusInfoVo();
objvo.NAME = cell1.ToString().Replace("\n", "").Replace(" ", ""); //仪器名称
objvo.MODEL = cell2.ToString().Replace("\n", "").Replace(" ", ""); //规格
objvo.SERIAL_NO = cell3.ToString().Replace("\n", "").Replace(" ", ""); //出厂编号
objvo.APPARATUS_PROVIDER = cell4.ToString().Replace("\n", "").Replace(" ", ""); //生产商
objvo.BUY_TIME = cell6.ToString().Replace("\n", "").Replace(" ", ""); //购置时间
objvo.APPARATUS_CODE = cell8.ToString().Replace("\n", "").Replace(" ", ""); //管理编号
objvo.POSITION = cell10.ToString().Replace("\n", "").Replace(" ", ""); //地点
objvo.KEEPER = cell11.ToString().Replace("\n", "").Replace(" ", ""); //保管人
objvo.REMARK1 = cell12.ToString().Replace("\n", "").Replace(" ", ""); //备注
objvo.IS_DEL = "0";
if (cell1.ToString() == "")
{
break;
}
if (!ItemExist(objvo))
{
arrVo.Add(objvo);
}
}
//批量保存数据
if (ErrorCount <= 0)
{
if (new TBaseApparatusInfoLogic().SaveData(arrVo))
{
Alert("导入完成！");
}
}
}
else if (strExportIndex == "1")//点位
{
for (int i = 1; ; i++)
{
IRow row = mySheet.GetRow(i);
if (row == null)
{
break;
}
string cell0 = row.GetCell(0) != null?row.GetCell(0).ToString().Replace("\n", "").Replace(" ", "") : ""; //企业ID
string cell1 = row.GetCell(1) != null?row.GetCell(1).ToString().Replace("\n", "").Replace(" ", "") : ""; //企业名称
string cell2 = row.GetCell(2) != null?row.GetCell(2).ToString().Replace("\n", "").Replace(" ", "") : ""; //点位信息
if (cell2.Length > 0)
{
int intNum = 0; //点位序号
string[] strMonitor = cell2.Split(';'); //监测类别
foreach (string str in strMonitor)
{
string[] strPoint = str.Split(':');//监测类别与点位分隔
//点位信息
string[] strPointInfo = strPoint[1].ToString().Split('、');
foreach (string Point in strPointInfo)
{
//点位信息处理
TBaseCompanyPointVo objvo = new TBaseCompanyPointVo();
intNum++;
objvo.MONITOR_ID = strPoint[0].ToString();
objvo.POINT_NAME = Point;
objvo.POINT_TYPE = "01";
objvo.FREQ = "1";
objvo.COMPANY_ID = cell0.ToString();
objvo.IS_DEL = "0";
objvo.NUM = intNum.ToString();
arrVo.Add(objvo);
}
}
}
if (cell0.ToString() == "")
{
break;
}
}
//批量保存数据
if (ErrorCount <= 0)
{
if (new TBaseCompanyPointLogic().SaveData(arrVo))
{
Alert("导入完成！");
}
}
}
#region excel 关闭 释放资源
System.GC.Collect();
#endregion
}
catch (Exception ex)
{
Alert("<script>alert('未能读取Excel，请稍候再试！" + ex.Message + "')</script>");
}
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="tBaseApparatusInfo">对象</param>
/// <returns>是否成功</returns>
public bool Create(TBaseApparatusInfoVo tBaseApparatusInfo)
{
string strSQL = SqlHelper.BuildInsertExpress(tBaseApparatusInfo, TBaseApparatusInfoVo.T_BASE_APPARATUS_INFO_TABLE);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tBaseApparatusInfo"></param>
/// <returns></returns>
public DataTable SelectByTable(TBaseApparatusInfoVo tBaseApparatusInfo)
{
string strSQL = "select * from T_BASE_APPARATUS_INFO " + this.BuildWhereStatement(tBaseApparatusInfo);
return(SqlHelper.ExecuteDataTable(strSQL));
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tBaseApparatusInfo">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TBaseApparatusInfoVo tBaseApparatusInfo)
{
return(access.GetSelectResultCount(tBaseApparatusInfo));
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tBaseApparatusInfo">对象条件</param>
/// <returns>对象</returns>
public TBaseApparatusInfoVo Details(TBaseApparatusInfoVo tBaseApparatusInfo)
{
return(access.Details(tBaseApparatusInfo));
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tBaseApparatusInfo">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TBaseApparatusInfoVo> SelectByObject(TBaseApparatusInfoVo tBaseApparatusInfo, int iIndex, int iCount)
{
return(access.SelectByObject(tBaseApparatusInfo, iIndex, iCount));
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tBaseApparatusInfo">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TBaseApparatusInfoVo tBaseApparatusInfo)
{
string strSQL = "select Count(*) from T_BASE_APPARATUS_INFO " + this.BuildWhereStatement(tBaseApparatusInfo);
return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL)));
}
public TBaseApparatusInfoLogic(TBaseApparatusInfoVo _tBaseApparatusInfo)
{
tBaseApparatusInfo = _tBaseApparatusInfo;
access = new TBaseApparatusInfoAccess();
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tBaseApparatusInfo">对象条件</param>
/// <returns>对象</returns>
public TBaseApparatusInfoVo Details(TBaseApparatusInfoVo tBaseApparatusInfo)
{
string strSQL = String.Format("select * from T_BASE_APPARATUS_INFO " + this.BuildWhereStatement(tBaseApparatusInfo));
return(SqlHelper.ExecuteObject(new TBaseApparatusInfoVo(), strSQL));
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tBaseApparatusInfo">对象</param>
/// <param name="intIsMonth">1，按月，本月要检定；2，按季度，本季度要检定；3，提前一个月要检定；</param>
/// <param name="intSrcType">1，全部；2，仅检定/校准时间；3，仅期间核查时间；</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TBaseApparatusInfoVo tBaseApparatusInfo, int intIsMonth, int intSrcType)
{
return(access.GetSelectResultCount(tBaseApparatusInfo, intIsMonth, intSrcType));
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tBaseApparatusInfo">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TBaseApparatusInfoVo> SelectByObject(TBaseApparatusInfoVo tBaseApparatusInfo, int iIndex, int iCount)
{
string strSQL = String.Format("select * from T_BASE_APPARATUS_INFO " + this.BuildWhereStatement(tBaseApparatusInfo));
return(SqlHelper.ExecuteObjectList(tBaseApparatusInfo, BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 判断存在性
/// </summary>
/// <param name="strType"></param>
/// <param name="strItem"></param>
/// <param name="strMethod"></param>
protected bool ItemExist(TBaseApparatusInfoVo objItemVo)
{
return(new TBaseApparatusInfoLogic().GetSelectResultCount(objItemVo) > 0 ? true : false);
}
