private void btnRelease_Click(object sender, RoutedEventArgs e)
{
if (MessageBox.Show("Confirm Release?", this.Title, MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.No)
{
return;
}
outsoleReleaseMaterialToInsertList.Clear();
foreach (StackPanel sp in spMain.Children)
{
foreach (UIElement ui in sp.Children)
{
if (ui.GetType() == typeof(DataGrid))
{
DataGrid dg = (DataGrid)ui;
List <Object> tags = dg.Tag as List <Object>;
string productNo = tags[0] as String;
List <SizeRunModel> sizeRunList = sizeRunAllList.Where(s => s.ProductNo == productNo).ToList();
DataTable dt = ((DataView)dg.ItemsSource).ToTable();
foreach (DataRow dr in dt.Rows)
{
int cycle = 0;
if (int.TryParse(dr["Cycle"].ToString(), out cycle) == true)
{
for (int i = 0; i <= sizeRunList.Count - 1; i++)
{
SizeRunModel sizeRun = sizeRunList[i];
int qtyRelease = 0;
int.TryParse(dr[String.Format("Column{0}", i)].ToString(), out qtyRelease);
OutsoleReleaseMaterialModel outsoleReleaseMaterial = new OutsoleReleaseMaterialModel
{
ReportId = reportId,
ProductNo = productNo,
Cycle = cycle,
SizeNo = sizeRun.SizeNo,
Quantity = qtyRelease,
};
outsoleReleaseMaterialToInsertList.Add(outsoleReleaseMaterial);
}
}
}
}
}
}
if (outsoleReleaseMaterialToInsertList.Count > 0 && bwInsert.IsBusy == false)
{
this.Cursor = Cursors.Wait;
btnRelease.IsEnabled = false;
bwInsert.RunWorkerAsync();
}
}
public static bool Insert(OutsoleReleaseMaterialModel model)
{
var @ReportId = new SqlParameter("@ReportId", model.ReportId);
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @Cycle = new SqlParameter("@Cycle", model.Cycle);
var @SizeNo = new SqlParameter("@SizeNo", model.SizeNo);
var @Quantity = new SqlParameter("@Quantity", model.Quantity);
SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities();
if (db.ExecuteStoreCommand("EXEC spm_InsertOutsoleReleaseMaterial @ReportId,@ProductNo,@Cycle,@SizeNo,@Quantity", @ReportId, @ProductNo, @Cycle, @SizeNo, @Quantity) >= 1)
{
return(true);
}
return(false);
}
