public string GetOrderQty(OrderProperty dataItem)
{
string _result = "0";
try
{
_resultData = _models.SeachOrderQty(dataItem);
if (_resultData.StatusOnDb == true)
{
if (_resultData.ResultOnDb.Rows.Count > 0)
{
_result = _resultData.ResultOnDb.Rows[0]["ORDER_QUANTITY"].ToString();
}
}
else
{
MessageBox.Show(_resultData.MessageOnDb, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(_result);
}
public string GetQtyHistory(OrderProperty dataItem)
{
string _result = "0";
try
{
_resultData = _models.SearchOrderHistory(dataItem);
if (_resultData.StatusOnDb == true)
{
if (_resultData.ResultOnDb.Rows.Count > 0)
{
int Qty = 0;
int qtyOrderHistory;
for (int i = 0; i < _resultData.ResultOnDb.Rows.Count; i++)
{
qtyOrderHistory = Convert.ToInt32(_resultData.ResultOnDb.Rows[i]["QUANTITY"].ToString());
Qty = Qty + qtyOrderHistory;
}
_result = Qty.ToString();
}
}
else
{
MessageBox.Show(_resultData.MessageOnDb, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(_result);
}
public DataTable SearchOrderInThisYear(string product)
{
DataTable _result = new DataTable();
try
{
OrderProperty dataItem = new OrderProperty {
Sub_Product = new SubProductProperty {
PRODUCT_SUB_NAME = product
}
};
_resultData = _models.SearchOrderInThisYear(dataItem);
if (_resultData.StatusOnDb == true)
{
DataTable tableMain = _resultData.ResultOnDb;
_resultData = _models.GetOrderActualInput();
if (_resultData.StatusOnDb == true)
{
DataTable tableOrderActualInput = _resultData.ResultOnDb;
var JoinResult = (from tableFFT_ORDER in tableMain.AsEnumerable()
join tableINPUT in tableOrderActualInput.AsEnumerable() on tableFFT_ORDER.Field <string>("FFT_ORDER_ID") equals tableINPUT.Field <string>("FFT_ORDER_ID") into tempJoin
from leftJoin in tempJoin.DefaultIfEmpty()
select new
{
FFT_ORDER_ID = tableFFT_ORDER.Field <string>("FFT_ORDER_ID"),
ORDER_DATE = tableFFT_ORDER.Field <string>("ORDER_DATE"),
INPUT_STATUS = (leftJoin == null ? 0 - tableFFT_ORDER.Field <int>("ORDER_QUANTITY") : (int)leftJoin.Field <decimal>("ACTUAL_INPUT") - tableFFT_ORDER.Field <int>("ORDER_QUANTITY")) < 0 ? "Incomplete" : "Complete",
ORDER_QUANTITY = tableFFT_ORDER.Field <int>("ORDER_QUANTITY"),
ACTUAL_INPUT = leftJoin == null ? 0 : (int)leftJoin.Field <decimal>("ACTUAL_INPUT"),
INPUT_DIFF = leftJoin == null ? 0 - tableFFT_ORDER.Field <int>("ORDER_QUANTITY") : (int)leftJoin.Field <decimal>("ACTUAL_INPUT") - tableFFT_ORDER.Field <int>("ORDER_QUANTITY"),
ORDER_TYPE_NAME = tableFFT_ORDER.Field <string>("ORDER_TYPE_NAME"),
PRODUCT_NAME = tableFFT_ORDER.Field <string>("PRODUCT_NAME"),
CUSTOMER_NAME = tableFFT_ORDER.Field <string>("CUSTOMER_NAME"),
WORK_ORDER = tableFFT_ORDER.Field <string>("WORK_ORDER"),
PART_NO = tableFFT_ORDER.Field <string>("PART_NO"),
SPEC_NO = tableFFT_ORDER.Field <string>("SPEC_NO"),
SHIPPING_DESTINATION = tableFFT_ORDER.Field <string>("SHIPPING_DESTINATION"),
CUSTOMER_REQUEST = tableFFT_ORDER.Field <string>("CUSTOMER_REQUEST"),
}).ToList();
string json = JsonConvert.SerializeObject(JoinResult);
_result = (DataTable)JsonConvert.DeserializeObject(json, (typeof(DataTable)));
}
else
{
MessageBox.Show(_resultData.MessageOnDb, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show(_resultData.MessageOnDb, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(_result);
}
public IQueryable <T> PaginateAndSort()
{
var ordered = source_;
if (!OrderProperty.Any())
{
ordered = ordered.OrderBy(GridParameters.DefaultPropertyName);
}
foreach (var order in OrderProperty)
{
if (order.Key == OrderProperty.First().Key)
{
ordered = order.Value == "A" ? ordered.OrderBy(order.Key) : ordered.OrderByDescending(order.Key);
}
else
{
ordered = order.Value == "A" ? ((IOrderedQueryable <T>)ordered).ThenBy(order.Key) : ((IOrderedQueryable <T>)ordered).ThenByDescending(order.Key);
}
}
return(ordered
.Skip(SkipCount)
.Take(PageSize));
}
protected void Page_Load(object sender, EventArgs e)
{
order = GetOrderInfo();
if (!IsPostBack)
{
rpBind();
}
}
public string SeachOrderQty(OrderProperty dataItem)
{
sql = @"SELECT QUANTITY AS ORDER_QUANTITY
FROM `fft_order`
WHERE FFT_ORDER_ID = '" + dataItem.FFT_ORDER_ID + @"';";
return(sql);
}
public string SeachSumQtyInputOrder(OrderProperty dataItem)
{
sql = @"SELECT IF(SUM(QUANTITY) IS NULL OR SUM(QUANTITY) = '',0,SUM(QUANTITY)) AS QTY_HISTOTY
FROM `input`
WHERE FFT_ORDER_ID = '" + dataItem.FFT_ORDER_ID + @"';";
return(sql);
}
public string SearchOrderUseDatabasePC(OrderProperty dataItem)
{
sql = @"SELECT `FFT_ORDER_ID`,`USED_DATE`
FROM `order_used`
WHERE `FFT_ORDER_ID` = '" + dataItem.FFT_ORDER_ID + @"';";
return(sql);
}
protected void Page_Load(object sender, EventArgs e)
{
order = GetOrderInfo();
if (!IsPostBack)
{
rpBind();
}
}
public SettingsPropertyDefinitionWrapper(object @object) : base()
{
var type = @object.GetType();
SettingsIdProperty = AccessTools.Property(type, nameof(SettingsId));
SettingTypeProperty = AccessTools.Property(type, nameof(SettingType));
PropertyProperty = AccessTools.Property(type, nameof(PropertyReference));
DisplayNameProperty = AccessTools.Property(type, nameof(DisplayName));
HintTextProperty = AccessTools.Property(type, nameof(HintText));
OrderProperty = AccessTools.Property(type, nameof(Order));
RequireRestartProperty = AccessTools.Property(type, nameof(RequireRestart));
GroupNameProperty = AccessTools.Property(type, nameof(GroupName));
IsMainToggleProperty = AccessTools.Property(type, nameof(IsMainToggle));
MinValueProperty = AccessTools.Property(type, nameof(MinValue));
MaxValueProperty = AccessTools.Property(type, nameof(MaxValue));
EditableMinValueProperty = AccessTools.Property(type, nameof(EditableMinValue));
EditableMaxValueProperty = AccessTools.Property(type, nameof(EditableMaxValue));
SelectedIndexProperty = AccessTools.Property(type, nameof(SelectedIndex));
SettingsId = SettingsIdProperty?.GetValue(@object) as string ?? "ERROR";
SettingType = SettingTypeProperty?.GetValue(@object) is { } settingTypeObject
? Enum.TryParse <SettingType>(settingTypeObject.ToString(), out var resultEnum)
? resultEnum
: SettingType.NONE
: SettingType.NONE;
PropertyReference = PropertyProperty?.GetValue(@object) is { } value
? value is IRef @ref ? @ref : new RefWrapper(value)
: null;
DisplayName = DisplayNameProperty?.GetValue(@object) switch
{
string str => str,
TextObject to => to.ToString(),
_ => DisplayName
};
HintText = HintTextProperty?.GetValue(@object) switch
{
string str => str,
TextObject to => to.ToString(),
_ => HintText
};
Order = OrderProperty?.GetValue(@object) as int? ?? -1;
RequireRestart = RequireRestartProperty?.GetValue(@object) as bool? ?? true;
GroupName = GroupNameProperty?.GetValue(@object) as string ?? "";
IsMainToggle = IsMainToggleProperty?.GetValue(@object) as bool? ?? false;
MinValue = MinValueProperty?.GetValue(@object) is { } minVal?minVal as decimal? ?? 0 : 0;
MaxValue = MaxValueProperty?.GetValue(@object) is { } maxVal?maxVal as decimal? ?? 0 : 0;
EditableMinValue = EditableMinValueProperty?.GetValue(@object) is { } eMinVal? eMinVal as decimal? ?? 0 : 0;
EditableMaxValue = EditableMaxValueProperty?.GetValue(@object) is { } eMaxValue?eMaxValue as decimal? ?? 0 : 0;
SelectedIndex = SelectedIndexProperty?.GetValue(@object) as int? ?? 0;
}
}
}
public bool IsValid(OrderProperty orderProperty, Type valueType)
{
if (!ValidTypes.ContainsKey(orderProperty))
{
throw new NotImplementedException("Unknown Order Property");
}
return(ValidTypes[orderProperty].Contains(valueType));
}
private void Page_Load()
{
_order = new OrderProperty();
this.SearchInputAll();
this.lblFFT_ORDER_ID.Text = "- - - - - -";
this.lblGroup.Text = "- - - - - -";
this.txtQty.Clear();
}
protected void Page_Load(object sender, EventArgs e)
{
order = GetOrderInfo();//为OrderProperty类对象赋值
if (!IsPostBack)
{
ModifyBind(); //显示订单状态
rpBind(); //显示订单中商品的详细信息
}
}
protected void Page_Load(object sender, EventArgs e)
{
UnobtrusiveValidationMode = UnobtrusiveValidationMode.None;
order = GetOrderInfo();
if (!IsPostBack)
{
rpBind();
}
}
public string SearchInputType(OrderProperty dataItem)
{
sql = @"SELECT ID
,INPUT_TYPE
FROM `input_type`
WHERE REPLACE(INPUT_TYPE, ' ', '') = REPLACE('" + dataItem.ORDER_TYPE_NAME + "', ' ', '');";
return(sql);
}
protected void Page_Load(object sender, EventArgs e)
{
UnobtrusiveValidationMode = UnobtrusiveValidationMode.None;
order = GetOrderInfo();//为OrderProperty类对象赋值
if (!IsPostBack)
{
ModifyBind(); //显示订单状态
rpBind(); //显示订单中商品的详细信息
}
}
public PropertyUpdatedPayload(OrderProperty orderProperty, object value)
{
Name = Enum.GetName(typeof(OrderProperty), orderProperty);
var valueType = value?.GetType();
var validator = new PropertyTypeValidator();
if (!validator.IsValid(orderProperty, valueType))
{
throw new NotSupportedException($"The property {Name} does not support a value with type {valueType.Name}");
}
Type = valueType?.FullName;
Value = value;
}
public string InsertInputPurchase(OrderProperty dataItem)
{
sql = @"INSERT INTO `input_purchase`(
`FFT_ORDER_ID`
,`GROUP`
,`PURCHASE_ID`
)
(
SELECT '" + dataItem.FFT_ORDER_ID + @"' AS `FFT_ORDER_ID`
,(SELECT MAX(`GROUP`) FROM `input` WHERE `FFT_ORDER_ID` = '" + dataItem.FFT_ORDER_ID + @"') AS `GROUP`
,(SELECT ID FROM `purchase` WHERE PURCHASE_NO = '" + dataItem.PURCHASR.PURCHASE_NO + @"') AS `PURCHASE_ID`
)";
return(sql);
}
public string InsertOrderUseDatabasePC(OrderProperty dataItem)
{
sql = @"INSERT INTO `order_used` (
`FFT_ORDER_ID`
,`USED_DATE`
)
VALUES(
'" + dataItem.FFT_ORDER_ID + @"'
,NOW()
)
";
return(sql);
}
public string SearchOrderInput(OrderProperty dataItem)
{
sql = @"SELECT `INUSE`
,`SERIAL_ID`
,`FFT_ORDER_ID`
,`GROUP`
,`FLOW_ID`
,`DATE`
FROM `input_serial`
WHERE `FFT_ORDER_ID` = '" + dataItem.FFT_ORDER_ID + @"'
AND `GROUP` = '" + dataItem.GROUP + "'";
return(sql);
}
public string InsertInputType(OrderProperty dataItem)
{
sql = @"INSERT INTO `input_type` (
ID
,INPUT_TYPE
)
(
SELECT CASE WHEN COUNT(`ID`) = 0 THEN 1 ELSE MAX(`ID`)+1 END AS `ID`
,'" + dataItem.ORDER_TYPE_NAME + @"' AS `INPUT_TYPE`
FROM `input_type`
);";
return(sql);
}
public string SearchOrderInThisYear(OrderProperty dataItem)
{
//## !!! Have different database name join in Qry. !!!!!!!!!!!!!!! ###################################
// Product ID 11 is Cavity
sql = @"
SELECT `tb_1`.`FFT_ORDER_ID` AS `FFT_ORDER_ID`
,DATE_FORMAT(`tb_1`.`ORDER_DATE`, '%Y-%m-%d') AS `ORDER_DATE`
,`tb_1`.`QUANTITY` AS `ORDER_QUANTITY`
,`tb_5`.`ORDER_TYPE_NAME` AS `ORDER_TYPE_NAME`
,`tb_2`.`PRODUCT_NAME` AS `PRODUCT_NAME`
,`tb_3`.`CUSTOMER_NAME` AS `CUSTOMER_NAME`
,`tb_1`.`WORK_ORDER` AS `WORK_ORDER`
,`tb_1`.`PART_NO` AS `PART_NO`
,`tb_1`.`SPEC_NO` AS `SPEC_NO`
,`tb_4`.`SHIPPING_DESTINATION` AS `SHIPPING_DESTINATION`
,DATE_FORMAT(`tb_1`.`CUSTOMER_REQUEST`, '%Y-%m-%d') AS `CUSTOMER_REQUEST`
FROM `fft_order` AS `tb_1`
INNER JOIN `item_product` AS `tb_2`
ON(`tb_2`.`PRODUCT_ID` = `tb_1`.`PRODUCT_ID`)
INNER JOIN `item_customer` AS `tb_3`
ON(`tb_3`.`CUSTOMER_ID` = `tb_1`.`CUSTOMER_ID`)
INNER JOIN `item_ship_destination` AS `tb_4`
ON(`tb_4`.`SHIP_DEST_ID` = `tb_1`.`SHIP_DEST_ID`)
INNER JOIN `item_order_type` AS `tb_5`
ON(`tb_5`.`ORDER_TYPE_ID` = `tb_1`.`ORDER_TYPE_ID`)
INNER JOIN `item_product` AS `tb6`
ON (tb6.PRODUCT_ID = tb_1.PRODUCT_ID)
WHERE `tb6`.`PRODUCT_NAME` = 'dataItem.SUB_PRODUCT.PRODUCT_SUB_NAME'
AND `tb_5`.`ORDER_TYPE_NAME` LIKE '" + dataItem.ORDER_TYPE_NAME + @"%'
AND YEAR(`tb_1`.`ORDER_DATE`) = YEAR(NOW())
ORDER BY `tb_1`.`ORDER_DATE` DESC,`tb_1`.`FFT_ORDER_ID` DESC;";
sql = sql.Replace("dataItem.SUB_PRODUCT.PRODUCT_SUB_NAME", dataItem.Sub_Product.PRODUCT_SUB_NAME);
return(sql);
}
public string InsertInputProduction(OrderProperty dataItem)
{
sql = @"INSERT INTO `input` (
`FFT_ORDER_ID`
,`GROUP`
,`INPUT_TYPE_ID`
,`CONDITION_ID`
,`QUANTITY`
,`INPUT_DATE`
,`EMP_ID`
,`PRODUCT_SUB_CODE`
)
(
SELECT '" + dataItem.FFT_ORDER_ID + @"' AS `FFT_ORDER_ID`
,(SELECT CASE WHEN COUNT(`GROUP`) = 0 THEN 1 ELSE MAX(`GROUP`)+1 END FROM `input` WHERE FFT_ORDER_ID = '" + dataItem.FFT_ORDER_ID + @"') AS `MAX_GROUP`
,(SELECT ID FROM `input_type` WHERE INPUT_TYPE = '" + dataItem.ORDER_TYPE_NAME + @"') AS `INPUT_TYPE_ID`
,(SELECT tb_1.`ID` AS `ID`
FROM `condition` AS tb_1
INNER JOIN `product_sub` AS tb_2
ON (tb_2.`PRODUCT_SUB_CODE` = tb_1.`PRODUCT_SUB_CODE`)
INNER JOIN `customer` AS tb_3
ON (tb_3.`ID` = tb_1.`CUSTOMER_ID`)
INNER JOIN `work_order` AS tb_4
ON (tb_4.`ID` = tb_1.`WORK_ORDER_ID`)
INNER JOIN `part_no` AS tb_5
ON (tb_5.`ID` = tb_1.`PART_NO_ID`)
WHERE REPLACE(tb_2.PRODUCT_SUB_CODE, ' ', '') = REPLACE('" + dataItem.CONDITION.PRODUCT_SUB_CODE + @"', ' ', '')
AND REPLACE(tb_3.CUSTOMER_NAME, ' ', '') = REPLACE('" + dataItem.CONDITION.CUSTOMER_NAME + @"', ' ', '')
AND REPLACE(tb_4.WORK_ORDER, ' ', '') = REPLACE('" + dataItem.CONDITION.WORK_ORDER + @"', ' ', '')
AND REPLACE(tb_5.PART_NO, ' ', '') = REPLACE('" + dataItem.CONDITION.PART_NO + @"', ' ', '')
) AS `CONDITION_ID`
, '" + dataItem.ORDER_QUANTITY + @"' AS `QUANTITY`
, '" + dataItem.ORDER_DATE + @"' AS `INPUT_DATE`
,'" + dataItem.EMP.code + @"' AS `EMP_ID`
,'" + dataItem.Sub_Product.PRODUCT_SUB_CODE + @"' AS `PRODUCT_SUB_CODE`
);";
return(sql);
}
/// <summary>
/// Set the property to use when ordering <see cref="Ingredients"/>.
///
/// <para>
/// Hook this to <see cref="Dropdown.onValueChanged"/>.
/// </para>
///
/// </summary>
public void SetOrderProperty()
{
if (Enum.IsDefined(typeof(OrderProperty), orderDropDown.value))
{
orderProperty = (OrderProperty)orderDropDown.value;
}
else
{
orderProperty = OrderProperty.Name;
}
_ingredients = _ingredients
.OrderByProperty(orderProperty, orderAscending)
.ToList();
RefreshScrollList();
}
public string SearchPurchasesOrder(OrderProperty dataItem)
{
sql = @"SELECT `tb_1`.`ID` AS `ID`
,`tb_1`.`PURCHASE_NO` AS `DOCUMENT_NO`
,IF(`tb_6`.`FFT_CODE` IS NULL OR `tb_6`.`FFT_CODE` = '', 'N/A',`tb_6`.`FFT_CODE`) AS `FFT_CODE`
,IF(`tb_7`.`PURCHASE_ID` IS NULL OR `tb_7`.`PURCHASE_ID` = '','N/A',`tb_8`.`FLOW_NAME`) AS `FLOW_NAME`
,`tb_2`.`PART_NO` AS `PART_NO`
,`tb_3`.`PRODUCT_NAME` AS `PRODUCT_NAME`
,`tb_4`.`MODEL_NO` AS `MODEL_NO`
,DATE_FORMAT(`tb_1`.`DATE`, '%Y-%m-%d') AS `CREATE_DATE`
,`tb_1`.`EMP_ID` AS `EMP_ID`
,DATE_FORMAT(`tb_1`.`LAST_UPDATE`, '%Y-%m-%d %H:%i:%s') AS `LAST_UPDATE`
FROM `purchase` AS `tb_1`
INNER JOIN `part_no` AS `tb_2`
ON(`tb_2`.`ID` = `tb_1`.`PART_NO_ID`)
INNER JOIN `product_purchase` AS `tb_3`
ON(`tb_3`.`ID` = `tb_1`.`PURCHASE_PRODUCT_ID`)
INNER JOIN `model` AS `tb_4`
ON(`tb_4`.`ID` = `tb_1`.`MODEL_ID`)
LEFT JOIN `purchase_fft_code` AS `tb_5`
ON(`tb_5`.`PURCHASE_ID` = `tb_1`.`ID`)
LEFT JOIN `fft_code` AS `tb_6`
ON(`tb_6`.`ID` = `tb_5`.`FFT_CODE_ID`)
LEFT JOIN `flow_process` AS `tb_7`
ON (`tb_7`.PURCHASE_ID = `tb_1`.ID AND `tb_7`.INUSE = 1)
LEFT JOIN `flow` AS `tb_8`
ON (`tb_8`.ID = `tb_7`.FLOW_ID)
WHERE `tb_2`.`PART_NO` = '" + dataItem.CONDITION.PART_NO + @"'
ORDER BY `tb_1`.`ID`";
return(sql);
}
public List <PurchaseProperty> SearchPurchasesOrder(OrderProperty dataItem)
{
List <PurchaseProperty> _result = new List <PurchaseProperty>();
try
{
_resultData = _models.SearchPurchasesOrder(dataItem);
if (_resultData.StatusOnDb == true)
{
if (_resultData.ResultOnDb.Rows.Count > 0)
{
for (int i = 0; i < _resultData.ResultOnDb.Rows.Count; i++)
{
PurchaseProperty _purchase = new PurchaseProperty
{
ID = _resultData.ResultOnDb.Rows[i]["ID"].ToString(),
PURCHASE_NO = _resultData.ResultOnDb.Rows[i]["DOCUMENT_NO"].ToString(),
FFT_CODE = _resultData.ResultOnDb.Rows[i]["FFT_CODE"].ToString(),
FLOW = new FlowProperty {
FLOW_NAME = _resultData.ResultOnDb.Rows[i]["FLOW_NAME"].ToString()
},
PRODUCT_PURCHASE = _resultData.ResultOnDb.Rows[i]["PRODUCT_NAME"].ToString(),
PART_NO = _resultData.ResultOnDb.Rows[i]["PART_NO"].ToString(),
MODEL = _resultData.ResultOnDb.Rows[i]["MODEL_NO"].ToString(),
DATE = _resultData.ResultOnDb.Rows[i]["CREATE_DATE"].ToString(),
};
_result.Add(_purchase);
}
}
}
else
{
MessageBox.Show(_resultData.MessageOnDb, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(_result);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(_result);
}
}
public string SearchOrderHistory(OrderProperty dataItem)
{
sql = @"SELECT
tb_2.INPUT_TYPE
,tb_1.FFT_ORDER_ID
,tb_1.`GROUP`
,tb_1.QUANTITY
,tb_7.PRODUCT_SUB_NAME
,tb_6.CUSTOMER_NAME
,tb_5.WORK_ORDER
,tb_4.PART_NO
,tb_1.EMP_ID
,tb_1.INPUT_DATE
FROM `input` AS tb_1
INNER JOIN `input_type` As tb_2
ON(tb_2.ID = tb_1.INPUT_TYPE_ID)
INNER JOIN `condition` As tb_3
ON(tb_3.ID = tb_1.CONDITION_ID)
INNER JOIN `part_no` As tb_4
ON(tb_4.ID = tb_3.PART_NO_ID)
INNER JOIN `work_order` As tb_5
ON(tb_5.ID = tb_3.WORK_ORDER_ID)
INNER JOIN `customer` As tb_6
ON(tb_6.ID = tb_3.CUSTOMER_ID)
INNER JOIN `product_sub` As tb_7
ON(tb_7.PRODUCT_SUB_CODE = tb_3.PRODUCT_SUB_CODE)
WHERE tb_1.FFT_ORDER_ID = '" + dataItem.FFT_ORDER_ID + @"'
ORDER BY `GROUP`;";
return(sql);
}
private void adgvListInput_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex >= 0 && e.ColumnIndex >= 0)
{
if (this.adgvListInput.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null)
{
_order = new OrderProperty
{
FFT_ORDER_ID = this.adgvListInput.Rows[e.RowIndex].Cells["FFT_ORDER_ID"].FormattedValue.ToString(),
GROUP = this.adgvListInput.Rows[e.RowIndex].Cells["GROUP"].FormattedValue.ToString(),
ORDER_QUANTITY = this.adgvListInput.Rows[e.RowIndex].Cells["QUANTITY"].FormattedValue.ToString()
};
if (_controllers.OrderInputExist(_order))
{
MessageBox.Show("FFT_ORDER_ID : " + _order.FFT_ORDER_ID + "\n" + "GROUT : " + _order.GROUP + " Already Input.", "Stop", MessageBoxButtons.OK, MessageBoxIcon.Stop);
this.adgvListInput.Rows[e.RowIndex].Selected = false;
this.adgvListInput.Rows[this.rowIndex_OldSelect].Selected = true;
return;
}
else
{
this.lblFFT_ORDER_ID.Text = _order.FFT_ORDER_ID;
this.lblGroup.Text = _order.GROUP;
this.txtQty.Text = _order.ORDER_QUANTITY;
this.rowIndex_OldSelect = e.RowIndex;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Stop", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
public string UpdateInput(OrderProperty dataItem)
{
sql = @"/*Update data in main table.*/
UPDATE `input`
SET QUANTITY = '" + dataItem.ORDER_QUANTITY + @"'
,EMP_ID = '" + dataItem.EMP.code + @"'
WHERE `FFT_ORDER_ID` = '" + dataItem.FFT_ORDER_ID + @"'
AND `GROUP` = '" + dataItem.GROUP + @"';
/*Insert to History*/
INSERT INTO `input_history`(
`FFT_ORDER_ID`
,`GROUP`
,`INPUT_TYPE_ID`
,`CONDITION_ID`
,`QUANTITY`
,`INPUT_DATE`
,`EMP_ID`
,`LAST_UPDATE`
,`BACKUP_DATE`
)
(
SELECT `FFT_ORDER_ID`
,`GROUP`
,`INPUT_TYPE_ID`
,`CONDITION_ID`
,`QUANTITY`
,`INPUT_DATE`
,`EMP_ID`
,`LAST_UPDATE`
,NOW() AS `BACKUP_DATE`
FROM `input`
WHERE `FFT_ORDER_ID` = '" + dataItem.FFT_ORDER_ID + @"'
AND `GROUP` = '" + dataItem.GROUP + @"'
);";
return(sql);
}
public bool OrderInputExist(OrderProperty dataItem)
{
bool _result = true;
try
{
_resultData = _models.SearchOrderInput(dataItem);
if (_resultData.StatusOnDb == true)
{
_result = _resultData.ResultOnDb.Rows.Count > 0 ? true : false;
return(_result);
}
else
{
MessageBox.Show(_resultData.MessageOnDb, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(_result);
}
public DataTable GetQtyHistoryAll(OrderProperty dataItem)
{
DataTable _result = new DataTable();
try
{
_resultData = _models.SearchOrderHistory(dataItem);
if (_resultData.StatusOnDb == true)
{
_result = _resultData.ResultOnDb;
}
else
{
MessageBox.Show(_resultData.MessageOnDb, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(_result);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(_result);
}
}
protected void Page_Load(object sender, EventArgs e)
{
order = GetOrderInfo();//为OrderProperty类对象赋值
if (!IsPostBack)
{
ModifyBind();//显示订单状态
rpBind();//显示订单中商品的详细信息
}
}
