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