public void LoadData()
{
string s = "";
int status = 0;
if (Request.QueryString["s"] != null)
{
s = Request.QueryString["s"];
}
if (Request.QueryString["status"] != null)
{
status = Request.QueryString["status"].ToInt(0);
}
;
txtAgentName.Text = s;
ddlStatus.SelectedValue = status.ToString();
string username = Request.Cookies["userLoginSystem"].Value;
var acc = AccountController.GetByUsername(username);
var orders = MoveProController.Search(s, status);
if (orders.Count > 0)
{
pagingall(orders);
}
//if (acc != null)
//{
// int agentID = Convert.ToInt32(acc.AgentID);
// var orders = MoveProController.GetByAgentSend(agentID);
// if (orders.Count > 0)
// {
// pagingall(orders);
// }
//}
}
public void LoadData()
{
string s = "";
if (Request.QueryString["s"] != null)
{
s = Request.QueryString["s"];
}
string username = Request.Cookies["usernameLoginSystem"].Value;
var acc = AccountController.GetByUsername(username);
if (acc != null)
{
int agentID = Convert.ToInt32(acc.AgentID);
var orders = MoveProController.GetByAgentReceive(agentID);
if (orders.Count > 0)
{
pagingall(orders);
}
}
}
protected void btnImport_Click(object sender, EventArgs e)
{
DateTime currentDate = DateTime.Now;
string username = Request.Cookies["usernameLoginSystem"].Value;
var acc = AccountController.GetByUsername(username);
if (acc != null)
{
if (acc.RoleID == 0 || acc.RoleID == 1)
{
int mpID = ViewState["ID"].ToString().ToInt(0);
var mp = MoveProController.GetByID(mpID);
if (mp != null)
{
int AgentID = Convert.ToInt32(acc.AgentID);
int AgentIDReceive = hdfAgentID.Value.ToInt(0);
string agentSendname = "";
string agentReceivename = "";
var agentSend = AgentController.GetByID(AgentID);
if (agentSend != null)
{
agentSendname = agentSend.AgentName;
}
var agentReceive = AgentController.GetByID(AgentIDReceive);
if (agentReceive != null)
{
agentReceivename = agentReceive.AgentName;
}
string list = hdfvalue.Value;
string note = hdfNote.Value;
int moveProStatus = hdfStatus.Value.ToInt(0);
MoveProController.UpdateStatus(mpID, moveProStatus, currentDate, username);
string[] items = list.Split(';');
if (items.Length - 1 > 0)
{
for (int i = 0; i < items.Length - 1; i++)
{
var item = items[i];
string[] itemValue = item.Split(',');
int ID = itemValue[0].ToInt();
string SKU = itemValue[1];
int producttype = itemValue[2].ToInt();
string ProductVariableName = itemValue[3];
string ProductVariableValue = itemValue[4];
double Quantity = Convert.ToDouble(itemValue[5]);
string ProductName = itemValue[6];
string ProductImageOrigin = itemValue[7];
string ProductVariable = itemValue[8];
int mpdid = itemValue[9].ToInt(0);
if (mpdid > 0)
{
var mpdetail = MoveProDetailController.GetByID(mpdid);
if (mpdetail != null)
{
if (moveProStatus == 3)
{
if (producttype == 1)
{
StockManagerController.Insert(
new tbl_StockManager {
AgentID = AgentID,
ProductID = ID,
ProductVariableID = 0,
Quantity = Quantity,
QuantityCurrent = 0,
Type = 1,
NoteID = note,
OrderID = 0,
Status = 7,
SKU = SKU,
CreatedDate = currentDate,
CreatedBy = username,
MoveProID = mpID,
ParentID = ID
});
}
else
{
int parentID = 0;
string parentSKU = "";
var productV = ProductVariableController.GetByID(ID);
if (productV != null)
{
parentSKU = productV.ParentSKU;
}
if (!string.IsNullOrEmpty(parentSKU))
{
var product = ProductController.GetBySKU(parentSKU);
if (product != null)
{
parentID = product.ID;
}
}
StockManagerController.Insert(
new tbl_StockManager {
AgentID = AgentID,
ProductID = 0,
ProductVariableID = ID,
Quantity = Quantity,
QuantityCurrent = 0,
Type = 1,
NoteID = note,
OrderID = 0,
Status = 7,
SKU = SKU,
CreatedDate = currentDate,
CreatedBy = username,
MoveProID = mpID,
ParentID = parentID
});
}
MoveProDetailController.UpdateQuantityReceive(mpdid, Quantity, currentDate, username);
}
else
{
MoveProDetailController.UpdateQuantityReceive(mpdid, Quantity, currentDate, username);
}
}
}
}
}
PJUtils.ShowMessageBoxSwAlert("Cập nhật nhận hàng thành công", "s", true, Page);
}
}
}
}
public void LoadData()
{
int ID = Request.QueryString["id"].ToInt(0);
if (ID > 0)
{
string username = Request.Cookies["usernameLoginSystem"].Value;
var acc = AccountController.GetByUsername(username);
if (acc != null)
{
int agentIDReceive = Convert.ToInt32(acc.AgentID);
var mp = MoveProController.GetByIDAndAgentIDReceive(ID, agentIDReceive);
if (mp != null)
{
ViewState["ID"] = ID;
int agentIDSend = Convert.ToInt32(mp.AgentIDSend);
string agentSendname = "";
string agentReceivename = "";
var agentSend = AgentController.GetByID(agentIDSend);
if (agentSend != null)
{
agentSendname = agentSend.AgentName;
}
var agentReceive = AgentController.GetByID(agentIDReceive);
if (agentReceive != null)
{
agentReceivename = agentReceive.AgentName;
}
ltrAgentReceive.Text = agentReceivename;
ltrAgentSend.Text = agentSendname;
int mpStatus = Convert.ToInt32(mp.Status);
ltrNote.Text = mp.Note;
if (mpStatus < 3)
{
ltrbutton1.Text = "<a href=\"javascript:;\" class=\"btn primary-btn fw-btn not-fullwidth\" onclick=\"inProduct()\">Cập nhật</a>";
ltrbutton2.Text = "<div class=\"float-right\"><a href=\"javascript:;\" class=\"btn primary-btn fw-btn not-fullwidth\" onclick=\"inProduct()\">Cập nhật</a></div>";
}
#region LoadDDL
//Lấy trạng thái
StringBuilder htmlStatus = new StringBuilder();
htmlStatus.Append("<select id=\"moveProStatus\" class=\"form-control\" style=\"width: 20%; display: inline-block\">");
if (mpStatus == 2)
{
htmlStatus.Append("<option value=\"2\" selected>Đã chuyển</option>");
htmlStatus.Append("<option value=\"3\">Đã hoàn tất</option>");
}
else if (mpStatus == 3)
{
htmlStatus.Append("<option value=\"2\">Đã chuyển</option>");
htmlStatus.Append("<option value=\"3\" selected>Đã hoàn tất</option>");
}
htmlStatus.Append("</select>");
ltrMoProStatus.Text = htmlStatus.ToString();
//Lấy nhà cung cấp
//var supplier = SupplierController.GetAllWithIsHidden(false);
//StringBuilder htmlSupplier = new StringBuilder();
//htmlSupplier.Append("<select id=\"supplierList\" class=\"form-control\" style=\"width: 20%; float: left; margin-right: 10px\">");
//htmlSupplier.Append("<option value=\"0\">Tất cả nhà cung cấp</option>");
//if (supplier.Count > 0)
//{
// foreach (var s in supplier)
// {
// htmlSupplier.Append("<option value=\"" + s.ID + "\">" + s.SupplierName + "</option>");
// }
//}
//htmlSupplier.Append("</select>");
//ltrSupplier.Text = htmlSupplier.ToString();
#endregion
#region Lấy danh sách sản phẩm
var mpDetail = MoveProDetailController.GetByMoveProID(ID);
string html = "";
if (mpDetail.Count > 0)
{
string listSKU = "";
foreach (var item in mpDetail)
{
listSKU += item.SKU + "|";
int ProductType = Convert.ToInt32(item.ProductType);
int ProductID = Convert.ToInt32(item.ProductID);
int ProductVariableID = Convert.ToInt32(item.ProductVariableID);
string SKU = item.SKU;
double QuantityInstock = 0;
string ProductImageOrigin = "";
string ProductVariable = "";
string ProductName = "";
int PID = 0;
string ProductVariableName = "";
string ProductVariableValue = "";
string ProductVariableSave = "";
double QuantityMainInstock = 0;
string ProductImage = "";
string QuantityMainInstockString = "";
string QuantityInstockString = "";
string productVariableDescription = item.ProductVariableDescription;
string SupplierName = item.SupplierName;
if (ProductType == 1)
{
PID = ProductID;
var product = ProductController.GetBySKU(SKU);
if (product != null)
{
double total = PJUtils.TotalProductQuantityInstock(agentIDSend, SKU);
string variablename = "";
string variablevalue = "";
string variable = "";
double mainstock = PJUtils.TotalProductQuantityInstock(1, SKU);
QuantityInstock = total;
QuantityInstockString = string.Format("{0:N0}", total);
var img = ProductImageController.GetFirstByProductID(product.ID);
if (img != null)
{
ProductImage = "<img src=\"" + Thumbnail.getURL(img.ProductImage, Thumbnail.Size.Small) + "\" alt=\"\" style=\"width: 50px\" />";
ProductImageOrigin = Thumbnail.getURL(img.ProductImage, Thumbnail.Size.Small);
}
else
{
ProductImage = "";
ProductImageOrigin = "";
}
ProductVariable = variable;
ProductName = product.ProductTitle;
QuantityMainInstock = mainstock;
QuantityMainInstockString = string.Format("{0:N0}", mainstock);
ProductVariableSave = item.ProductVariableDescription;
ProductVariableName = variablename;
ProductVariableValue = variablevalue;
}
}
else
{
PID = ProductVariableID;
var productvariable = ProductVariableController.GetBySKU(SKU);
if (productvariable != null)
{
SKU = productvariable.SKU.Trim().ToUpper();
double total = PJUtils.TotalProductQuantityInstock(agentIDSend, SKU);
string variablename = "";
string variablevalue = "";
string variable = "";
string[] vs = productVariableDescription.Split('|');
if (vs.Length - 1 > 0)
{
for (int i = 0; i < vs.Length - 1; i++)
{
string[] items = vs[i].Split(':');
variable += items[0] + ":" + items[1] + "<br/>";
variablename += items[0] + "|";
variablevalue += items[1] + "|";
}
}
double mainstock = PJUtils.TotalProductQuantityInstock(1, SKU);
QuantityInstock = total;
QuantityInstockString = string.Format("{0:N0}", total);
ProductImage = "<img src=\"" + Thumbnail.getURL(productvariable.Image, Thumbnail.Size.Small) + "\" alt=\"\" style=\"width:50px;\" />";
ProductImageOrigin = Thumbnail.getURL(productvariable.Image, Thumbnail.Size.Small);
ProductVariable = variable;
var product1 = ProductController.GetByID(Convert.ToInt32(productvariable.ProductID));
if (product1 != null)
{
ProductName = product1.ProductTitle;
}
QuantityMainInstock = mainstock;
QuantityMainInstockString = string.Format("{0:N0}", mainstock);
ProductVariableSave = item.ProductVariableDescription;
ProductVariableName = variablename;
ProductVariableValue = variablevalue;
}
}
html += "<tr class=\"product-result\" data-mpdid=\"" + item.ID + "\" data-quantityinstock=\"" + QuantityInstock
+ "\" data-productimageorigin=\"" + ProductImageOrigin
+ "\" data-productvariable=\"" + ProductVariableSave
+ "\" data-productname=\"" + ProductName
+ "\" data-sku=\"" + SKU + "\" data-producttype=\"" + ProductType
+ "\" data-id=\"" + item.ID + "\" data-productnariablename=\"" + ProductVariableName
+ "\" data-productvariablevalue =\"" + ProductVariableValue + "\">";
html += " <td>" + ProductImage + "";
html += " <td>" + ProductName + "</td>";
html += " <td>" + SKU + "</td>";
html += " <td>" + SupplierName + "</td>";
html += " <td>" + ProductVariable + "</td>";
html += " <td>" + item.QuantiySend + "</td>";
html += " <td style=\"width:20%;\"><input type=\"text\" min=\"0\" class=\"form-control in-quanlity\" style=\"width: 40%;margin: 0 auto;\" value=\"" + item.QuantityReceive + "\" onkeyup=\"checkQuantiy($(this))\" onkeypress='return event.charCode >= 48 && event.charCode <= 57'/></td>";
//html += " <td><a href=\"javascript:;\" onclick=\"deleteRow($(this))\">Xóa</a></td>";
//html += " <td></td>";
html += "</tr>";
}
ltrProducts.Text = html;
hdfListProductSend.Value = listSKU;
}
#endregion
}
}
}
}
protected void btnImport_Click(object sender, EventArgs e)
{
DateTime currentDate = DateTime.Now;
string username = Request.Cookies["userLoginSystem"].Value;
var acc = AccountController.GetByUsername(username);
if (acc != null)
{
if (acc.RoleID == 0 || acc.RoleID == 1)
{
int AgentID = Convert.ToInt32(acc.AgentID);
int AgentIDReceive = hdfAgentID.Value.ToInt(0);
string agentSendname = "";
string agentReceivename = "";
var agentSend = AgentController.GetByID(AgentID);
if (agentSend != null)
{
agentSendname = agentSend.AgentName;
}
var agentReceive = AgentController.GetByID(AgentIDReceive);
if (agentReceive != null)
{
agentReceivename = agentReceive.AgentName;
}
string list = hdfvalue.Value;
string note = hdfNote.Value;
int moveProStatus = hdfStatus.Value.ToInt(0);
string[] items = list.Split(';');
if (items.Length - 1 > 0)
{
string kq = MoveProController.Insert(AgentID, agentSendname, AgentIDReceive, agentReceivename, moveProStatus,
note, false, currentDate, username);
if (kq.ToInt(0) > 0)
{
int moveProID = kq.ToInt(0);
for (int i = 0; i < items.Length - 1; i++)
{
var item = items[i];
string[] itemValue = item.Split(',');
int ID = itemValue[0].ToInt();
string SKU = itemValue[1];
int producttype = itemValue[2].ToInt();
string ProductVariableName = itemValue[3];
string ProductVariableValue = itemValue[4];
double Quantity = Convert.ToDouble(itemValue[5]);
string ProductName = itemValue[6];
string ProductImageOrigin = itemValue[7];
string ProductVariable = itemValue[8];
if (producttype == 1)
{
int supplierID = 0;
string supplierName = "";
var product = ProductController.GetBySKU(SKU);
if (product != null)
{
supplierID = Convert.ToInt32(product.SupplierID);
supplierName = product.SupplierName;
}
if (moveProStatus == 2)
{
StockManagerController.Insert(
new tbl_StockManager {
AgentID = AgentID,
ProductID = ID,
ProductVariableID = 0,
Quantity = Quantity,
QuantityCurrent = 0,
Type = 2,
NoteID = note,
OrderID = 0,
Status = 5,
SKU = SKU,
CreatedDate = currentDate,
CreatedBy = username,
MoveProID = moveProID,
ParentID = ID
});
MoveProDetailController.Insert(moveProID, SKU, ID, 0, producttype, ProductVariable, Quantity, 0, "", supplierID,
supplierName, "", "", ProductName, ProductImageOrigin, true, currentDate, username);
}
else
{
MoveProDetailController.Insert(moveProID, SKU, ID, 0, producttype, ProductVariable, Quantity, 0, "", supplierID,
supplierName, "", "", ProductName, ProductImageOrigin, false, currentDate, username);
}
}
else
{
int supplierID = 0;
string supplierName = "";
int parentID = 0;
string parentSKU = "";
var productvariable = ProductVariableController.GetBySKU(SKU);
if (productvariable != null)
{
supplierID = Convert.ToInt32(productvariable.SupplierID);
supplierName = productvariable.SupplierName;
parentSKU = productvariable.ParentSKU;
}
if (!string.IsNullOrEmpty(parentSKU))
{
var product = ProductController.GetBySKU(parentSKU);
if (product != null)
{
parentID = product.ID;
}
}
if (moveProStatus == 2)
{
StockManagerController.Insert(
new tbl_StockManager {
AgentID = AgentID,
ProductID = 0,
ProductVariableID = ID,
Quantity = Quantity,
QuantityCurrent = 0,
Type = 2,
NoteID = note,
OrderID = 0,
Status = 5,
SKU = SKU,
CreatedDate = currentDate,
CreatedBy = username,
MoveProID = moveProID,
ParentID = parentID,
});
MoveProDetailController.Insert(moveProID, SKU, 0, ID, producttype, ProductVariable, Quantity, 0, "", supplierID,
supplierName, ProductVariableName, ProductVariableValue, ProductName, ProductImageOrigin, true, currentDate, username);
}
else
{
MoveProDetailController.Insert(moveProID, SKU, 0, ID, producttype, ProductVariable, Quantity, 0, "", supplierID,
supplierName, ProductVariableName, ProductVariableValue, ProductName, ProductImageOrigin, false, currentDate, username);
}
}
}
PJUtils.ShowMessageBoxSwAlert("Tạo lệnh chuyển hàng thành công", "s", true, Page);
}
//int SessionInOutID = SessionInOutController.Insert(currentDate, note, AgentID, 2, currentDate, username).ToInt(0);
//if (SessionInOutID > 0)
//{
// for (int i = 0; i < items.Length - 1; i++)
// {
// //list += id + "," + sku + "," + producttype + "," + productnariablename + "," + productvariablevalue + "," + quantity + "|";
// var item = items[i];
// string[] itemValue = item.Split(',');
// int ID = itemValue[0].ToInt();
// string SKU = itemValue[1];
// int producttype = itemValue[2].ToInt();
// string ProductVariableName = itemValue[3];
// string ProductVariableValue = itemValue[4];
// double Quantity = Convert.ToDouble(itemValue[5]);
// string ProductName = itemValue[6];
// string ProductImageOrigin = itemValue[7];
// string ProductVariable = itemValue[8];
// if (producttype == 1)
// {
// StockManagerController.Insert(AgentID, ID, 0, "", "", Quantity, 0, 2, false, 1, note, 0,
// SessionInOutID, 2, ProductName, SKU, ProductImageOrigin, ProductVariable, currentDate, username);
// }
// else
// {
// StockManagerController.Insert(AgentID, 0, ID, ProductVariableName, ProductVariableValue, Quantity, 0, 2,
// false, 2, note, 0, SessionInOutID, 2, ProductName, SKU, ProductImageOrigin, ProductVariable, currentDate, username);
// }
// }
// PJUtils.ShowMessageBoxSwAlert("Xuất hàng thành công", "s", true, Page);
//}
}
}
}
}
