private void ButtonDeleteFactoryShipping_Click(object sender, RoutedEventArgs e)
{
FactoryShippingName factoryShipping = (FactoryShippingName)(DataGridFactoryShipping).SelectedItem;
int count = ProcessModule.DeleteFactoryShipping(factoryShipping.ShippingNo);
IEnumerable <FactoryShippingName> factoryShippingList = ProcessModule.GetFactoryShipping(factoryShipping.OrderColorDetailNo);
DataGridFactoryShipping.ItemsSource = factoryShippingList;
UpdateDataGridOrderColorFactoryShippingDetail(ProcessOrder.OrderNo);
}
private void ButtonNewFactoryShipping_Click(object sender, RoutedEventArgs e)
{
if (DataGridOrderColorFactoryShippingDetail.SelectedIndex == -1)
{
MessageBox.Show("未選擇出貨顏色!!");
return;
}
if (string.IsNullOrEmpty(TextBoxQuantity.Text))
{
MessageBox.Show("未輸入出貨數量!!");
return;
}
if (ComboBoxCustomer.SelectedIndex == -1)
{
MessageBox.Show("未選擇客戶!!");
return;
}
ProcessOrderColorFactoryShippingDetail processOrderColorDetail = (ProcessOrderColorFactoryShippingDetail)DataGridOrderColorFactoryShippingDetail.SelectedItem;
Customer customer = ComboBoxCustomer.SelectedItem as Customer;
FactoryShippingName factoryShipping = new FactoryShippingName
{
OrderColorDetailNo = processOrderColorDetail.OrderColorDetailNo,
CustomerID = customer.CustomerID,
Quantity = TextBoxQuantity.Text.ToInt(),
CreateDate = DateTime.Now,
ShippingDate = DatePickerShippingDate.SelectedDate
};
int count = ProcessModule.InsertFactoryShipping(factoryShipping);
if (processOrderColorDetail.ShippingQuantity + factoryShipping.Quantity == processOrderColorDetail.Quantity)
{
ProcessModule.UpdateProcessOrderColorStatus(processOrderColorDetail.OrderColorDetailNo, ProcessOrderColorStatus.已出完);
}
IEnumerable <FactoryShippingName> factoryShippingList = ProcessModule.GetFactoryShipping(processOrderColorDetail.OrderColorDetailNo);
DataGridFactoryShipping.ItemsSource = factoryShippingList;
UpdateDataGridOrderColorFactoryShippingDetail(processOrderColorDetail.OrderNo);
}
public int InsertFactoryShipping(FactoryShippingName factoryShippingName)
{
string sql = @"INSERT INTO FactoryShipping
([OrderColorDetailNo]
,[CustomerID]
,[Quantity]
,[CreateDate]
,[ShippingDate])
VALUES
(@OrderColorDetailNo,@CustomerID,@Quantity,@CreateDate,@ShippingDate);";
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@OrderColorDetailNo", SqlDbType.Int)
{
Value = factoryShippingName.OrderColorDetailNo
},
new SqlParameter("@CustomerID", SqlDbType.Int)
{
Value = factoryShippingName.CustomerID
},
new SqlParameter("@Quantity", SqlDbType.Int)
{
Value = factoryShippingName.Quantity
},
new SqlParameter("@CreateDate", SqlDbType.DateTime)
{
Value = factoryShippingName.CreateDate
},
new SqlParameter("@ShippingDate", SqlDbType.DateTime)
{
Value = factoryShippingName.ShippingDate
},
};
return(DapperHelper.ExecuteParameter(AppSettingConfig.ConnectionString(), CommandType.Text, sql, parameters));
}
/// <summary>
/// 新增工廠直送
/// </summary>
/// <param name="factoryShippingName"></param>
/// <returns></returns>
public int InsertFactoryShipping(FactoryShippingName factoryShippingName)
{
var result = ProcessOrderAdapter.InsertFactoryShipping(factoryShippingName);
return(result);
}
