private string GetSampleCollarInfor()
{
string strJson = "";
DataTable dt = new DataTable();
TOaPartstandCollarVo objItems = new TOaPartstandCollarVo();
TOaPartstandInfoVo objItemParts = new TOaPartstandInfoVo();
//当前页面
int intPageIndex = Convert.ToInt32(Request.Params["page"]);
//每页记录数
int intPageSize = Convert.ToInt32(Request.Params["pagesize"]);
if (!String.IsNullOrEmpty(Request["strPartId"]))
{
objItemParts.ID = Request["strPartId"].ToString();
}
else
{
objItemParts.SAMPLE_CODE = Request["strPartCode"].ToString();
objItemParts.SAMPLE_NAME = Request["strPartName"].ToString();
objItems.REMARK4 = Request["strBeginDate"].ToString();
objItems.REMARK5 = Request["strEndDate"].ToString();
objItems.USER_ID = Request["strReal_Name"].ToString();
}
dt = new TOaPartstandCollarLogic().SelectUnionPartByTable(objItems, objItemParts, intPageIndex, intPageSize);
int CountNum = new TOaPartstandCollarLogic().GetUnionPartByTableCount(objItems, objItemParts);
strJson = CreateToJson(dt, CountNum);
return(strJson);
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tOaPartstandInfo_UpdateSet">UpdateSet用户对象</param>
/// <param name="tOaPartstandInfo_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TOaPartstandInfoVo tOaPartstandInfo_UpdateSet, TOaPartstandInfoVo tOaPartstandInfo_UpdateWhere)
{
string strSQL = SqlHelper.BuildUpdateExpress(tOaPartstandInfo_UpdateSet, TOaPartstandInfoVo.T_OA_PARTSTAND_INFO_TABLE);
strSQL += this.BuildWhereStatement(tOaPartstandInfo_UpdateWhere);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tOaPartstandInfo">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TOaPartstandInfoVo tOaPartstandInfo)
{
string strSQL = SqlHelper.BuildUpdateExpress(tOaPartstandInfo, TOaPartstandInfoVo.T_OA_PARTSTAND_INFO_TABLE);
strSQL += string.Format(" where ID='{0}' ", tOaPartstandInfo.ID);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tOaPartstandInfo">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TOaPartstandInfoVo tOaPartstandInfo, int iIndex, int iCount)
{
string strSQL = " select * from T_OA_PARTSTAND_INFO {0} ";
strSQL = String.Format(strSQL, BuildWhereStatement(tOaPartstandInfo));
return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 获取领用样品明细总记录数
/// </summary>
/// <param name="tOaPartCollar"></param>
/// <param name="tOaPartInfor"></param>
/// <param name="iIndex"></param>
/// <param name="iCount"></param>
/// <returns></returns>
public int GetUnionPartByTableCount(TOaPartstandCollarVo tOaPartstandCollar, TOaPartstandInfoVo tOaPartstandInfor)
{
string strSQL = @" SELECT A.ID,A.SAMPLE_ID,A.USED_QUANTITY,A.USER_ID,A.LASTIN_DATE,A.REASON,B.SAMPLE_NAME,B.SAMPLE_CODE,C.REAL_NAME,C.USER_NAME
FROM T_OA_PARTSTAND_COLLAR A
LEFT JOIN T_OA_PARTSTAND_INFO B ON B.ID=A.SAMPLE_ID
LEFT JOIN T_SYS_USER C ON C.ID=A.USER_ID WHERE 1=1";
if (!String.IsNullOrEmpty(tOaPartstandInfor.ID))
{
strSQL += String.Format(" AND B.ID = '{0}'", tOaPartstandInfor.ID);
}
if (!String.IsNullOrEmpty(tOaPartstandInfor.SAMPLE_CODE))
{
strSQL += String.Format(" AND B.SAMPLE_CODE LIKE '%{0}%'", tOaPartstandInfor.SAMPLE_CODE);
}
if (!String.IsNullOrEmpty(tOaPartstandInfor.SAMPLE_NAME))
{
strSQL += String.Format(" AND B.SAMPLE_NAME LIKE '%{0}%'", tOaPartstandInfor.SAMPLE_NAME);
}
if (!String.IsNullOrEmpty(tOaPartstandCollar.REMARK4) && !String.IsNullOrEmpty(tOaPartstandCollar.REMARK5))
{
strSQL += " AND CONVERT(DATETIME, CONVERT(VARCHAR(100), A.LASTIN_DATE,23),111) ";
strSQL += String.Format(" BETWEEN CONVERT(DATETIME, CONVERT(varchar(100), '{0}',23),111) AND CONVERT(DATETIME, CONVERT(varchar(100), '{1}',23),111)", tOaPartstandCollar.REMARK4, tOaPartstandCollar.REMARK5);
}
if (!String.IsNullOrEmpty(tOaPartstandCollar.USER_ID))
{
strSQL += String.Format(" AND C.REAL_NAME LIKE '%{0}%'", tOaPartstandCollar.USER_ID);
}
return(SqlHelper.ExecuteDataTable(strSQL).Rows.Count);
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TOaPartstandInfoVo tOaPartstandInfo)
{
string strSQL = "delete from T_OA_PARTSTAND_INFO ";
strSQL += this.BuildWhereStatement(tOaPartstandInfo);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tOaPartstandInfo">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTableNew(TOaPartstandInfoVo tOaPartstandInfo, int iIndex, int iCount, bool isZore)
{
string strSQL = " select * from T_OA_PARTSTAND_INFO {0} ";
strSQL = String.Format(strSQL, BuildWhereStatement(tOaPartstandInfo));
if (isZore)
{
strSQL += " AND INVENTORY='0' order by " + tOaPartstandInfo.SORT_FIELD + " " + tOaPartstandInfo.SORT_TYPE;
}
else
{
strSQL += " AND INVENTORY<>'0' order by " + tOaPartstandInfo.SORT_FIELD + " " + tOaPartstandInfo.SORT_TYPE;
}
return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount)));
}
private string getOneGridInfo()
{
string strJson = "";
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
//当前页面
int intPageIndex = Convert.ToInt32(Request.Params["page"]);
//每页记录数
int intPageSize = Convert.ToInt32(Request.Params["pagesize"]);
TOaPartstandInfoVo PartstandInfoVo = new TOaPartstandInfoVo();
PartstandInfoVo.SORT_FIELD = strSortname;
PartstandInfoVo.SORT_TYPE = strSortorder;
if (Request["SAMPLE_CODE"] != null)
{
PartstandInfoVo.SAMPLE_CODE = Request["SAMPLE_CODE"].ToString();
}
if (Request["SAMPLE_NAME"] != null)
{
PartstandInfoVo.SAMPLE_NAME = Request["SAMPLE_NAME"].ToString();
}
if (Request["SAMPLE_TYPE"] != null)
{
PartstandInfoVo.SAMPLE_TYPE = Request["SAMPLE_TYPE"].ToString();
}
if (Request["CLASS_TYPE"] != null)
{
PartstandInfoVo.CLASS_TYPE = Request["CLASS_TYPE"].ToString();
}
DataTable dt = new DataTable();
int intTotalCount = 0;
dt = new TOaPartstandInfoLogic().SelectByTableNew(PartstandInfoVo, intPageIndex, intPageSize, false);
intTotalCount = new TOaPartstandInfoLogic().GetSelectResultCount(PartstandInfoVo);
strJson = CreateToJson(dt, intTotalCount);
return(strJson);
}
/// <summary>
/// 增加数据
/// </summary>
/// <returns></returns>
public string frmAdd()
{
TOaPartstandInfoVo PartstandInfoVo = autoBindRequest(Request, new TOaPartstandInfoVo());
PartstandInfoVo.ID = GetSerialNumber("t_oa_partstand_info_id");
PartstandInfoVo.TOTAL_INVENTORY = PartstandInfoVo.INVENTORY;
string strMsg = "";
bool isSuccess = false;
isSuccess = new TOaPartstandInfoLogic().Create(PartstandInfoVo);
if (isSuccess)
{
strMsg = "数据保存成功";
}
else
{
strMsg = "数据保存失败";
}
return(isSuccess == true ? "{\"result\":\"success\",\"msg\":\"" + strMsg + "\"}" : "{\"result\":\"fail\",\"msg\":\"" + strMsg + "\"}");
}
private string getTwoGridInfo()
{
string strJson = "";
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
//当前页面
int intPageIndex = Convert.ToInt32(Request.Params["page"]);
//每页记录数
int intPageSize = Convert.ToInt32(Request.Params["pagesize"]);
TOaPartstandInfoVo PartstandInfoVo = new TOaPartstandInfoVo();
PartstandInfoVo.SORT_FIELD = strSortname;
PartstandInfoVo.SORT_TYPE = strSortorder;
DataTable dt = new DataTable();
int intTotalCount = 0;
dt = new TOaPartstandInfoLogic().SelectByTableNew(PartstandInfoVo, intPageIndex, intPageSize, true);
intTotalCount = new TOaPartstandInfoLogic().GetSelectResultCount(PartstandInfoVo);
strJson = CreateToJson(dt, intTotalCount);
return(strJson);
}
public DataTable SelectByTableNew(TOaPartstandInfoVo tOaPartstandInfo, int iIndex, int iCount, bool isZore)
{
return(access.SelectByTableNew(tOaPartstandInfo, iIndex, iCount, isZore));
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tOaPartstandInfo">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TOaPartstandInfoVo> SelectByObject(TOaPartstandInfoVo tOaPartstandInfo, int iIndex, int iCount)
{
return(access.SelectByObject(tOaPartstandInfo, iIndex, iCount));
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tOaPartstandInfo">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TOaPartstandInfoVo tOaPartstandInfo, int iIndex, int iCount)
{
return(access.SelectByTable(tOaPartstandInfo, iIndex, iCount));
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tOaPartstandInfo">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TOaPartstandInfoVo tOaPartstandInfo)
{
return(access.GetSelectResultCount(tOaPartstandInfo));
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tOaPartstandInfo">对象条件</param>
/// <returns>对象</returns>
public TOaPartstandInfoVo Details(TOaPartstandInfoVo tOaPartstandInfo)
{
return(access.Details(tOaPartstandInfo));
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="tOaPartstandInfo">对象</param>
/// <returns>是否成功</returns>
public bool Create(TOaPartstandInfoVo tOaPartstandInfo)
{
string strSQL = SqlHelper.BuildInsertExpress(tOaPartstandInfo, TOaPartstandInfoVo.T_OA_PARTSTAND_INFO_TABLE);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tOaPartstandInfo">对象条件</param>
/// <returns>对象</returns>
public TOaPartstandInfoVo Details(TOaPartstandInfoVo tOaPartstandInfo)
{
string strSQL = String.Format("select * from T_OA_PARTSTAND_INFO " + this.BuildWhereStatement(tOaPartstandInfo));
return(SqlHelper.ExecuteObject(new TOaPartstandInfoVo(), strSQL));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tOaPartstandInfo">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TOaPartstandInfoVo tOaPartstandInfo)
{
return(access.Edit(tOaPartstandInfo));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tOaPartstandInfo_UpdateSet">UpdateSet用户对象</param>
/// <param name="tOaPartstandInfo_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TOaPartstandInfoVo tOaPartstandInfo_UpdateSet, TOaPartstandInfoVo tOaPartstandInfo_UpdateWhere)
{
return(access.Edit(tOaPartstandInfo_UpdateSet, tOaPartstandInfo_UpdateWhere));
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tOaPartstandInfo"></param>
/// <returns></returns>
public DataTable SelectByTable(TOaPartstandInfoVo tOaPartstandInfo)
{
string strSQL = "select * from T_OA_PARTSTAND_INFO " + this.BuildWhereStatement(tOaPartstandInfo);
return(SqlHelper.ExecuteDataTable(strSQL));
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="sysRole">对象</param>
/// <returns>是否成功</returns>
public bool Create(TOaPartstandInfoVo tOaPartstandInfo)
{
return(access.Create(tOaPartstandInfo));
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tOaPartstandInfo">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TOaPartstandInfoVo tOaPartstandInfo)
{
string strSQL = "select Count(*) from T_OA_PARTSTAND_INFO " + this.BuildWhereStatement(tOaPartstandInfo);
return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL)));
}
/// <summary>
/// 获取领用样品明细总记录数
/// </summary>
/// <param name="tOaPartCollar"></param>
/// <param name="tOaPartInfor"></param>
/// <param name="iIndex"></param>
/// <param name="iCount"></param>
/// <returns></returns>
public int GetUnionPartByTableCount(TOaPartstandCollarVo tOaPartstandCollar, TOaPartstandInfoVo tOaPartstandInfor)
{
return(access.GetUnionPartByTableCount(tOaPartstandCollar, tOaPartstandInfor));
}
/// <summary>
/// 获取领用样品明细
/// </summary>
/// <param name="tOaPartCollar"></param>
/// <param name="tOaPartInfor"></param>
/// <param name="iIndex"></param>
/// <param name="iCount"></param>
/// <returns></returns>
public DataTable SelectUnionPartByTable(TOaPartstandCollarVo tOaPartstandCollar, TOaPartstandInfoVo tOaPartstandInfor, int iIndex, int iCount)
{
return(access.SelectUnionPartByTable(tOaPartstandCollar, tOaPartstandInfor, iIndex, iCount));
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tOaPartstandInfo"></param>
/// <returns></returns>
public DataTable SelectByTable(TOaPartstandInfoVo tOaPartstandInfo)
{
return(access.SelectByTable(tOaPartstandInfo));
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TOaPartstandInfoVo tOaPartstandInfo)
{
return(access.Delete(tOaPartstandInfo));
}
/// <summary>
/// 根据对象构造条件语句
/// </summary>
/// <param name="tOaPartstandInfo"></param>
/// <returns></returns>
public string BuildWhereStatement(TOaPartstandInfoVo tOaPartstandInfo)
{
StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 ");
if (null != tOaPartstandInfo)
{
//编号
if (!String.IsNullOrEmpty(tOaPartstandInfo.ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ID = '{0}'", tOaPartstandInfo.ID.ToString()));
}
//物料编码
if (!String.IsNullOrEmpty(tOaPartstandInfo.SAMPLE_CODE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND SAMPLE_CODE = '{0}'", tOaPartstandInfo.SAMPLE_CODE.ToString()));
}
//物料类别
if (!String.IsNullOrEmpty(tOaPartstandInfo.SAMPLE_TYPE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND SAMPLE_TYPE = '{0}'", tOaPartstandInfo.SAMPLE_TYPE.ToString()));
}
//物料名称
if (!String.IsNullOrEmpty(tOaPartstandInfo.SAMPLE_NAME.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND SAMPLE_NAME = '{0}'", tOaPartstandInfo.SAMPLE_NAME.ToString()));
}
//单位
if (!String.IsNullOrEmpty(tOaPartstandInfo.UNIT.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND UNIT = '{0}'", tOaPartstandInfo.UNIT.ToString()));
}
//规格型号
if (!String.IsNullOrEmpty(tOaPartstandInfo.CLASS_TYPE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND CLASS_TYPE = '{0}'", tOaPartstandInfo.CLASS_TYPE.ToString()));
}
//库存量
if (!String.IsNullOrEmpty(tOaPartstandInfo.INVENTORY.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND INVENTORY = '{0}'", tOaPartstandInfo.INVENTORY.ToString()));
}
//介质/基体
if (!String.IsNullOrEmpty(tOaPartstandInfo.TOTAL_INVENTORY.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND TOTAL_INVENTORY = '{0}'", tOaPartstandInfo.TOTAL_INVENTORY.ToString()));
}
//
if (!String.IsNullOrEmpty(tOaPartstandInfo.SAMPLE_SOURCE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND SAMPLE_SOURCE = '{0}'", tOaPartstandInfo.SAMPLE_SOURCE.ToString()));
}
//
if (!String.IsNullOrEmpty(tOaPartstandInfo.POTENCY.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND POTENCY = '{0}'", tOaPartstandInfo.POTENCY.ToString()));
}
//分析纯/化学纯
if (!String.IsNullOrEmpty(tOaPartstandInfo.BUY_DATE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND BUY_DATE = '{0}'", tOaPartstandInfo.BUY_DATE.ToString()));
}
//报警值
if (!String.IsNullOrEmpty(tOaPartstandInfo.EFF_DATE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND EFF_DATE = '{0}'", tOaPartstandInfo.EFF_DATE.ToString()));
}
//用途
if (!String.IsNullOrEmpty(tOaPartstandInfo.LEVEL.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND LEVEL = '{0}'", tOaPartstandInfo.LEVEL.ToString()));
}
//技术要求
if (!String.IsNullOrEmpty(tOaPartstandInfo.CARER.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND CARER = '{0}'", tOaPartstandInfo.CARER.ToString()));
}
//备注1
if (!String.IsNullOrEmpty(tOaPartstandInfo.REMARK1.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tOaPartstandInfo.REMARK1.ToString()));
}
//备注2
if (!String.IsNullOrEmpty(tOaPartstandInfo.REMARK2.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tOaPartstandInfo.REMARK2.ToString()));
}
//备注3
if (!String.IsNullOrEmpty(tOaPartstandInfo.REMARK3.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tOaPartstandInfo.REMARK3.ToString()));
}
//备注4
if (!String.IsNullOrEmpty(tOaPartstandInfo.REMARK4.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK4 = '{0}'", tOaPartstandInfo.REMARK4.ToString()));
}
//备注5
if (!String.IsNullOrEmpty(tOaPartstandInfo.REMARK5.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK5 = '{0}'", tOaPartstandInfo.REMARK5.ToString()));
}
}
return(strWhereStatement.ToString());
}
public TOaPartstandInfoLogic(TOaPartstandInfoVo _tOaPartstandInfo)
{
tOaPartstandInfo = _tOaPartstandInfo;
access = new TOaPartstandInfoAccess();
}
/// <summary>
/// 根据对象特征获取单一对象
/// </summary>
/// <param name="tOaPartstandInfo">对象</param>
/// <returns></returns>
public TOaPartstandInfoVo SelectByObject(TOaPartstandInfoVo tOaPartstandInfo)
{
return(access.SelectByObject(tOaPartstandInfo));
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tOaPartstandInfo">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TOaPartstandInfoVo> SelectByObject(TOaPartstandInfoVo tOaPartstandInfo, int iIndex, int iCount)
{
string strSQL = String.Format("select * from T_OA_PARTSTAND_INFO " + this.BuildWhereStatement(tOaPartstandInfo));
return(SqlHelper.ExecuteObjectList(tOaPartstandInfo, BuildPagerExpress(strSQL, iIndex, iCount)));
}
