protected void Page_Load(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(Request.QueryString["ID"]))
{
Response.End();
return;
}
int ID = 0;
if (!int.TryParse(Request.QueryString["ID"], out ID))
{
Response.End();
return;
}
roomfeeOrder = Foresight.DataAccess.RoomFeeOrder.GetRoomFeeOrder(ID);
if (roomfeeOrder == null)
{
Response.End();
return;
}
if (roomfeeOrder.ApproveStatus != 0)
{
SetInfo(roomfeeOrder);
}
else
{
this.tdApproveTime.Value = DateTime.Now.ToString("yyyy-MM-dd");
this.tdApproveMan.Value = WebUtil.GetUser(this.Context).RealName;
this.hdApproveUserID.Value = WebUtil.GetUser(this.Context).UserID.ToString();
}
SetSearchInfo(roomfeeOrder);
}
private void SetInfo(Foresight.DataAccess.RoomFeeOrder data)
{
this.tdApproveTime.Value = data.ApproveTime == DateTime.MinValue ? "" : data.ApproveTime.ToString("yyyy-MM-dd HH:mm:ss");
this.tdApproveMan.Value = data.ApproveMan;
this.hdApproveUserID.Value = data.ApproveManUserID == int.MinValue ? "" : data.ApproveManUserID.ToString();
this.tdApproveStatus.Value = data.ApproveStatus.ToString();
this.tdApproveRemark.Value = data.ApproveRemark;
}
public static string GetLastestRoomFeeOrderNumber(string OrderTypeName, int RoomID, SqlHelper helper, out int OrderNumberID)
{
if (string.IsNullOrEmpty(OrderTypeName))
{
OrderTypeName = Foresight.DataAccess.OrderTypeNameDefine.roomfeeorder.ToString();
}
Sys_OrderNumber sysOrderNumber = Sys_OrderNumber.GetSys_OrderNumberByRoomID(OrderTypeName, RoomID, helper);
if (sysOrderNumber == null)
{
OrderNumberID = 0;
return(string.Empty);
}
OrderNumberID = sysOrderNumber.ID;
RoomFeeOrder history = RoomFeeOrder.GetLastRoomFeeOrder(OrderNumberID, helper);
string Part1 = string.Empty;
Part1 += sysOrderNumber.OrderPrefix;
string time_yyyy = DateTime.Now.ToString("yyyy");
string time_mm = DateTime.Now.ToString("MM");
string time_dd = DateTime.Now.ToString("dd");
if (sysOrderNumber.UseYear)
{
Part1 += time_yyyy;
}
if (sysOrderNumber.UseMonth)
{
Part1 += time_mm;
}
if (sysOrderNumber.UseDay)
{
Part1 += time_dd;
}
int OrderNumberCount = sysOrderNumber.OrderNumberCount <= 0 ? 3 : sysOrderNumber.OrderNumberCount;
int number = 1;
if (history != null && !string.IsNullOrEmpty(history.OrderNumber))
{
number = PrintRoomFeeHistory.GetOrderNumberBySysOrder(history.OrderNumber, sysOrderNumber, out OrderNumberCount);
}
return(Part1 + number.ToString("D" + OrderNumberCount));
}
private void SetSearchInfo(Foresight.DataAccess.RoomFeeOrder data)
{
if (!string.IsNullOrEmpty(data.ProjectID))
{
int[] ProjectIDList = data.ProjectID.Split(',').Select(p =>
{
int _ID = 0;
int.TryParse(p, out _ID);
return(_ID);
}).ToArray();
var projects = Foresight.DataAccess.Project.GetProjectListByIDs(ProjectIDList.ToList());
var NameList = projects.Select(p => !string.IsNullOrEmpty(p.FullName) ? p.FullName : p.Name).ToArray();
this.tdProjectName.InnerHtml = string.Join("|", NameList);
}
this.tdAddMan.Value = data.OrderUserMan;
this.tdOrderTime.Value = data.OrderTime != DateTime.MinValue ? data.OrderTime.ToString("yyyy-MM-dd HH:mm:ss") : "";
this.tdStartTime.Value = data.ChargeStartTime != DateTime.MinValue ? data.ChargeStartTime.ToString("yyyy-MM-dd HH:mm:ss") : "";
this.tdEndTime.Value = data.ChargeEndTime != DateTime.MinValue ? data.ChargeEndTime.ToString("yyyy-MM-dd HH:mm:ss") : "";
this.tdOperator.Value = data.Operator;
}
public static Ui.DataGrid GeRoomFeeOrderGridByKeywords(DateTime StartTime, DateTime EndTime, List <int> AddManList, List <int> ApproveManList, List <int> ApproveStatusList, string orderBy, long startRowIndex, int pageSize)
{
long totalRows = 0;
List <SqlParameter> parameters = new List <SqlParameter>();
List <string> conditions = new List <string>();
conditions.Add("1=1");
if (StartTime > DateTime.MinValue)
{
conditions.Add("[OrderTime]>=@StartTime");
parameters.Add(new SqlParameter("@StartTime", StartTime));
}
if (EndTime > DateTime.MinValue)
{
conditions.Add("[OrderTime]<=@EndTime");
parameters.Add(new SqlParameter("@EndTime", EndTime));
}
if (AddManList.Count > 0)
{
conditions.Add("[OrderUserID] in (" + string.Join(",", AddManList.ToArray()) + ")");
}
if (ApproveManList.Count > 0)
{
conditions.Add("[ApproveManUserID] in (" + string.Join(",", ApproveManList.ToArray()) + ")");
}
if (ApproveStatusList.Count > 0)
{
conditions.Add("[ApproveStatus] in (" + string.Join(",", ApproveStatusList.ToArray()) + ")");
}
string fieldList = "[RoomFeeOrder].* ";
string Statement = " from [RoomFeeOrder] where " + string.Join(" and ", conditions.ToArray());
RoomFeeOrder[] list = new RoomFeeOrder[] { };
list = GetList <RoomFeeOrder>(fieldList, Statement, parameters, orderBy, startRowIndex, pageSize, out totalRows).ToArray();
DataAccess.Ui.DataGrid dg = new Ui.DataGrid();
dg.rows = list;
dg.total = totalRows;
dg.page = pageSize;
return(dg);
}
