/// <summary> /// 对象编辑 /// </summary> /// <param name="tOaPartBuyRequst">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TOaPartBuyRequstVo tOaPartBuyRequst) { string strSQL = SqlHelper.BuildUpdateExpress(tOaPartBuyRequst, TOaPartBuyRequstVo.T_OA_PART_BUY_REQUST_TABLE); strSQL += string.Format(" where ID='{0}' ", tOaPartBuyRequst.ID); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tOaPartBuyRequst">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TOaPartBuyRequstVo tOaPartBuyRequst, int iIndex, int iCount) { string strSQL = " select * FROM T_OA_PART_BUY_REQUST {0} "; strSQL = String.Format(strSQL, BuildWhereStatement(tOaPartBuyRequst)); return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount))); }
public static string savePARTPLANData(string PlanBt, string PlanDept, string PlanContent, string PlanType, string UserID) { string strResult = ""; TOaPartBuyRequstVo objPartBuyRequst = new TOaPartBuyRequstVo(); objPartBuyRequst.REMARK1 = "0"; objPartBuyRequst.STATUS = "0"; objPartBuyRequst.APPLY_USER_ID = UserID; objPartBuyRequst.APPLY_DATE = DateTime.Now.ToShortDateString(); objPartBuyRequst.APPLY_TITLE = PlanBt; objPartBuyRequst.APPLY_DEPT_ID = PlanDept; objPartBuyRequst.APPLY_CONTENT = PlanContent; objPartBuyRequst.APPLY_TYPE = PlanType; objPartBuyRequst.ID = GetSerialNumber("t_oa_PartBuyID"); if (new TOaPartBuyRequstLogic().Create(objPartBuyRequst)) { strResult = objPartBuyRequst.ID; } else { strResult = ""; } return(strResult); }
/// <summary> /// 获取对象DataTable,根据物料类型 /// </summary> /// <param name="tOaPartBuyRequst">对象</param> /// /// <param name="tOaPartInfo">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByPart(TOaPartBuyRequstVo tOaPartBuyRequst, TOaPartInfoVo tOaPartInfo, int iIndex, int iCount) { string strSQL = " select distinct C.* FROM T_OA_PART_BUY_REQUST_LST A LEFT JOIN T_OA_PART_INFO B ON B.ID=A.PART_ID LEFT JOIN T_OA_PART_BUY_REQUST C ON C.ID=A.REQUST_ID {0} "; strSQL = String.Format(strSQL, BuildWhereStatementTwo(tOaPartBuyRequst, tOaPartInfo)); return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tOaPartBuyRequst_UpdateSet">UpdateSet用户对象</param> /// <param name="tOaPartBuyRequst_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TOaPartBuyRequstVo tOaPartBuyRequst_UpdateSet, TOaPartBuyRequstVo tOaPartBuyRequst_UpdateWhere) { string strSQL = SqlHelper.BuildUpdateExpress(tOaPartBuyRequst_UpdateSet, TOaPartBuyRequstVo.T_OA_PART_BUY_REQUST_TABLE); strSQL += this.BuildWhereStatement(tOaPartBuyRequst_UpdateWhere); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TOaPartBuyRequstVo tOaPartBuyRequst) { string strSQL = "delete from T_OA_PART_BUY_REQUST "; strSQL += this.BuildWhereStatement(tOaPartBuyRequst); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
void IWFStepRules.CreatAndRegisterBusinessData() { //这里是产生和注册业务数据的地方 if (!String.IsNullOrEmpty(task_id) && String.IsNullOrEmpty(strBtnType)) { TOaPartBuyRequstVo objItems = new TOaPartBuyRequstVo(); objItems.ID = task_id; objItems.STATUS = "9"; objItems.APPLY_TYPE = "02"; objItems.APP_LEADER_ID = this.hidUserId.Value.ToString(); objItems.APP_LEADER_INFO = this.hidOptionContent.Value.ToString(); objItems.APP_LEADER_DATE = this.hidOptionDate.Value.ToString(); if (new TOaPartBuyRequstLogic().Edit(objItems)) { wfControl.SaveInstStepServiceData("申请计划ID", "task_id", task_id, "3"); } else { LigerDialogAlert("数据发送失败!", "error"); return; } //updateAccept(objItems); } else if (!String.IsNullOrEmpty(task_id) && strBtnType == "back") { TOaPartBuyRequstVo objItems = new TOaPartBuyRequstVo(); objItems.ID = task_id; objItems.STATUS = "2"; objItems.APPLY_TYPE = "02"; objItems.APP_LEADER_ID = this.hidUserId.Value.ToString(); objItems.APP_LEADER_INFO = this.hidOptionContent.Value.ToString(); objItems.APP_LEADER_DATE = this.hidOptionDate.Value.ToString(); if (new TOaPartBuyRequstLogic().Edit(objItems)) { wfControl.SaveInstStepServiceData("申请计划ID", "task_id", task_id, "2"); } else { LigerDialogAlert("数据退回失败!", "error"); return; } } }
public static string saveSWData(string Remark5) { string strResult = ""; TOaPartBuyRequstVo objFW = new TOaPartBuyRequstVo(); objFW.REMARK5 = Remark5; objFW.STATUS = "0"; objFW.ID = GetSerialNumber("t_oa_PartBuyID"); if (new TOaPartBuyRequstLogic().Create(objFW)) { strResult = objFW.ID; } else { strResult = ""; } return(strResult); }
void IWFStepRules.CreatAndRegisterBusinessData() { //这里是产生和注册业务数据的地方 if (!String.IsNullOrEmpty(task_id)) { TOaPartBuyRequstVo objItems = new TOaPartBuyRequstVo(); objItems.ID = task_id; objItems.STATUS = "1"; if (new TOaPartBuyRequstLogic().Edit(objItems)) { wfControl.SaveInstStepServiceData("申请计划ID", "task_id", task_id, "1"); } else { LigerDialogAlert("数据发送失败!", "error"); return; } } }
/// <summary> /// 根据对象构造条件语句 /// </summary> /// <param name="tOaPartBuyRequst"></param> /// <returns></returns> public string BuildWhereStatementTwo(TOaPartBuyRequstVo tOaPartBuyRequst, TOaPartInfoVo tOaPartInfo) { StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 "); if (null != tOaPartBuyRequst) { //物料类型 if (!String.IsNullOrEmpty(tOaPartInfo.PART_TYPE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND B.PART_TYPE in ({0})", tOaPartInfo.PART_TYPE.ToString())); } //编号 if (!String.IsNullOrEmpty(tOaPartBuyRequst.ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND C.ID = '{0}'", tOaPartBuyRequst.ID.ToString())); } //申请科室 if (!String.IsNullOrEmpty(tOaPartBuyRequst.APPLY_DEPT_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND C.APPLY_DEPT_ID = '{0}'", tOaPartBuyRequst.APPLY_DEPT_ID.ToString())); } //申请人 if (!String.IsNullOrEmpty(tOaPartBuyRequst.APPLY_USER_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND C.APPLY_USER_ID = '{0}'", tOaPartBuyRequst.APPLY_USER_ID.ToString())); } //状态,1待审批,2待采购,3已采购 if (!String.IsNullOrEmpty(tOaPartBuyRequst.STATUS.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND C.STATUS in ({0})", tOaPartBuyRequst.STATUS.ToString())); } //物料类别 if (!String.IsNullOrEmpty(tOaPartBuyRequst.APPLY_TYPE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND C.APPLY_TYPE in ({0})", tOaPartBuyRequst.APPLY_TYPE.ToString())); } } return(strWhereStatement.ToString()); }
public static string savePARTPLANData(string PlanDept) { string strResult = ""; TOaPartBuyRequstVo objPartBuyRequst = new TOaPartBuyRequstVo(); objPartBuyRequst.REMARK1 = "0"; objPartBuyRequst.STATUS = "0"; objPartBuyRequst.APPLY_DATE = DateTime.Now.ToShortDateString(); objPartBuyRequst.APPLY_DEPT_ID = PlanDept; objPartBuyRequst.ID = GetSerialNumber("t_oa_PartBuyID"); if (new TOaPartBuyRequstLogic().Create(objPartBuyRequst)) { strResult = objPartBuyRequst.ID; } else { strResult = ""; } return(strResult); }
void IWFStepRules.CreatAndRegisterBusinessData() { //这里是产生和注册业务数据的地方 if (!String.IsNullOrEmpty(task_id)) { TOaPartBuyRequstVo objItems = new TOaPartBuyRequstVo(); objItems.ID = task_id; objItems.STATUS = "4"; objItems.APP_LEADER_ID = this.hidUserId.Value.ToString(); objItems.APP_LEADER_INFO = this.hidOptionContent.Value.ToString(); objItems.APP_LEADER_DATE = this.hidOptionDate.Value.ToString(); if (new TOaPartBuyRequstLogic().Edit(objItems)) { wfControl.SaveInstStepServiceData("采购计划ID", "task_id", task_id, "4"); } else { LigerDialogAlert("数据发送失败!", "error"); return; } } }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tOaPartBuyRequst">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TOaPartBuyRequstVo tOaPartBuyRequst) { string strSQL = "select Count(*) from T_OA_PART_BUY_REQUST " + this.BuildWhereStatement(tOaPartBuyRequst); return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL))); }
void IWFStepRules.CreatAndRegisterBusinessData() { //这里是产生和注册业务数据的地方 if (!String.IsNullOrEmpty(task_id)) { TOaPartBuyRequstVo objItems = new TOaPartBuyRequstVo(); if (string.IsNullOrEmpty(this.Task_Order.Value.ToString())) { #region//第一个环节 objItems.ID = task_id; objItems.STATUS = "1"; objItems.REMARK1 = "0"; if (new TOaPartBuyRequstLogic().Edit(objItems)) { wfControl.SaveInstStepServiceData("采购计划ID", "task_id", task_id, "1"); } else { LigerDialogAlert("数据发送失败!", "error"); return; } #endregion } else { #region//第二个环节(科室意见) if (this.Task_Order.Value.ToString().Equals("2")) { objItems.ID = task_id; objItems.REMARK1 = "0"; objItems.APP_DEPT_ID = this.hidUserId.Value.ToString(); objItems.APP_DEPT_INFO = this.hidOptionContent.Value.ToString(); objItems.APP_DEPT_DATE = this.hidOptionDate.Value.ToString(); if (new TOaPartBuyRequstLogic().Edit(objItems)) { wfControl.SaveInstStepServiceData("采购计划ID", "task_id", task_id, "2"); } else { LigerDialogAlert("数据发送失败!", "error"); return; } } #endregion #region//第三个环节(仓管员审核) if (this.Task_Order.Value.ToString().Equals("3")) { objItems.ID = task_id; objItems.REMARK1 = "0"; objItems.STATUS = "9"; objItems.APP_MANAGER_ID = this.hidUserId.Value.ToString(); objItems.APP_MANAGER_INFO = this.hidOptionContent.Value.ToString(); objItems.APP_MANAGER_DATE = this.hidOptionDate.Value.ToString(); if (new TOaPartBuyRequstLogic().Edit(objItems)) { wfControl.SaveInstStepServiceData("采购计划ID", "task_id", task_id, "3"); } else { LigerDialogAlert("数据发送失败!", "error"); return; } } #endregion } } }
void IWFStepRules.CreatAndRegisterBusinessData() { string strStatus = ""; //这里是产生和注册业务数据的地方 TOaPartBuyRequstVo objPartBuyRequst = new TOaPartBuyRequstVo(); if (string.IsNullOrEmpty(this.hidId.Value)) { objPartBuyRequst.ID = GetSerialNumber("t_oa_PartBuyID"); objPartBuyRequst.REMARK1 = "0"; objPartBuyRequst.STATUS = "1"; objPartBuyRequst.APPLY_USER_ID = LogInfo.UserInfo.ID; objPartBuyRequst.APPLY_DATE = DateTime.Now.ToShortDateString(); objPartBuyRequst.APPLY_TITLE = this.PlanBt.Value.Trim(); objPartBuyRequst.APPLY_DEPT_ID = this.PlanDept.SelectedValue; objPartBuyRequst.APPLY_CONTENT = this.PlanContent.Value.Trim(); objPartBuyRequst.APPLY_TYPE = this.hidWF_ID.Value.Trim() == "OW_PARTPLAN" ? "01" : "02"; if (new TOaPartBuyRequstLogic().Create(objPartBuyRequst)) { wfControl.SaveInstStepServiceData("采购计划ID", "task_id", objPartBuyRequst.ID, "1"); //注册编号 wfControl.ServiceCode = "CG" + DateTime.Now.ToString("yyyyMMddHHmmss"); //注册名称 wfControl.ServiceName = "物料采购申请:" + this.PlanBt.Value.Trim(); } else { LigerDialogAlert("数据发送失败!", "error"); return; } } else { objPartBuyRequst.ID = this.hidId.Value.Trim(); switch (this.hidStatus.Value.Trim()) { //申请状态 case "": case "0": strStatus = "1"; objPartBuyRequst.STATUS = strStatus; objPartBuyRequst.APPLY_TITLE = this.PlanBt.Value.Trim(); objPartBuyRequst.APPLY_DEPT_ID = this.PlanDept.SelectedValue; objPartBuyRequst.APPLY_CONTENT = this.PlanContent.Value.Trim(); objPartBuyRequst.APPLY_TYPE = this.hidWF_ID.Value.Trim() == "OW_PARTPLAN" ? "01" : "02"; wfControl.SaveInstStepServiceData("采购计划ID", "task_id", objPartBuyRequst.ID, strStatus); //注册编号 wfControl.ServiceCode = "CG" + DateTime.Now.ToString("yyyyMMddHHmmss"); //注册名称 wfControl.ServiceName = "物料采购申请:" + this.PlanBt.Value.Trim(); break; //科室主任审核 case "1": if (this.hidWF_ID.Value.Trim() == "OW_PARTPLAN") //办公物料 { strStatus = "2"; } else { strStatus = "3"; } objPartBuyRequst.STATUS = strStatus; objPartBuyRequst.APP_DEPT_INFO = this.TestOption.Value.Trim(); objPartBuyRequst.APP_DEPT_ID = LogInfo.UserInfo.ID; objPartBuyRequst.APP_DEPT_DATE = DateTime.Now.ToShortDateString(); wfControl.SaveInstStepServiceData("采购计划ID", "task_id", objPartBuyRequst.ID, strStatus); break; //办公室主任审核 case "2": strStatus = "3"; objPartBuyRequst.STATUS = strStatus; objPartBuyRequst.APP_OFFER_INFO = this.OfficeOption.Value.Trim(); objPartBuyRequst.APP_OFFER_ID = LogInfo.UserInfo.ID; objPartBuyRequst.APP_OFFER_TIME = DateTime.Now.ToShortDateString(); wfControl.SaveInstStepServiceData("采购计划ID", "task_id", objPartBuyRequst.ID, strStatus); break; //仓管审核 case "3": strStatus = "9"; objPartBuyRequst.STATUS = strStatus; objPartBuyRequst.APP_MANAGER_INFO = this.TechOption.Value.Trim(); objPartBuyRequst.APP_MANAGER_ID = LogInfo.UserInfo.ID; objPartBuyRequst.APP_MANAGER_DATE = DateTime.Now.ToShortDateString(); break; } if (new TOaPartBuyRequstLogic().Edit(objPartBuyRequst)) { } else { LigerDialogAlert("数据发送失败!", "error"); return; } } }
protected void btnExport_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); string strType = this.hidGrid.Value.ToString(); string strPartBuyLstId = this.hidExportDate.Value.ToString(); if (!String.IsNullOrEmpty(strType)) { //导出采购计划明细 if (strType == "1") { TOaPartBuyRequstLstVo objItems = new TOaPartBuyRequstLstVo(); TOaPartInfoVo objItemPart = new TOaPartInfoVo(); TOaPartBuyRequstVo objItemBy = new TOaPartBuyRequstVo(); objItemBy.STATUS = "9"; if (!String.IsNullOrEmpty(strPartBuyLstId)) { objItems.ID = strPartBuyLstId.Replace(",", "','"); } objItems.STATUS = "0"; dt = new TOaPartBuyRequstLstLogic().SelectUnionPartByTable(objItems, objItemPart, objItemBy, 0, 0); DataView dv = new DataView(); dv = dt.DefaultView; if (dt.Rows.Count > 0) { dv.Sort = "DELIVERY_DATE"; } FileStream file = new FileStream(HttpContext.Current.Server.MapPath("template/PartPlanDetailSheet.xls"), FileMode.Open, FileAccess.Read); HSSFWorkbook hssfworkbook = new HSSFWorkbook(file); ISheet sheet = hssfworkbook.GetSheet("Sheet1"); sheet.GetRow(2).GetCell(0).SetCellValue("生成日期:" + DateTime.Now.ToString("yyyy-MM-dd")); DataTable dtTemp = new DataTable(); dtTemp = dv.ToTable().Copy();; for (int i = 0; i < dt.Rows.Count; i++) { sheet.GetRow(i + 4).GetCell(0).SetCellValue(dtTemp.Rows[i]["PART_NAME"].ToString()); sheet.GetRow(i + 4).GetCell(1).SetCellValue(dtTemp.Rows[i]["PART_CODE"].ToString()); sheet.GetRow(i + 4).GetCell(2).SetCellValue(dtTemp.Rows[i]["APPLY_TITLE"].ToString()); sheet.GetRow(i + 4).GetCell(3).SetCellValue(dtTemp.Rows[i]["DEPT_NAME"].ToString()); sheet.GetRow(i + 4).GetCell(4).SetCellValue(dtTemp.Rows[i]["REAL_NAME"].ToString()); sheet.GetRow(i + 4).GetCell(5).SetCellValue(dtTemp.Rows[i]["MODELS"].ToString()); sheet.GetRow(i + 4).GetCell(6).SetCellValue(dtTemp.Rows[i]["NEED_QUANTITY"].ToString()); sheet.GetRow(i + 4).GetCell(7).SetCellValue(dtTemp.Rows[i]["DELIVERY_DATE"].ToString()); sheet.GetRow(i + 4).GetCell(8).SetCellValue("¥" + dtTemp.Rows[i]["BUDGET_MONEY"].ToString()); sheet.GetRow(i + 4).GetCell(9).SetCellValue(dtTemp.Rows[i]["REQUEST"].ToString()); sheet.GetRow(i + 4).GetCell(10).SetCellValue(dtTemp.Rows[i]["USEING"].ToString()); } using (MemoryStream stream = new MemoryStream()) { hssfworkbook.Write(stream); HttpContext curContext = HttpContext.Current; // 设置编码和附件格式 curContext.Response.ContentType = "application/vnd.ms-excel"; curContext.Response.ContentEncoding = Encoding.UTF8; curContext.Response.Charset = ""; curContext.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("物料采购计划明细表-" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls", Encoding.UTF8)); curContext.Response.BinaryWrite(stream.GetBuffer()); curContext.Response.End(); } } //导出验收明细 if (strType == "2") { TOaPartAcceptedlistVo objItems = new TOaPartAcceptedlistVo(); if (!String.IsNullOrEmpty(strPartBuyLstId)) { objItems.ID = strPartBuyLstId.Replace(",", "','"); } TOaPartInfoVo objItemPart = new TOaPartInfoVo(); dt = new TOaPartAcceptedlistLogic().SelectUnionByTable(objItems, objItemPart, 0, 0); DataView dv = new DataView(); dv = dt.DefaultView; if (dt.Rows.Count > 0) { dv.Sort = "CHECK_DATE DESC"; } FileStream file = new FileStream(HttpContext.Current.Server.MapPath("template/PartAcceptDetailSheet.xls"), FileMode.Open, FileAccess.Read); HSSFWorkbook hssfworkbook = new HSSFWorkbook(file); ISheet sheet = hssfworkbook.GetSheet("Sheet1"); DataTable dtTemp = new DataTable(); dtTemp = dv.ToTable().Copy();; for (int i = 0; i < dt.Rows.Count; i++) { sheet.GetRow(i + 3).GetCell(0).SetCellValue(dtTemp.Rows[i]["PARTTYPE"].ToString()); sheet.GetRow(i + 3).GetCell(1).SetCellValue(dtTemp.Rows[i]["PART_NAME"].ToString() + "(" + dtTemp.Rows[i]["PART_CODE"].ToString() + ")"); sheet.GetRow(i + 3).GetCell(2).SetCellValue(dtTemp.Rows[i]["ENTERPRISE_NAME"].ToString()); sheet.GetRow(i + 3).GetCell(3).SetCellValue(dtTemp.Rows[i]["NEED_QUANTITY"].ToString()); sheet.GetRow(i + 3).GetCell(4).SetCellValue("¥" + dtTemp.Rows[i]["PRICE"].ToString()); sheet.GetRow(i + 3).GetCell(5).SetCellValue("¥" + dtTemp.Rows[i]["AMOUNT"].ToString()); sheet.GetRow(i + 3).GetCell(6).SetCellValue(dtTemp.Rows[i]["CHECK_DATE"].ToString()); sheet.GetRow(i + 3).GetCell(7).SetCellValue(dtTemp.Rows[i]["RECIVEPART_DATE"].ToString()); sheet.GetRow(i + 3).GetCell(8).SetCellValue(dtTemp.Rows[i]["CHECKRESULT"].ToString()); sheet.GetRow(i + 3).GetCell(9).SetCellValue(dtTemp.Rows[i]["REAL_NAME"].ToString()); sheet.GetRow(i + 3).GetCell(10).SetCellValue(dtTemp.Rows[i]["REMARK1"].ToString()); } using (MemoryStream stream = new MemoryStream()) { hssfworkbook.Write(stream); HttpContext curContext = HttpContext.Current; // 设置编码和附件格式 curContext.Response.ContentType = "application/vnd.ms-excel"; curContext.Response.ContentEncoding = Encoding.UTF8; curContext.Response.Charset = ""; curContext.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("物料验收明细表-" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls", Encoding.UTF8)); curContext.Response.BinaryWrite(stream.GetBuffer()); curContext.Response.End(); } } } }
/// <summary> /// 对象明细 /// </summary> /// <param name="tOaPartBuyRequst">对象条件</param> /// <returns>对象</returns> public TOaPartBuyRequstVo Details(TOaPartBuyRequstVo tOaPartBuyRequst) { return(access.Details(tOaPartBuyRequst)); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tOaPartBuyRequst">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TOaPartBuyRequstVo> SelectByObject(TOaPartBuyRequstVo tOaPartBuyRequst, int iIndex, int iCount) { return(access.SelectByObject(tOaPartBuyRequst, iIndex, iCount)); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tOaPartBuyRequst">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TOaPartBuyRequstVo> SelectByObject(TOaPartBuyRequstVo tOaPartBuyRequst, int iIndex, int iCount) { string strSQL = String.Format("select * from T_OA_PART_BUY_REQUST " + this.BuildWhereStatement(tOaPartBuyRequst)); return(SqlHelper.ExecuteObjectList(tOaPartBuyRequst, BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tOaPartBuyRequst">对象条件</param> /// <returns>对象</returns> public TOaPartBuyRequstVo Details(TOaPartBuyRequstVo tOaPartBuyRequst) { string strSQL = String.Format("select * from T_OA_PART_BUY_REQUST " + this.BuildWhereStatement(tOaPartBuyRequst)); return(SqlHelper.ExecuteObject(new TOaPartBuyRequstVo(), strSQL)); }
/// <summary> /// 获取对象DataTable,根据物料类型 /// </summary> /// <param name="tOaPartBuyRequst">对象</param> /// /// <param name="tOaPartInfo">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByPart(TOaPartBuyRequstVo tOaPartBuyRequst, TOaPartInfoVo tOaPartInfo, int iIndex, int iCount) { return(access.SelectByPart(tOaPartBuyRequst, tOaPartInfo, iIndex, iCount)); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tOaPartBuyRequst">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TOaPartBuyRequstVo tOaPartBuyRequst) { return(access.GetSelectResultCount(tOaPartBuyRequst)); }
public int GetSelectUnionPartByTableResult(TOaPartBuyRequstLstVo tOaPartBuyRequstLst, TOaPartInfoVo tOaPartInfor, TOaPartBuyRequstVo tOaPartBuyRequest) { return(access.GetSelectUnionPartByTableResult(tOaPartBuyRequstLst, tOaPartInfor, tOaPartBuyRequest)); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tOaPartBuyRequst"></param> /// <returns></returns> public DataTable SelectByTable(TOaPartBuyRequstVo tOaPartBuyRequst) { string strSQL = "select * from T_OA_PART_BUY_REQUST " + this.BuildWhereStatement(tOaPartBuyRequst); return(SqlHelper.ExecuteDataTable(strSQL)); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tOaPartBuyRequst">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TOaPartBuyRequstVo tOaPartBuyRequst, int iIndex, int iCount) { return(access.SelectByTable(tOaPartBuyRequst, iIndex, iCount)); }
/// <summary> /// 对象添加 /// </summary> /// <param name="tOaPartBuyRequst">对象</param> /// <returns>是否成功</returns> public bool Create(TOaPartBuyRequstVo tOaPartBuyRequst) { string strSQL = SqlHelper.BuildInsertExpress(tOaPartBuyRequst, TOaPartBuyRequstVo.T_OA_PART_BUY_REQUST_TABLE); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
public DataTable SelectUnionPartByTable(TOaPartBuyRequstLstVo tOaPartBuyRequstLst, TOaPartInfoVo tOaPartInfor, TOaPartBuyRequstVo tOaPartBuyRequest, int iIndex, int iCount) { return(access.SelectUnionPartByTable(tOaPartBuyRequstLst, tOaPartInfor, tOaPartBuyRequest, iIndex, iCount)); }
/// <summary> /// 根据对象构造条件语句 /// </summary> /// <param name="tOaPartBuyRequst"></param> /// <returns></returns> public string BuildWhereStatement(TOaPartBuyRequstVo tOaPartBuyRequst) { StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 "); if (null != tOaPartBuyRequst) { //编号 if (!String.IsNullOrEmpty(tOaPartBuyRequst.ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ID = '{0}'", tOaPartBuyRequst.ID.ToString())); } //申请科室 if (!String.IsNullOrEmpty(tOaPartBuyRequst.APPLY_DEPT_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND APPLY_DEPT_ID = '{0}'", tOaPartBuyRequst.APPLY_DEPT_ID.ToString())); } //申请人 if (!String.IsNullOrEmpty(tOaPartBuyRequst.APPLY_USER_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND APPLY_USER_ID = '{0}'", tOaPartBuyRequst.APPLY_USER_ID.ToString())); } //申请时间 if (!String.IsNullOrEmpty(tOaPartBuyRequst.APPLY_DATE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND APPLY_DATE = '{0}'", tOaPartBuyRequst.APPLY_DATE.ToString())); } //申请标题 if (!String.IsNullOrEmpty(tOaPartBuyRequst.APPLY_TITLE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND APPLY_TITLE = '{0}'", tOaPartBuyRequst.APPLY_TITLE.ToString())); } //部门审批人 if (!String.IsNullOrEmpty(tOaPartBuyRequst.APP_DEPT_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND APP_DEPT_ID = '{0}'", tOaPartBuyRequst.APP_DEPT_ID.ToString())); } //部门审批时间 if (!String.IsNullOrEmpty(tOaPartBuyRequst.APP_DEPT_DATE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND APP_DEPT_DATE = '{0}'", tOaPartBuyRequst.APP_DEPT_DATE.ToString())); } //部门审批意见 if (!String.IsNullOrEmpty(tOaPartBuyRequst.APP_DEPT_INFO.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND APP_DEPT_INFO = '{0}'", tOaPartBuyRequst.APP_DEPT_INFO.ToString())); } //技术负责人审批人 if (!String.IsNullOrEmpty(tOaPartBuyRequst.APP_MANAGER_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND APP_MANAGER_ID = '{0}'", tOaPartBuyRequst.APP_MANAGER_ID.ToString())); } //技术负责人审批时间 if (!String.IsNullOrEmpty(tOaPartBuyRequst.APP_MANAGER_DATE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND APP_MANAGER_DATE = '{0}'", tOaPartBuyRequst.APP_MANAGER_DATE.ToString())); } //技术负责人审批意见 if (!String.IsNullOrEmpty(tOaPartBuyRequst.APP_MANAGER_INFO.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND APP_MANAGER_INFO = '{0}'", tOaPartBuyRequst.APP_MANAGER_INFO.ToString())); } //站长审批人 if (!String.IsNullOrEmpty(tOaPartBuyRequst.APP_LEADER_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND APP_LEADER_ID = '{0}'", tOaPartBuyRequst.APP_LEADER_ID.ToString())); } //站长审批时间 if (!String.IsNullOrEmpty(tOaPartBuyRequst.APP_LEADER_DATE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND APP_LEADER_DATE = '{0}'", tOaPartBuyRequst.APP_LEADER_DATE.ToString())); } //站长审批意见 if (!String.IsNullOrEmpty(tOaPartBuyRequst.APP_LEADER_INFO.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND APP_LEADER_INFO = '{0}'", tOaPartBuyRequst.APP_LEADER_INFO.ToString())); } //状态,1待审批,2待采购,3已采购 if (!String.IsNullOrEmpty(tOaPartBuyRequst.STATUS.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND STATUS in ({0})", tOaPartBuyRequst.STATUS.ToString())); } //备注1 if (!String.IsNullOrEmpty(tOaPartBuyRequst.REMARK1.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tOaPartBuyRequst.REMARK1.ToString())); } //备注2 if (!String.IsNullOrEmpty(tOaPartBuyRequst.REMARK2.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tOaPartBuyRequst.REMARK2.ToString())); } //备注3 if (!String.IsNullOrEmpty(tOaPartBuyRequst.REMARK3.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tOaPartBuyRequst.REMARK3.ToString())); } //备注4 if (!String.IsNullOrEmpty(tOaPartBuyRequst.REMARK4.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK4 = '{0}'", tOaPartBuyRequst.REMARK4.ToString())); } //备注5 if (!String.IsNullOrEmpty(tOaPartBuyRequst.REMARK5.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK5 = '{0}'", tOaPartBuyRequst.REMARK5.ToString())); } //办公室意见 if (!String.IsNullOrEmpty(tOaPartBuyRequst.APP_OFFER_INFO.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND APP_OFFER_INFO = '{0}'", tOaPartBuyRequst.APP_OFFER_INFO.ToString())); } //办公室人 if (!String.IsNullOrEmpty(tOaPartBuyRequst.APP_OFFER_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND APP_OFFER_ID = '{0}'", tOaPartBuyRequst.APP_OFFER_ID.ToString())); } //办公室时间 if (!String.IsNullOrEmpty(tOaPartBuyRequst.APP_OFFER_TIME.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND APP_OFFER_TIME = '{0}'", tOaPartBuyRequst.APP_OFFER_TIME.ToString())); } //物料类别 if (!String.IsNullOrEmpty(tOaPartBuyRequst.APPLY_TYPE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND APPLY_TYPE in ({0})", tOaPartBuyRequst.APPLY_TYPE.ToString())); } //申购内容 if (!String.IsNullOrEmpty(tOaPartBuyRequst.APPLY_CONTENT.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND APPLY_CONTENT = '{0}'", tOaPartBuyRequst.APPLY_CONTENT.ToString())); } } return(strWhereStatement.ToString()); }
/// <summary> /// 获取用户采购计划列表 /// </summary> /// <param name="tOaPartBuyRequstLst"></param> /// <param name="iIndex"></param> /// <param name="iCount"></param> /// <returns></returns> public int GetSelectUnionPartByTableResult(TOaPartBuyRequstLstVo tOaPartBuyRequstLst, TOaPartInfoVo tOaPartInfor, TOaPartBuyRequstVo tOaPartBuyRequest) { string strSQL = @" SELECT A.ID,A.PART_ID,A.NEED_QUANTITY,A.BUDGET_MONEY,CONVERT(DATETIME, CONVERT(VARCHAR(100), A.DELIVERY_DATE,23),111) AS DELIVERY_DATE,A.USERDO,A.STATUS," + " B.PART_CODE,B.PART_TYPE,B.PART_NAME,B.UNIT,B.MODELS,B.INVENTORY,B.MEDIUM,B.PURE," + " B.ALARM,B.REQUEST,B.USEING,B.NARURE," + " C.APPLY_USER_ID,C.APPLY_DEPT_ID,C.APPLY_DATE,C.APPLY_TITLE,D.REAL_NAME,D.USER_NAME,E.DICT_TEXT AS DEPT_NAME" + " FROM dbo.T_OA_PART_BUY_REQUST_LST A " + " LEFT JOIN dbo.T_OA_PART_INFO B ON B.ID=A.PART_ID" + " LEFT JOIN dbo.T_OA_PART_BUY_REQUST C ON C.ID=A.REQUST_ID" + " LEFT JOIN dbo.T_SYS_USER D ON D.ID=C.APPLY_USER_ID" + " LEFT JOIN dbo.T_SYS_DICT E ON E.DICT_CODE=C.APPLY_DEPT_ID AND E.DICT_TYPE='dept'" + " WHERE 1=1 AND B.IS_DEL='0'"; if (!String.IsNullOrEmpty(tOaPartBuyRequstLst.ID)) { strSQL += String.Format(" AND A.ID IN ('{0}')", tOaPartBuyRequstLst.ID); } if (!String.IsNullOrEmpty(tOaPartBuyRequstLst.PART_ID)) { strSQL += String.Format(" AND A.PART_ID='{0}'", tOaPartBuyRequstLst.PART_ID); } if (!String.IsNullOrEmpty(tOaPartBuyRequstLst.REQUST_ID)) { strSQL += String.Format(" AND A.REQUST_ID='{0}'", tOaPartBuyRequstLst.REQUST_ID); } if (!String.IsNullOrEmpty(tOaPartBuyRequstLst.STATUS)) { strSQL += String.Format(" AND A.STATUS='{0}'", tOaPartBuyRequstLst.STATUS); } if (!String.IsNullOrEmpty(tOaPartBuyRequest.STATUS)) { strSQL += String.Format(" AND C.STATUS='{0}'", tOaPartBuyRequest.STATUS); } if (!String.IsNullOrEmpty(tOaPartBuyRequstLst.REMARK3)) { strSQL += String.Format(" AND D.REAL_NAME LIKE '%{0}%' ", tOaPartBuyRequstLst.REMARK3); } if (!String.IsNullOrEmpty(tOaPartBuyRequest.APP_DEPT_ID)) { strSQL += String.Format(" AND C.APPLY_DEPT_ID LIKE '%{0}%'", tOaPartBuyRequest.APP_DEPT_ID); } if (!String.IsNullOrEmpty(tOaPartInfor.PART_CODE)) { strSQL += String.Format(" AND B.PART_CODE LIKE '%{0}%'", tOaPartInfor.PART_CODE); } if (!String.IsNullOrEmpty(tOaPartInfor.PART_NAME)) { strSQL += String.Format(" AND B.PART_NAME LIKE '%{0}%'", tOaPartInfor.PART_NAME); } if (!String.IsNullOrEmpty(tOaPartBuyRequstLst.REMARK4) && !String.IsNullOrEmpty(tOaPartBuyRequstLst.REMARK5)) { strSQL += " CONVERT(DATETIME, CONVERT(VARCHAR(100), A.DELIVERY_DATE,23),111) "; strSQL += String.Format(" BETWEEN CONVERT(DATETIME, CONVERT(varchar(100), '{0}',23),111) AND CONVERT(DATETIME, CONVERT(varchar(100), '{1}',23),111)", tOaPartBuyRequstLst.REMARK4, tOaPartBuyRequstLst.REMARK5); } return(SqlHelper.ExecuteDataTable(strSQL).Rows.Count); }
public TOaPartBuyRequstLogic(TOaPartBuyRequstVo _tOaPartBuyRequst) { tOaPartBuyRequst = _tOaPartBuyRequst; access = new TOaPartBuyRequstAccess(); }