public CascadingDropDownNameValue[] GetProductByProject(
string knownCategoryValues,
string category)
{
StringDictionary categoryValues = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
string project = categoryValues["Project"];
List <CascadingDropDownNameValue> result = new List <CascadingDropDownNameValue>();
if (string.Equals(project, "Mach", StringComparison.OrdinalIgnoreCase))
{
MachLookupDAL dal = new MachLookupDAL();
var machs = dal.GetAllMach();
foreach (var item in machs)
{
result.Add(new CascadingDropDownNameValue()
{
name = item.Name, value = item.Mach_Id.ToString()
});
}
}
else if (string.Equals(project, "Install", StringComparison.OrdinalIgnoreCase))
{
InstallLookupDAL dal = new InstallLookupDAL();
var installs = dal.GetAllLookup();
foreach (var item in installs)
{
result.Add(new CascadingDropDownNameValue()
{
name = item.Name, value = item.Install_Id.ToString()
});
}
}
else if (string.Equals(project, "Product", StringComparison.OrdinalIgnoreCase))
{
ProductDAL dal = new ProductDAL();
var products = dal.GetAllProducts();
foreach (var item in products)
{
result.Add(new CascadingDropDownNameValue()
{
name = item.Product_Name, value = item.Product_Id.ToString()
});
}
}
else if (string.Equals(project, "EndProduct", StringComparison.OrdinalIgnoreCase))
{
EndProductDAL dal = new EndProductDAL();
var endProducts = dal.GetAllEndProductList();
foreach (var item in endProducts)
{
result.Add(new CascadingDropDownNameValue()
{
name = item.Name, value = item.EP_Id.ToString()
});
}
}
return(result.ToArray());
}
private List <NameValueItem> GetProductByProject(string project)
{
List <NameValueItem> result = new List <NameValueItem>();
if (string.Equals(project, "加工", StringComparison.OrdinalIgnoreCase))
{
MachLookupDAL dal = new MachLookupDAL();
var machs = dal.GetAllMach();
foreach (var item in machs)
{
result.Add(new NameValueItem()
{
Name = item.Name, Value = item.Mach_Id.ToString()
});
}
}
else if (string.Equals(project, "安装", StringComparison.OrdinalIgnoreCase))
{
InstallLookupDAL dal = new InstallLookupDAL();
var installs = dal.GetAllLookup();
foreach (var item in installs)
{
result.Add(new NameValueItem()
{
Name = item.Name, Value = item.Install_Id.ToString()
});
}
}
else if (string.Equals(project, "材料", StringComparison.OrdinalIgnoreCase))
{
ProductDAL dal = new ProductDAL();
var products = dal.GetAllProducts();
foreach (var item in products)
{
result.Add(new NameValueItem()
{
Name = item.Product_Name + "/" + item.Product_Code, Value = item.Product_Id.ToString()
});
}
}
else if (string.Equals(project, "成品", StringComparison.OrdinalIgnoreCase))
{
EndProductDAL dal = new EndProductDAL();
var endProducts = dal.GetAllEndProductList();
foreach (var item in endProducts)
{
result.Add(new NameValueItem()
{
Name = item.Name + "/" + item.Code, Value = item.EP_Id.ToString()
});
}
}
return(result);
}
protected void rpItems_ItemCommand(object source, RepeaterCommandEventArgs e)
{
MachSummaryDAL dal = new MachSummaryDAL();
MachLookupDAL lDAL = new MachLookupDAL();
if (e.CommandName == "Add")
{
TextBox txtMachIntroAdd = e.Item.FindControl("txtMachIntroAdd") as TextBox;
DropDownList ddlMachNameAdd = e.Item.FindControl("ddlMachNameAdd") as DropDownList;
DropDownList ddlMachUnitAdd = e.Item.FindControl("ddlMachUnitAdd") as DropDownList;
TextBox txtQtyAdd = e.Item.FindControl("txtQtyAdd") as TextBox;
TextBox txtRemarkAdd = e.Item.FindControl("txtRemarkAdd") as TextBox;
MachSummary summary = new MachSummary();
summary.MachId = MachId;
summary.MachIntro = txtMachIntroAdd.Text;
summary.MachName = Utility.GetSelectedText(ddlMachNameAdd);
summary.Unit = Utility.GetSelectedText(ddlMachUnitAdd);
summary.Qty = !string.IsNullOrEmpty(txtQtyAdd.Text) ? int.Parse(txtQtyAdd.Text) : 0;
summary.Remark = txtRemarkAdd.Text;
summary.ImagePath = lDAL.GetMachLookupById(int.Parse(Utility.GetSelectedValue(ddlMachNameAdd))).MachIdentity;
dal.AddMachSummary(summary);
dal.Save();
}
else if (e.CommandName == "Save")
{
HiddenField hdId = e.Item.FindControl("hdId") as HiddenField;
MachSummary summary = dal.GetSummaryById(int.Parse(hdId.Value));
TextBox txtMachIntro = e.Item.FindControl("txtMachIntro") as TextBox;
DropDownList ddlMachName = e.Item.FindControl("ddlMachName") as DropDownList;
DropDownList ddlMachUnit = e.Item.FindControl("ddlMachUnit") as DropDownList;
TextBox txtQty = e.Item.FindControl("txtQty") as TextBox;
TextBox txtRemark = e.Item.FindControl("txtRemark") as TextBox;
summary.MachIntro = txtMachIntro.Text;
summary.MachName = Utility.GetSelectedText(ddlMachName);
summary.Unit = Utility.GetSelectedText(ddlMachUnit);
summary.Qty = !string.IsNullOrEmpty(txtQty.Text) ? int.Parse(txtQty.Text) : 0;
summary.Remark = txtRemark.Text;
summary.ImagePath = lDAL.GetMachLookupById(int.Parse(Utility.GetSelectedValue(ddlMachName))).MachIdentity;
dal.Save();
}
else if (e.CommandName == "Delete")
{
HiddenField hdId = e.Item.FindControl("hdId") as HiddenField;
dal.DeleteSummary(int.Parse(hdId.Value));
}
BindControl();
SetFocus(btnLoc);
}
public static List <NameValueItem> GetMachTypeList()
{
MachLookupDAL dal = new MachLookupDAL();
var result = from m in dal.GetAllMach()
select new NameValueItem()
{
Name = m.Name,
Value = m.Mach_Id.ToString()
};
return(result.ToList());
}
protected void rpMachiningInstall_ItemCommand(object source, RepeaterCommandEventArgs e)
{
MachLookupDAL dal = new MachLookupDAL();
if (e.CommandName == "Add")
{
var txtCodeAdd = e.Item.FindControl("txtCodeAdd") as TextBox;
var txtNameAdd = e.Item.FindControl("txtNameAdd") as TextBox;
var txtPriceMAdd = e.Item.FindControl("txtPriceMAdd") as TextBox;
var txtPriceM2Add = e.Item.FindControl("txtPriceM2Add") as TextBox;
var txtPriceOtherAdd = e.Item.FindControl("txtPriceOtherAdd") as TextBox;
var txtMachIdentityAdd = e.Item.FindControl("txtMachIdentityAdd") as TextBox;
var txtRemarkAdd = e.Item.FindControl("txtRemarkAdd") as TextBox;
var machLookup = new MachLookUp();
machLookup.Code = txtCodeAdd.Text;
machLookup.IdentityImgPath = string.Empty;
machLookup.Intro = txtRemarkAdd.Text;
machLookup.IsActive = true;
machLookup.MachIdentity = txtMachIdentityAdd.Text;
machLookup.Name = txtNameAdd.Text;
machLookup.PriceM = double.Parse(txtPriceMAdd.Text);
machLookup.PriceM2 = double.Parse(txtPriceM2Add.Text);
machLookup.PriceOther = double.Parse(txtPriceOtherAdd.Text);
dal.AddMachLookup(machLookup);
dal.Save();
}
else if (e.CommandName == "Save")
{
var hdId = e.Item.FindControl("hdId") as HiddenField;
var machLookup = dal.GetMachLookupById(int.Parse(hdId.Value));
machLookup.PriceM = double.Parse((e.Item.FindControl("txtPriceM") as TextBox).Text);
machLookup.PriceM2 = double.Parse((e.Item.FindControl("txtPriceM2") as TextBox).Text);
machLookup.PriceOther = double.Parse((e.Item.FindControl("txtPriceOther") as TextBox).Text);
machLookup.MachIdentity = (e.Item.FindControl("txtMachIdentity") as TextBox).Text;
machLookup.Intro = (e.Item.FindControl("txtRemark") as TextBox).Text;
dal.Save();
}
else if (e.CommandName == "Delete")
{
var hdId = e.Item.FindControl("hdId") as HiddenField;
dal.DeleteMachLookup(int.Parse(hdId.Value));
}
BindControl();
}
private PriceInfo GetPriceInfoByProduct(string project, int id)
{
PriceInfo price = new PriceInfo();
if (string.Equals(project, "加工", StringComparison.OrdinalIgnoreCase))
{
MachLookupDAL dal = new MachLookupDAL();
var mach = dal.GetMachLookupById(id);
price.PriceM = mach.PriceM.Value;
price.PriceM2 = mach.PriceM2.Value;
price.PriceOther = mach.PriceOther.Value;
}
else if (string.Equals(project, "安装", StringComparison.OrdinalIgnoreCase))
{
InstallLookupDAL dal = new InstallLookupDAL();
var install = dal.GetLookupById(id);
price.PriceM = install.PriceM.Value;
price.PriceM2 = install.PriceM2.Value;
price.PriceOther = install.PriceOther.Value;
}
else if (string.Equals(project, "材料", StringComparison.OrdinalIgnoreCase))
{
ProductDAL dal = new ProductDAL();
var product = dal.GetProductById(id);
price.PriceM = product.PriceM.Value;
price.PriceM2 = product.PriceM2.Value;
price.PriceOther = product.PriceOther.Value;
}
else if (string.Equals(project, "成品", StringComparison.OrdinalIgnoreCase))
{
EndProductDAL dal = new EndProductDAL();
var endProduct = dal.GetEndProductById(id);
price.PriceM = endProduct.Price.Value;
price.PriceM2 = endProduct.Price.Value;
price.PriceOther = endProduct.Price.Value;
}
return(price);
}
public void BindControl()
{
MachLookupDAL dal = new MachLookupDAL();
Utility.BindDataToRepeater(rpMachiningInstall, dal.GetAllMach());
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string projecttype = context.Request.QueryString["prj"];
string productId = context.Request.QueryString["prd"];
string unit = context.Request.QueryString["unit"];
double price = 0;
if (string.Equals(projecttype, "EndProduct", StringComparison.OrdinalIgnoreCase))
{
EndProductDAL dal = new EndProductDAL();
var ep = dal.GetEndProductById(int.Parse(projecttype));
price = ep.Price.Value;
}
else if (string.Equals(projecttype, "Product", StringComparison.OrdinalIgnoreCase))
{
ProductDAL dal = new ProductDAL();
var product = dal.GetProductById(int.Parse(productId));
if (string.Equals(unit, "M", StringComparison.OrdinalIgnoreCase))
{
price = product.PriceM.Value;
}
else if (string.Equals(unit, "M2", StringComparison.OrdinalIgnoreCase))
{
price = product.PriceM2.Value;
}
else
{
price = product.PriceOther.Value;
}
}
else if (string.Equals(projecttype, "Install", StringComparison.OrdinalIgnoreCase))
{
InstallLookupDAL dal = new InstallLookupDAL();
var install = dal.GetLookupById(int.Parse(productId));
if (string.Equals(unit, "M", StringComparison.OrdinalIgnoreCase))
{
price = install.PriceM.Value;
}
else if (string.Equals(unit, "M2", StringComparison.OrdinalIgnoreCase))
{
price = install.PriceM2.Value;
}
else
{
price = install.PriceOther.Value;
}
}
else if (string.Equals(projecttype, "Mach", StringComparison.OrdinalIgnoreCase))
{
MachLookupDAL dal = new MachLookupDAL();
var mach = dal.GetMachLookupById(int.Parse(productId));
if (string.Equals(unit, "M", StringComparison.OrdinalIgnoreCase))
{
price = mach.PriceM.Value;
}
else if (string.Equals(unit, "M2", StringComparison.OrdinalIgnoreCase))
{
price = mach.PriceM2.Value;
}
else
{
price = mach.PriceOther.Value;
}
}
context.Response.Write(new JavaScriptSerializer().Serialize(price));
}
protected void btnImport_Click(object sender, EventArgs e)
{
DeliveryDAL dal = new DeliveryDAL();
LineItemDAL lDal = new LineItemDAL();
MachSummaryDAL mDAL = new MachSummaryDAL();
MachLookupDAL mlDAL = new MachLookupDAL();
var delivery = dal.GetDeliveryByNo(DeliveryNo);
StringBuilder sb = new StringBuilder(256);
List <MachSummary> machSummaryList = new List <MachSummary>();
foreach (ListItem item in cblMach.Items)
{
if (item.Selected)
{
sb.Append(item.Text).Append("|");
machSummaryList.AddRange(mDAL.GetSummaryByMachId(int.Parse(item.Value)));
}
}
delivery.MachList = sb.ToString();
dal.Save();
var lineItems = lDal.GetLineItemsBySource(this.DeliveryId, SysConst.SourceTypeDelivery);
foreach (var item in lineItems)
{
lDal.DeleteItem(item.LineItem_Id);
}
foreach (var item in machSummaryList)
{
var machLook = mlDAL.GetMachLookupByName(item.MachName);
var lineItem = new LineItem();
lineItem.Intro = item.MachIntro;
lineItem.Name = "加工";
lineItem.Project = item.MachName;
lineItem.Quantity = item.Qty;
lineItem.Remark = item.Remark;
lineItem.SourceId = DeliveryId;
lineItem.SourceType = SysConst.SourceTypeDelivery;
lineItem.Spec = string.Empty;
lineItem.Unit = item.Unit;
if (string.Equals(item.Unit, "米"))
{
lineItem.UnitPrice = machLook.PriceM;
}
else if (string.Equals(item.Unit, "平方米"))
{
lineItem.UnitPrice = machLook.PriceM2;
}
else
{
lineItem.UnitPrice = machLook.PriceOther;
}
lDal.AddLineItem(lineItem);
}
lDal.Save();
UIUtility.BindUserControl(lineItemControl, SysConst.SourceTypeDelivery, DeliveryId);
}
