public string getNewAppNo() { try { //得到最大请假单号 string maxNo = dal.getMaxAppNo(); string nextNo = string.Empty; if (maxNo.Equals(string.Empty)) { nextNo = UtilDatetime.FormatDate3(DateTime.Now) + ("1").PadLeft(3, '0'); } else { nextNo = Convert.ToString(Convert.ToDouble(maxNo) + 1); } return(nextNo); } catch (UtilException ex) { throw ex; } catch (Exception ex) { throw new UtilException(ex.Message, ex); } }
public string getMaxAppNo() { try { string t = UtilDatetime.FormatDate3(DateTime.Now); var q = (from p in gDB.totaplctns where p.apno.Contains(t) select p.apno).Max(); if (q == null) { return(string.Empty); } return(q.ToString()); } catch (UtilException ex) { throw ex; } catch (Exception ex) { throw new UtilException(ex.Message, ex); } }
//public void delete() //{ // string msg = string.Empty; // try // { // PeriodBll periodBll = new PeriodBll(); // string year = Request.Form["Year"]; // string period = Request.Form["Period"]; // Exception_ErrorMessage error = periodBll.DeletePeriod(year, period); // if (error == Exception_ErrorMessage.NoError) // { // msg = "{status:'success',msg:'" + HRMSRes.Public_Message_DeleteWell + "'}"; // } // } // catch (Exception ex) // { // msg = "{status:'failure',msg:'" + HRMSRes.Public_Message_DeleteBad + "'}"; // } // Response.Output.Write(msg); //} public void list() { string message = string.Empty; try { string record = this.Request["record"]; string startStr = this.Request["start"]; string limitStr = this.Request["limit"]; if ((record == null) || (record.Length < 1)) { record = "{\"year\":\"" + UtilDatetime.FormatDate3(DateTime.Now).Substring(0, 4) + "\"}"; } Hashtable ht = JavaScriptConvert.DeserializeObject <Hashtable>(record); int start = 0; if (startStr != null) { start = Convert.ToInt32(startStr); } int limit = 0; if (limitStr != null) { limit = Convert.ToInt32(limitStr); } stperiodBll bll = new stperiodBll(); List <ColumnInfo> parameters = new List <ColumnInfo>() { new ColumnInfo() { ColumnName = "year", ColumnValue = ht["year"].ToString() } }; int total = 0; List <tstperiod> periodList = bll.GetSelectedRecords <tstperiod>(parameters, true, start, start + limit, ref total); string json = JavaScriptConvert.SerializeObject(periodList); json = "{results:" + total + ",rows:" + json + "}"; Response.Write(json); } catch (Exception ex) { message = "{status:'failure',msg:'" + ExceptionPaser.Parse(HRMSRes.Public_Message_QueryFail, ex, true) + "'}"; Response.Output.Write(message); } }
public void exportExcel() { string message = string.Empty; try { string record = this.Request["record"]; string header = this.Request["header"]; if ((record == null) || (record.Length < 1)) { record = "{\"year\":\"" + UtilDatetime.FormatDate3(DateTime.Now).Substring(0, 4) + "\"}"; } if (header == null || header.Equals(string.Empty)) { return; } Hashtable ht = JavaScriptConvert.DeserializeObject <Hashtable>(record); List <ColumnInfo> headers = JavaScriptConvert.DeserializeObject <List <ColumnInfo> >(header); stperiodBll bll = new stperiodBll(); List <ColumnInfo> parameters = new List <ColumnInfo>() { new ColumnInfo() { ColumnName = "year", ColumnValue = ht["year"].ToString() } }; List <tstperiod> yearList = bll.GetSelectedRecords <tstperiod>(parameters); if (yearList != null) { UtilExcel.ExportToExcel(Response, this.GetType().Name.GetPageName(), headers, yearList); } } catch (Exception ex) { message = "{status:'failure',msg:'" + ExceptionPaser.Parse(HRMSRes.Public_Message_ExportExcelFail, ex, true) + "'}"; Response.Output.Write(message); } }