public void LoadReturn() { Return e = new Return(); if (ReturnID == 0) { imgOrder.ImageUrl = "none"; btnOk.Enabled = true; } else { e = ReturnBLL.Get(ReturnID); imgOrder.ImageUrl = BarcodeBLL.Url4Return(e.ID); btnOk.Enabled = false; } txtNote.Text = e.Note; txtDate.Text = e.Date.ToStringVN_Hour(); PackOrderList = e.PackOrders.Select(r => r.ID).ToList(); urlPrint.NavigateUrl = ResolveClientUrl(string.Format("~/Store/PrintReturn.aspx?ReturnID={0}", e.ID)); GridViewPack.DataBind(); CurrentDIN = ""; imgCurrentDIN.ImageUrl = "none"; GridViewSum.DataBind(); }
void ShowInfo() { RedBloodDataContext db = new RedBloodDataContext(); var v = db.Packs.Where(r => PackList.Contains(r.ID)) .Select(r => new { r.ID, DIN = r.Donation.DIN, r.ProductCode, }).ToList(); DataListPack.DataSource = v; DataListPack.DataBind(); GridViewSum.DataSource = v.GroupBy(r => r.ProductCode) .Select(r => new { ProductCode = r.Key, Sum = r.Count() }); GridViewSum.DataBind(); CurrentDIN = ""; imgCurrentDIN.ImageUrl = "none"; }
public void LoadDelete() { Delete e = new Delete(); if (DeleteID == 0) { imgOrder.ImageUrl = "none"; btnOk.Enabled = true; } else { e = DeleteBLL.Get(DeleteID); imgOrder.ImageUrl = BarcodeBLL.Url4Delete(e.ID); btnOk.Enabled = false; } txtNote.Text = e.Note; txtDate.Text = e.Date.ToStringVN_Hour(); PackList = e.Packs.Select(r => r.ID).ToList(); GridViewPack.DataBind(); CurrentDIN = ""; imgCurrentDIN.ImageUrl = "none"; urlPrint.NavigateUrl = ResolveClientUrl(string.Format("~/Store/PrintDelete.aspx?DeleteID={0}", e.ID)); GridViewSum.DataBind(); }
void AddPack(string productCode) { PackOrderBLL.Add(OrderID, CurrentDIN, productCode); GridViewPack.DataBind(); CurrentDIN = ""; imgCurrentDIN.ImageUrl = "none"; GridViewSum.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string strOrderID = Request["OrderID"]; if (!string.IsNullOrEmpty(strOrderID)) { order = OrderBLL.Get(strOrderID.ToInt()); if (order.Type == Order.TypeX.ForOrg) { LabelTitle1.Text = "BIÊN BẢN BÀN GIAO"; LoadOrder(); RedBloodDataContext db = new RedBloodDataContext(); var v1 = db.PackOrders.Where(r => r.OrderID.Value == order.ID && !r.ReturnID.HasValue).ToList(); var v = v1.GroupBy(r => r.Pack.ProductCode) .Select(r => new { ProductCode = r.Key, Sum = r.Count(), BloodGroupSumary = r.GroupBy(r1 => r1.Pack.Donation.BloodGroup).Select(r1 => new { BloodGroupDesc = BloodGroupBLL.GetDescription(r1.Key), Total = r1.Count(), VolumeSumary = r1.GroupBy(r2 => r2.Pack.Volume).Select(r2 => new { Volume = r2.Key.HasValue ? r2.Key.Value.ToString() : "_", Total = r2.Count(), //DINList = string.Join(",", r2.Select(r3 => r3.Pack.DIN).ToArray()), DINList = r2.Select(r3 => new { DIN = r3.Pack.DIN }).OrderBy(r4 => r4.DIN), }).OrderBy(r2 => r2.Volume) }).OrderBy(r1 => r1.BloodGroupDesc), }); GridViewSum.DataSource = v; GridViewSum.DataBind(); LableCount.Text = v1.Count().ToStringRemoveZero(); //var v2 = db.PackOrders.Where(r => r.OrderID.Value == order.ID // && !r.ReturnID.HasValue).ToList().OrderBy(r => r.Pack.DIN); //GridViewPack.DataSource = v2; //GridViewPack.DataBind(); } } } }
//public void Clear() //{ // OrderID = 0; // imgOrder.ImageUrl = "none"; // txtDate.Text = ""; // txtNote.Text = ""; // txtDept.Text = ""; // txtRoom.Text = ""; // txtBed.Text = ""; // txtDiagnosis.Text = ""; // txtPatientCode.Text = ""; // txtTransfusionNote.Text = ""; // People1.PeopleID = Guid.Empty; // GridViewPack.DataBind(); // CurrentDIN = ""; // imgCurrentDIN.ImageUrl = "none"; //} public void LoadOrder() { Order e = new Order(); if (OrderID == 0) { imgOrder.ImageUrl = "none"; People1.PeopleID = Guid.Empty; } else { e = OrderBLL.Get(OrderID); if (e.Type == Order.TypeX.ForOrg) { Response.Redirect(RedBloodSystem.Url4Order4Org + "key=" + e.ID.ToString()); } else if (e.Type == Order.TypeX.ForCR) { imgOrder.ImageUrl = BarcodeBLL.Url4Order(e.ID); People1.PeopleID = e.People != null?e.PeopleID.GetValueOrDefault() : Guid.Empty; } } txtNote.Text = e.Note; if (e.Date != null) { txtDate.Text = e.Date.ToStringVN_Hour(); } else { txtDate.Text = ""; } txtDept.Text = e.FullDepartment; txtRoom.Text = e.Room; txtBed.Text = e.Bed; txtDiagnosis.Text = e.Diagnosis; txtPatientCode.Text = e.PatientCode; txtTransfusionNote.Text = e.TransfusionNote; GridViewPack.DataBind(); btnUpdate.Enabled = e.Status == Order.StatusX.Init; CurrentDIN = ""; imgCurrentDIN.ImageUrl = "none"; GridViewSum.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string strParamID = Request["ReturnID"]; if (!string.IsNullOrEmpty(strParamID)) { returnObj = ReturnBLL.Get(strParamID.ToInt()); if (returnObj != null) { LabelTitle1.Text = "BIÊN BẢN THU HỒI"; LoadReturn(); RedBloodDataContext db = new RedBloodDataContext(); var v1 = db.PackOrders.Where(r => r.ReturnID.Value == returnObj.ID) .Select(r => r.Pack) .ToList(); var v = v1.GroupBy(r => r.ProductCode) .Select(r => new { ProductCode = r.Key, Sum = r.Count(), BloodGroupSumary = r.GroupBy(r1 => r1.Donation.BloodGroup).Select(r1 => new { BloodGroupDesc = BloodGroupBLL.GetDescription(r1.Key), Total = r1.Count(), VolumeSumary = r1.GroupBy(r2 => r2.Volume).Select(r2 => new { Volume = r2.Key.HasValue ? r2.Key.Value.ToString() : "_", Total = r2.Count(), DINList = r2.Select(r3 => new { DIN = r3.DIN }).OrderBy(r4 => r4.DIN), }).OrderBy(r2 => r2.Volume) }).OrderBy(r1 => r1.BloodGroupDesc), }); GridViewSum.DataSource = v; GridViewSum.DataBind(); LableCount.Text = v1.Count().ToStringRemoveZero(); } } } }
public void Clear() { OrderID = 0; imgOrder.ImageUrl = "none"; txtDate.Text = ""; txtNote.Text = ""; GridViewPack.DataBind(); CurrentDIN = ""; imgCurrentDIN.ImageUrl = "none"; GridViewSum.DataBind(); }
public void LoadOrder() { Order e = new Order(); if (OrderID == 0) { imgOrder.ImageUrl = "none"; txtOrg.Text = ""; //People1.PeopleID = Guid.Empty; } else { e = OrderBLL.Get(OrderID); if (e.Type == Order.TypeX.ForOrg) { imgOrder.ImageUrl = BarcodeBLL.Url4Order(e.ID); txtOrg.Text = e.Org != null ? e.Org.Name : ""; } else if (e.Type == Order.TypeX.ForCR) { Response.Redirect(RedBloodSystem.Url4Order4CR + "key=" + e.ID.ToString()); } } txtNote.Text = e.Note; if (e.Date != null) { txtDate.Text = e.Date.ToStringVN_Hour(); } txtTransfusionNote.Text = e.TransfusionNote; GridViewPack.DataBind(); btnUpdate.Enabled = e.Status == Order.StatusX.Init; urlPrint.NavigateUrl = ResolveClientUrl(string.Format("~/Store/PrintOrder.aspx?OrderID={0}", e.ID)); CurrentDIN = ""; imgCurrentDIN.ImageUrl = "none"; GridViewSum.DataBind(); }
void AddPackOrder(string productCode) { PackOrder po = PackOrderBLL.Get4Return(CurrentDIN, productCode); if (PackOrderList.Contains(po.ID)) { throw new Exception("Đã nhập túi máu này."); } PackOrderList.Add(po.ID); GridViewPack.DataBind(); CurrentDIN = ""; imgCurrentDIN.ImageUrl = "none"; GridViewSum.DataBind(); }
protected void btnRemove_Click(object sender, EventArgs e) { if (ReturnID != 0) { return; } LinkButton btn = sender as LinkButton; if (btn != null) { if (PackOrderList.Remove(btn.CommandArgument.ToInt())) { GridViewPack.DataBind(); GridViewSum.DataBind(); } } }
void LoadData() { DateTime?dtFrom = txtDateFrom.Text.ToDatetimeFromVNFormat(); DateTime?dtTo = txtDateTo.Text.ToDatetimeFromVNFormat(); if (dtFrom.HasValue) { DateTime hourFrom; if (DateTime.TryParse(txtHourFrom.Text, out hourFrom)) { dtFrom = dtFrom.Value.AddHours(hourFrom.Hour).AddMinutes(hourFrom.Minute); } } if (dtTo.HasValue) { DateTime hourTo; if (DateTime.TryParse(txtHourTo.Text, out hourTo)) { dtTo = dtTo.Value.AddHours(hourTo.Hour).AddMinutes(hourTo.Minute); } } RedBloodDataContext db = new RedBloodDataContext(); //var packs = db.Packs.Where(r => r.Date.Value >= dtFrom && r.Date.Value <= dtTo // && r.Donation.OrgPackID != r.ID).OrderBy(r => r.Date); var v = db.Deletes.Where(r => r.Date.Value >= dtFrom && r.Date.Value <= dtTo) .OrderBy(r => r.Date) .ToList() .Select(r => new { r.ID, Date = r.Date.ToStringVN_Hour(), r.Note, r.Actor, r.Packs }); GridView1.DataSource = v; GridView1.DataBind(); var s = v.SelectMany(r => r.Packs).ToList(); var v1 = s.ToList().GroupBy(r => r.ProductCode) .Select(r => new { ProductCode = r.Key, ProductDesc = ProductBLL.GetDesc(r.Key), Sum = r.Count(), BloodGroupSumary = r.GroupBy(r1 => r1.Donation.BloodGroup).Select(r1 => new { BloodGroupDesc = BloodGroupBLL.GetDescription(r1.Key), Total = r1.Count(), VolumeSumary = r1.GroupBy(r2 => r2.Volume).Select(r2 => new { Volume = r2.Key.HasValue ? r2.Key.Value.ToString() : "_", Total = r2.Count(), DINList = r2.Select(r3 => new { DIN = r3.DIN }).OrderBy(r4 => r4.DIN), }).OrderBy(r2 => r2.Volume) }).OrderBy(r1 => r1.BloodGroupDesc), }); GridViewSum.DataSource = v1; GridViewSum.DataBind(); }
void LoadData() { DateTime?dtFrom = txtDateFrom.Text.ToDatetimeFromVNFormat(); DateTime?dtTo = txtDateTo.Text.ToDatetimeFromVNFormat(); if (dtFrom.HasValue) { DateTime hourFrom; if (DateTime.TryParse(txtHourFrom.Text, out hourFrom)) { dtFrom = dtFrom.Value.AddHours(hourFrom.Hour).AddMinutes(hourFrom.Minute); } } if (dtTo.HasValue) { DateTime hourTo; if (DateTime.TryParse(txtHourTo.Text, out hourTo)) { dtTo = dtTo.Value.AddHours(hourTo.Hour).AddMinutes(hourTo.Minute); } } RedBloodDataContext db = new RedBloodDataContext(); var packs = db.Packs.Where(r => r.Date.Value >= dtFrom && r.Date.Value <= dtTo && r.Donation.OrgPackID != r.ID).OrderBy(r => r.ProductCode).ThenBy(r => r.Date); var v = packs.ToList().GroupBy(r => r.ProductCode) .Select(r => new { ProductCode = r.Key, ProductDesc = ProductBLL.GetDesc(r.Key), Sum = r.Count(), PrintUrl = "~/Production/FinalLabelPrint.aspx?PackList=" + string.Join(",", r.Where(r1 => r1.Donation.TestResultStatus == Donation.TestResultStatusX.Negative).Select(r1 => r1.ID.ToString())), PrintCount = r.Where(r1 => r1.Donation.TestResultStatus == Donation.TestResultStatusX.Negative).Count(), BloodGroupSumary = r.GroupBy(r1 => r1.Donation.BloodGroup).Select(r1 => new { BloodGroupDesc = BloodGroupBLL.GetDescription(r1.Key), Total = r1.Count(), VolumeSumary = r1.GroupBy(r2 => r2.Volume).Select(r2 => new { Volume = r2.Key.HasValue ? r2.Key.Value.ToString() : "_", Total = r2.Count(), DINList = r2.Select(r3 => new { DIN = r3.DIN }).OrderBy(r4 => r4.DIN), }).OrderBy(r2 => r2.Volume) }).OrderBy(r1 => r1.BloodGroupDesc), }); GridViewSum.DataSource = v; GridViewSum.DataBind(); GridView1.DataSource = packs.ToList().Select(r => new { r.ID, Date = r.Date.ToStringVN_Hour(), r.DIN, r.ProductCode, Description = ProductBLL.GetDesc(r.ProductCode), r.Note, }); GridView1.DataBind(); btnSelectedPack.Visible = packs.Count() > 0; }