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