public T_OrderFormDet Selectt_OrderFormDet(T_OrderFormDet objt_OrderFormDet) { try { strquery = @"select * from t_OrderFormDet where Docno = '" + objt_OrderFormDet.Docno + "'"; DataRow drType = u_DBConnection.ReturnDataRow(strquery); if (drType != null) { objt_OrderFormDet.Docno = drType["Docno"].ToString(); objt_OrderFormDet.CompCode = drType["CompCode"].ToString(); objt_OrderFormDet.Locacode = drType["Locacode"].ToString(); objt_OrderFormDet.OFNo = drType["OFNo"].ToString(); objt_OrderFormDet.ItemCode = drType["ItemCode"].ToString(); objt_OrderFormDet.Quntity = decimal.Parse(drType["Quntity"].ToString()); objt_OrderFormDet.Barcode = drType["Barcode"].ToString(); objt_OrderFormDet.UnitPrice = decimal.Parse(drType["UnitPrice"].ToString()); objt_OrderFormDet.CostPrice = decimal.Parse(drType["CostPrice"].ToString()); objt_OrderFormDet.discper = decimal.Parse(drType["discper"].ToString()); objt_OrderFormDet.discount = decimal.Parse(drType["discount"].ToString()); objt_OrderFormDet.Unit = drType["Unit"].ToString(); objt_OrderFormDet.Amountx = decimal.Parse(drType["Amountx"].ToString()); return(objt_OrderFormDet); } return(null); } catch (Exception ex) { throw ex; } }
/// <summary> /// Saves a record to the T_OrderFormDet table. /// </summary> public Boolean Savet_OrderFormDetSP(T_OrderFormDet t_OrderFormDet, int formMode) { SqlCommand scom; bool retvalue = false; try { scom = new SqlCommand(); scom.CommandType = CommandType.StoredProcedure; scom.CommandText = "T_OrderFormDetSave"; scom.Parameters.Add("@Docno", SqlDbType.VarChar, 20).Value = t_OrderFormDet.Docno; scom.Parameters.Add("@CompCode", SqlDbType.VarChar, 20).Value = t_OrderFormDet.CompCode; scom.Parameters.Add("@Locacode", SqlDbType.VarChar, 20).Value = t_OrderFormDet.Locacode; scom.Parameters.Add("@OFNo", SqlDbType.VarChar, 20).Value = t_OrderFormDet.OFNo; scom.Parameters.Add("@ItemCode", SqlDbType.VarChar, 20).Value = t_OrderFormDet.ItemCode; scom.Parameters.Add("@Quntity", SqlDbType.Decimal, 9).Value = t_OrderFormDet.Quntity; scom.Parameters.Add("@Barcode", SqlDbType.VarChar, 20).Value = t_OrderFormDet.Barcode; scom.Parameters.Add("@UnitPrice", SqlDbType.Decimal, 9).Value = t_OrderFormDet.UnitPrice; scom.Parameters.Add("@CostPrice", SqlDbType.Decimal, 9).Value = t_OrderFormDet.CostPrice; scom.Parameters.Add("@Unit", SqlDbType.VarChar, 20).Value = t_OrderFormDet.Unit; scom.Parameters.Add("@Amountx", SqlDbType.Decimal, 9).Value = t_OrderFormDet.Amountx; scom.Parameters.Add("@discper", SqlDbType.Decimal, 9).Value = t_OrderFormDet.discper; scom.Parameters.Add("@discount", SqlDbType.Decimal, 9).Value = t_OrderFormDet.discount; 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_OrderFormDet> SelectT_OrderFormDetMulti(T_OrderFormDet objt_OrderFormDet2) { List <T_OrderFormDet> retval = new List <T_OrderFormDet>(); try { strquery = @"select * from t_OrderFormDet where Docno = '" + objt_OrderFormDet2.Docno + "'"; DataTable dtt_OrderFormDet = u_DBConnection.ReturnDataTable(strquery, CommandType.Text); foreach (DataRow drType in dtt_OrderFormDet.Rows) { if (drType != null) { T_OrderFormDet objt_OrderFormDet = new T_OrderFormDet(); objt_OrderFormDet.Docno = drType["Docno"].ToString(); objt_OrderFormDet.CompCode = drType["CompCode"].ToString(); objt_OrderFormDet.Locacode = drType["Locacode"].ToString(); objt_OrderFormDet.OFNo = drType["OFNo"].ToString(); objt_OrderFormDet.ItemCode = drType["ItemCode"].ToString(); objt_OrderFormDet.Quntity = decimal.Parse(drType["Quntity"].ToString()); objt_OrderFormDet.Barcode = drType["Barcode"].ToString(); objt_OrderFormDet.UnitPrice = decimal.Parse(drType["UnitPrice"].ToString()); objt_OrderFormDet.CostPrice = decimal.Parse(drType["CostPrice"].ToString()); objt_OrderFormDet.discper = decimal.Parse(drType["discper"].ToString()); objt_OrderFormDet.discount = decimal.Parse(drType["discount"].ToString()); objt_OrderFormDet.Unit = drType["Unit"].ToString(); objt_OrderFormDet.Amountx = decimal.Parse(drType["Amountx"].ToString()); retval.Add(objt_OrderFormDet); } } return(retval); } catch (Exception ex) { throw ex; } }