/// <summary> /// Gets all SOH for print out. /// </summary> /// <param name="userId">The user id.</param> /// <param name="year">The year.</param> /// <param name="month">The month.</param> /// <returns></returns> public static DataTable GetAllSOHForPrintOut(int userId, int year, int month) { DataTable datatable = null; Activity stores = new Activity(); stores.LoadByUserID(userId); Balance balance = new Balance(); while(!stores.EOF){ string account = stores.FullActivityName; if(datatable == null){ var query = HCMIS.Repository.Queries.Balance.SelectGetAllSOHForPrintOutInitial(stores.ID); balance.LoadFromRawSql( query ); datatable = balance.DataTable; datatable.Columns.Add("Account"); foreach (DataRow dr in datatable.Rows) { dr["Account"] = account; } }else{ var query = HCMIS.Repository.Queries.Balance.SelectGetAllSOHForPrintOut(stores.ID); balance.LoadFromRawSql(query); DataTable dtbl = balance.DataTable; dtbl.Columns.Add("Account"); foreach(DataRow dr in dtbl.Rows){ dr["Account"] = account; datatable.ImportRow(dr); } } stores.MoveNext(); } return datatable; }
private void OrderDetailForm_Load(object sender, EventArgs e) { Item item = new Item(); item.LoadByPrimaryKey(_itemID); txtItemName.Text = item.FullItemName; ItemUnit iu = new ItemUnit(); iu.LoadByPrimaryKey(_unitID); txtUnit.Text = iu.Text; BLL.Balance balance = new Balance(); gridApprovedPrinted.DataSource = balance.GetApprovedValueForFacility(CurrentContext.UserId, item.ID, iu.ID); gridPicklistPrinted.DataSource = balance.GetPicklistedValueForFacility(CurrentContext.UserId, item.ID, iu.ID); var activities = new Activity(); activities.LoadByUserID(CurrentContext.UserId); DataTable dtbl = null; while (!activities.EOF) { DataTable dt = balance.GetSOHForAnItem(activities.ID, item.ID, iu.ID); if (dt != null && dt.Rows.Count > 0) { dt.Columns.Add("Account"); dt.Rows[0]["Account"] = activities.FullActivityName; if (dtbl == null && Convert.ToInt32(dt.Rows[0]["SOH"]) > 0) { dtbl = dt; } else if (Convert.ToInt32(dt.Rows[0]["SOH"]) > 0) { dtbl.ImportRow(dt.Rows[0]); } } activities.MoveNext(); } gridItemStockStatus.DataSource = dtbl; this.Text = string.Format("({0} - {1}) Details of : {2}", _itemID, _unitID, item.FullItemName); }
private static void BindAllowedActivities(this LookUpEditBase editor) { if (_activities == null) { _activities = new Activity(); _activities.LoadByUserID(CurrentContext.UserId); } editor.Properties.DataSource = _activities.DefaultView; }