public void r102Implementation(OrderRelModel instance)
{
// This is the placeholder for method implementation.
if (instance.OrderRelQty <= 0 && instance.FocrelQty <= 0)
{
//
//instance.OrderRelQty = Convert.ToDecimal(instance[OrderRelDataField.OrderRelQty].OldValue);
this.PreventDefault();
Result.Focus("OrderRelQty", "The OrderRelQty Or FOCRelQty must be greater than zero.");
}
if (instance.OrderRelQty > 0)
{
decimal RemainRelQty = (decimal)SqlText.ExecuteScalar("select a.OrderQty - isnull((Select Sum(b.OrderRelQty) from OrderRel b Where b.OrderDtlID=a.OrderDtlID and b.OrderRelID<>@OrderRelID),0) as RemainRelQty from OrderDtl a where a.OrderDtlID=@OrderDtlID "
, new { @OrderRelID = instance.OrderRelID, @OrderDtlID = instance.OrderDtlID });
if (RemainRelQty <= 0)
{
this.PreventDefault();
Result.Focus("OrderRelQty", "Available OrderRelQty is {0}", RemainRelQty);
}
else if (instance.OrderRelQty > RemainRelQty)
{
this.PreventDefault();
Result.Focus("OrderRelQty", "RelQty must be between 1 and {0}", RemainRelQty);
}
}
if (instance.FocrelQty > 0)
{
decimal RemainFocQty = (decimal)SqlText.ExecuteScalar("select a.FOCQty - isnull((Select Sum(b.FOCRelQty) from OrderRel b Where b.OrderDtlID=a.OrderDtlID and b.OrderRelID<>@OrderRelID),0) as RemainRelQty from OrderDtl a where a.OrderDtlID=@OrderDtlID "
, new { @OrderRelID = instance.OrderRelID, @OrderDtlID = instance.OrderDtlID });
if (RemainFocQty <= 0)
{
this.PreventDefault();
Result.Focus("FocrelQty", "Available FOCQty is {0}", RemainFocQty);
}
else if (instance.FocrelQty > RemainFocQty)
{
this.PreventDefault();
Result.Focus("FocrelQty", "FOCQty must be between 1 and {0}", RemainFocQty);
}
}
//if(Convert.ToBoolean(instance.OrderHedBulkOrder))
//{
// int i = SqlText.ExecuteNonQuery("Update OrderDtl set OrderQty=(OrderQty + @Qty) Where OrderDtlID=@OrderDtlID"
// , new { @Qty = instance.OrderRelQty, @OrderDtlID = instance.OrderDtlID });
// //Result.ExecuteOnClient(
// // "this.set_lastCommandName(null);" + // the action state machine is reset
// // "this.goToView('grid1');" + // show 'grid1'
// // "var dv=Web.DataView.find('grid1');" + // find specific master data view
// // "if(dv)dv.refresh();"); // if the view is found then ask it to refresh
//}
}
public void r104Implementation(OrderRelModel instance)
{
// This is the placeholder for method implementation.
//if (Convert.ToBoolean(instance.OrderHedBulkOrder))
//{
// int i = SqlText.ExecuteNonQuery("Update OrderDtl set OrderQty=(OrderQty - @Qty) Where OrderDtlID=@OrderDtlID"
// , new { @Qty = instance.OrderRelQty, @OrderDtlID = instance.OrderDtlID });
//}
if (instance.Seq == 1)
{
PreventDefault();
Result.ShowAlert("First Release Can't Delete!");
}
}
public void r105Implementation(OrderRelModel instance)
{
// This is the placeholder for method implementation.
decimal RemainRelQty = (decimal)SqlText.ExecuteScalar("select a.OrderQty - (Select Sum(isnull(b.OrderRelQty,0)) from OrderRel b Where b.OrderDtlID=a.OrderDtlID) as RemainRelQty from OrderDtl a where a.OrderDtlID=@OrderDtlID ", new { @OrderDtlID = instance.OrderDtlID });
decimal RemainFocQty = (decimal)SqlText.ExecuteScalar("select a.FOCQty - isnull((Select Sum(b.FOCRelQty) from OrderRel b Where b.OrderDtlID=a.OrderDtlID ),0) as RemainRelQty from OrderDtl a where a.OrderDtlID=@OrderDtlID ", new { @OrderDtlID = instance.OrderDtlID });
//if (RemainRelQty <= 0)
//{
// PreventDefault();
//throw new Exception(string.Format("Available OrderRelQty is {0}", RemainRelQty));
instance.OrderRelQty = RemainRelQty;
instance.FocrelQty = RemainFocQty;
Result.ShowMessage("Available OrderRelQty is {0} And FOCRelQty is {1}", RemainRelQty, RemainFocQty);
//}
}
public void r103Implementation(OrderRelModel instance)
{
// This is the placeholder for method implementation.
if (instance.OrderRelQty <= 0 && instance.FocrelQty <= 0)
{
//
//instance.OrderRelQty = Convert.ToDecimal(instance[OrderRelDataField.OrderRelQty].OldValue);
this.PreventDefault();
Result.Focus("OrderRelQty", "The OrderRelQty Or FOCRelQty must be greater than zero.");
}
if (instance.OrderRelQty > 0)
{
decimal RemainRelQty = (decimal)SqlText.ExecuteScalar("select a.OrderQty - isnull((Select Sum(b.OrderRelQty) from OrderRel b Where b.OrderDtlID=a.OrderDtlID),0) as RemainRelQty from OrderDtl a where a.OrderDtlID=@OrderDtlID ", new { @OrderDtlID = instance.OrderDtlID });
if (RemainRelQty <= 0)
{
this.PreventDefault();
Result.Focus("OrderRelQty", "Available OrderRelQty is {0}", RemainRelQty);
}
else if (instance.OrderRelQty > RemainRelQty)
{
this.PreventDefault();
Result.Focus("OrderRelQty", "RelQty must be between 1 and {0}", RemainRelQty);
}
}
if (instance.FocrelQty > 0)
{
decimal RemainFocQty = (decimal)SqlText.ExecuteScalar("select a.FOCQty - isnull((Select Sum(b.FOCRelQty) from OrderRel b Where b.OrderDtlID=a.OrderDtlID ),0) as RemainRelQty from OrderDtl a where a.OrderDtlID=@OrderDtlID ", new { @OrderDtlID = instance.OrderDtlID });
if (RemainFocQty <= 0)
{
this.PreventDefault();
Result.Focus("FocrelQty", "Available FOCQty is {0}", RemainFocQty);
}
else if (instance.FocrelQty > RemainFocQty)
{
this.PreventDefault();
Result.Focus("FocrelQty", "FOCQty must be between 1 and {0}", RemainFocQty);
}
}
if (instance.Seq == null)
{
int i = (int)SqlText.ExecuteScalar("Select Count(OrderRelID)+1 from OrderRel Where OrderDtlID=@OrderDtlID ", new { @OrderDtlID = instance.OrderDtlID });
instance.Seq = i;
}
}
