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);
}
}