/// <summary> /// Saves a record to the T_packingdet table. /// </summary> public Boolean Savet_packingdetSP(T_packingdet t_packingdet, int formMode) { SqlCommand scom; bool retvalue = false; try { scom = new SqlCommand(); scom.CommandType = CommandType.StoredProcedure; scom.CommandText = "T_packingdetSave"; scom.Parameters.Add("@PackingNo", SqlDbType.VarChar, 20).Value = t_packingdet.PackingNo; scom.Parameters.Add("@Dono", SqlDbType.VarChar, 20).Value = t_packingdet.Dono; scom.Parameters.Add("@Customer", SqlDbType.VarChar, 20).Value = t_packingdet.Customer; scom.Parameters.Add("@Agent", SqlDbType.VarChar, 20).Value = t_packingdet.Agent; scom.Parameters.Add("@datex", SqlDbType.DateTime, 8).Value = t_packingdet.datex; scom.Parameters.Add("@TTLCartons", SqlDbType.Decimal, 9).Value = t_packingdet.TTLCartons; 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_packingdet> SelectT_packingdetMulti(T_packingdet objt_packingdet2) { List <T_packingdet> retval = new List <T_packingdet>(); try { strquery = @"select * from T_packingdet where PackingNo = '" + objt_packingdet2.PackingNo + "'"; DataTable dtt_packingdet = u_DBConnection.ReturnDataTable(strquery, CommandType.Text); foreach (DataRow drType in dtt_packingdet.Rows) { if (drType != null) { T_packingdet objt_packingdet = new T_packingdet(); objt_packingdet.PackingNo = drType["PackingNo"].ToString(); objt_packingdet.Dono = drType["Dono"].ToString(); objt_packingdet.Customer = drType["Customer"].ToString(); objt_packingdet.Agent = drType["Agent"].ToString(); objt_packingdet.datex = DateTime.Parse(drType["datex"].ToString()); objt_packingdet.TTLCartons = decimal.Parse(drType["TTLCartons"].ToString()); retval.Add(objt_packingdet); } } return(retval); } catch (Exception ex) { throw ex; } }
public T_packingdet Selectt_packingdet(T_packingdet objt_packingdet) { try { strquery = @"select * from t_packingdet where PackingNo = '" + objt_packingdet.PackingNo + "'"; DataRow drType = u_DBConnection.ReturnDataRow(strquery); if (drType != null) { objt_packingdet.PackingNo = drType["PackingNo"].ToString(); objt_packingdet.Dono = drType["Dono"].ToString(); objt_packingdet.Customer = drType["Customer"].ToString(); objt_packingdet.Agent = drType["Agent"].ToString(); objt_packingdet.datex = DateTime.Parse(drType["datex"].ToString()); objt_packingdet.TTLCartons = decimal.Parse(drType["TTLCartons"].ToString()); return(objt_packingdet); } return(null); } catch (Exception ex) { throw ex; } }