public T_CNGrouping Selectt_CNGrouping(T_CNGrouping objt_CNGrouping, string cnnum, string itemcode)
{
try
{
strquery = @"SELECT * FROM dbo.T_CNGrouping WHERE Docno = '" + cnnum + "' AND ItemCode = '" + itemcode + "'";
DataRow drType = u_DBConnection.ReturnDataRow(strquery);
if (drType != null)
{
objt_CNGrouping.Docno = drType["Docno"].ToString();
objt_CNGrouping.ItemCode = drType["ItemCode"].ToString();
objt_CNGrouping.Name = drType["Name"].ToString();
objt_CNGrouping.CNType = drType["CNType"].ToString();
objt_CNGrouping.CNReason = drType["CNReason"].ToString();
objt_CNGrouping.InvoiceQty = decimal.Parse(drType["InvoiceQty"].ToString());
objt_CNGrouping.CNQTY = decimal.Parse(drType["CNQTY"].ToString());
objt_CNGrouping.BreakdownQTY = decimal.Parse(drType["BreakdownQTY"].ToString());
objt_CNGrouping.TagNumber = drType["TagNumber"].ToString();
objt_CNGrouping.Selected = bool.Parse(drType["Selected"].ToString());
objt_CNGrouping.SelectedQTY = decimal.Parse(drType["SelectedQTY"].ToString());
objt_CNGrouping.balanceQTY = decimal.Parse(drType["balanceQTY"].ToString());
objt_CNGrouping.Shipped = bool.Parse(drType["Shipped"].ToString());
objt_CNGrouping.ShippedDate = DateTime.Parse(drType["ShippedDate"].ToString());
objt_CNGrouping.ShippedDO = drType["ShippedDO"].ToString();
objt_CNGrouping.CNnumber = drType["CNnumber"].ToString();
objt_CNGrouping.PartEntered = bool.Parse(drType["PartEntered"].ToString());
return(objt_CNGrouping);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Saves a record to the T_CNGrouping table.
/// </summary>
public Boolean Savet_CNGroupingSP(T_CNGrouping t_CNGrouping, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_CNGroupingSave";
scom.Parameters.Add("@Docno", SqlDbType.VarChar, 20).Value = t_CNGrouping.Docno;
scom.Parameters.Add("@ItemCode", SqlDbType.VarChar, 20).Value = t_CNGrouping.ItemCode;
scom.Parameters.Add("@Name", SqlDbType.VarChar, 150).Value = t_CNGrouping.Name;
scom.Parameters.Add("@CNType", SqlDbType.VarChar, 20).Value = t_CNGrouping.CNType;
scom.Parameters.Add("@CNReason", SqlDbType.VarChar, 20).Value = t_CNGrouping.CNReason;
scom.Parameters.Add("@InvoiceQty", SqlDbType.Decimal, 9).Value = t_CNGrouping.InvoiceQty;
scom.Parameters.Add("@CNQTY", SqlDbType.Decimal, 9).Value = t_CNGrouping.CNQTY;
scom.Parameters.Add("@BreakdownQTY", SqlDbType.Decimal, 9).Value = t_CNGrouping.BreakdownQTY;
scom.Parameters.Add("@TagNumber", SqlDbType.VarChar, 50).Value = t_CNGrouping.TagNumber;
scom.Parameters.Add("@Selected", SqlDbType.Bit, 1).Value = t_CNGrouping.Selected;
scom.Parameters.Add("@SelectedQTY", SqlDbType.Decimal, 9).Value = t_CNGrouping.SelectedQTY;
scom.Parameters.Add("@balanceQTY", SqlDbType.Decimal, 9).Value = t_CNGrouping.balanceQTY;
scom.Parameters.Add("@Shipped", SqlDbType.Bit, 1).Value = t_CNGrouping.Shipped;
scom.Parameters.Add("@ShippedDate", SqlDbType.DateTime, 8).Value = t_CNGrouping.ShippedDate;
scom.Parameters.Add("@ShippedDO", SqlDbType.VarChar, 20).Value = t_CNGrouping.ShippedDO;
scom.Parameters.Add("@CNnumber", SqlDbType.VarChar, 20).Value = t_CNGrouping.CNnumber;
scom.Parameters.Add("@PartEntered", SqlDbType.Bit, 1).Value = t_CNGrouping.PartEntered;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
public List <T_CNGrouping> SelectT_CNGroupingMulti(T_CNGrouping objt_CNGrouping2)
{
List <T_CNGrouping> retval = new List <T_CNGrouping>();
try
{
strquery = @"select * from t_CNGrouping where Docno = '" + objt_CNGrouping2.Docno + "'";
DataTable dtt_CNGrouping = u_DBConnection.ReturnDataTable(strquery, CommandType.Text);
foreach (DataRow drType in dtt_CNGrouping.Rows)
{
if (drType != null)
{
T_CNGrouping objt_CNGrouping = new T_CNGrouping();
objt_CNGrouping.Docno = drType["Docno"].ToString();
objt_CNGrouping.ItemCode = drType["ItemCode"].ToString();
objt_CNGrouping.Name = drType["Name"].ToString();
objt_CNGrouping.CNType = drType["CNType"].ToString();
objt_CNGrouping.CNReason = drType["CNReason"].ToString();
objt_CNGrouping.InvoiceQty = decimal.Parse(drType["InvoiceQty"].ToString());
objt_CNGrouping.CNQTY = decimal.Parse(drType["CNQTY"].ToString());
objt_CNGrouping.BreakdownQTY = decimal.Parse(drType["BreakdownQTY"].ToString());
objt_CNGrouping.TagNumber = drType["TagNumber"].ToString();
objt_CNGrouping.Selected = bool.Parse(drType["Selected"].ToString());
objt_CNGrouping.SelectedQTY = decimal.Parse(drType["SelectedQTY"].ToString());
objt_CNGrouping.balanceQTY = decimal.Parse(drType["balanceQTY"].ToString());
objt_CNGrouping.Shipped = bool.Parse(drType["Shipped"].ToString());
objt_CNGrouping.ShippedDate = DateTime.Parse(drType["ShippedDate"].ToString());
objt_CNGrouping.ShippedDO = drType["ShippedDO"].ToString();
objt_CNGrouping.CNnumber = drType["CNnumber"].ToString();
objt_CNGrouping.PartEntered = bool.Parse(drType["PartEntered"].ToString());
retval.Add(objt_CNGrouping);
}
}
return(retval);
}
catch (Exception ex)
{
throw ex;
}
}
