private void OnEdit()
{
master = new Master_Product();
master.Edit_Product(Convert.ToInt32(txtID.Text)
, txtName.Text
, Convert.ToDecimal(txtWeight.Text)
, (cbbType.SelectedItem as ComboboxItem).Value
, dtpIn.Value
, dtpOut.Value);
MessageBox.Show(Messge.INF_Edit, Messge.CM_Confirm);
OnSearchName();
}
private void OnDelete()
{
master = new Master_Product();
DialogResult dialog = MessageBox.Show(Messge.CM_Delete, Messge.CM_Confirm, MessageBoxButtons.YesNo);
if (dialog == DialogResult.Yes)
{
master.Del_Product(Convert.ToInt32(txtID.Text));
MessageBox.Show(Messge.INF_Delete, Messge.CM_Confirm);
}
else
{
MessageBox.Show(Messge.INF_Cancel, Messge.CM_Confirm);
}
OnSearchName();
}
public ActionResult AddProduct(string product_name, int plant_id, int group_id)
{
try
{
var db = new QISEntities();
var product = new Master_Product();
product.product_name = product_name;
product.plant_id = plant_id;
product.group_id = group_id;
product.product_del_flag = false;
db.Master_Product.Add(product);
db.SaveChanges();
return(Json(true));
}
catch (Exception)
{
return(Json(false));
}
}
private void OnAdd()
{
master = new Master_Product();
DialogResult dialog = MessageBox.Show(Messge.CM_Add, Messge.CM_Confirm, MessageBoxButtons.YesNo);
if (dialog == DialogResult.Yes)
{
master.Add_Product(txtName.Text
, Convert.ToDecimal(txtWeight.Text)
, (cbbType.SelectedItem as ComboboxItem).Value
, (cbCompany.SelectedItem as ComboboxItem).Value
, dtpIn.Value
, dtpOut.Value);
MessageBox.Show(Messge.INF_Save, Messge.CM_Confirm);
}
else
{
MessageBox.Show(Messge.INF_Cancel, Messge.CM_Confirm);
}
OnSearchName();
}
public ActionResult AddProduct(string product_name, int group_id)
{
try
{
var plant = int.Parse(Session["PlantID"].ToString());
var product = new Master_Product();
product.product_name = product_name;
product.plant_id = plant;
product.group_id = group_id;
product.product_del_flag = false;
dbQIS.Master_Product.Add(product);
dbQIS.SaveChanges();
return(Json(true));
}
catch (Exception)
{
return(Json(false));
}
}
private void OnSearchTime()
{
GrdProduct.Rows.Clear();
master = new Master_Product();
List <Product_GetProductTime_Result> result = master.Get_ProductTime(dtpFirst.Value, dtplast.Value);
foreach (Product_GetProductTime_Result re in result)
{
GrdProduct.Rows.Add(GrdProduct.Rows.Count + 1
, re.productID
, re.productName
, re.productKG
, re.bankID
, re.companyID
, re.dateIN
, re.dateOut);
}
if (result.Count > 0)
{
GrdProClick(0);
}
}
private void OnSearchName()
{
GrdProduct.Rows.Clear();
master = new Master_Product();
List <Product_GetProductName_Result> result = master.Get_ProductName(txtSearch.Text.Trim());
foreach (Product_GetProductName_Result re in result)
{
GrdProduct.Rows.Add(GrdProduct.Rows.Count + 1
, re.productID
, re.productName
, re.productKG
, re.bankID
, re.companyID
, re.dateIN
, re.dateOut);
}
if (result.Count > 0)
{
GrdProClick(0);
}
}
