// var d = db.sp_web_OutputStock_detail(id.Trim());
protected void Page_Load(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Convert.ToString(Request.QueryString["Id"])))
{
CFileManagerDataContext db = new CFileManagerDataContext();
string html = "";
var p = from x in db.tStockOutputs
from y in db.tBranches
from y2 in db.tBranches
from z in db.tBranchTypes
where x.BranchId == y.Id && x.BranchToId == y2.Id && x.BranchTypeId == z.Id &&
x.Id == int.Parse(Request.QueryString["Id"]) && x.OutputType == 2
select new { x.StockCode, x.CreateAt, y.BranchName, y.Address, y.ContactName, y.Position, ToBranch = y2.BranchName, ToAddress = y2.Address, ToContactName = y2.ContactName, ToPosition = y2.Position, BranchType = z.Code };
lbBenGiao.Text = p.FirstOrDefault().BranchName;
lbAddBenGiao.Text = p.FirstOrDefault().Address;
lbDaiDienGiao.Text = p.FirstOrDefault().ContactName;
lbChucVuGiao.Text = p.FirstOrDefault().Position;
lbBenNhan.Text = p.FirstOrDefault().ToBranch;
lbAddBenNhan.Text = p.FirstOrDefault().ToAddress;
lbDaiDienNhan.Text = p.FirstOrDefault().ToContactName;
lbChucVuNhan.Text = p.FirstOrDefault().ToPosition;
lbDate.Text = "Ngày " + p.FirstOrDefault().CreateAt.Value.ToString("dd/MM/yyyy HH:mm");
lbBranchType.Text = p.FirstOrDefault().BranchType;
lbCode.Text = "Số phiếu: " + p.FirstOrDefault().StockCode.ToString().ToUpper();
var d = db.sp_web_OutputStock_detail(Request.QueryString["Id"]);
int i = 1; int count = 0;
foreach (var item in d.ToList())
{
html += "<tr style='font-size:14px;'>";
html += "<td class='border center'>" + i.ToString() + "</td>";
html += "<td class='border pl'>" + item.CodeId + " | " + item.ProductCode + "</td>";
html += "<td class='border pl'>" + item.ProductName + "</td>";
html += "<td class='border center'>Chiếc</td>";
html += "<td class='border center'>" + item.Quantity.ToString() + "</td>";
html += "<td class='border center'></td>";
html += "<td class='border pl'></td>";
html += "</tr>";
i++;
count += item.Quantity;
}
lbCount.Text = count == 0 ? "0" : string.Format("{0:0,0}", count);
lbItem.Text = html;
}
}
