public T_OpenStkHead Selectt_OpenStkHead(T_OpenStkHead objt_OpenStkHead) { try { strquery = @"select * from t_OpenStkHead where Docno = '" + objt_OpenStkHead.Docno + "'"; DataRow drType = u_DBConnection.ReturnDataRow(strquery); if (drType != null) { objt_OpenStkHead.Docno = drType["Docno"].ToString(); objt_OpenStkHead.locationId = drType["locationId"].ToString(); objt_OpenStkHead.date = DateTime.Parse(drType["date"].ToString()); objt_OpenStkHead.supplier = drType["supplier"].ToString(); objt_OpenStkHead.remarks = drType["remarks"].ToString(); objt_OpenStkHead.grossAmount = decimal.Parse(drType["grossAmount"].ToString()); objt_OpenStkHead.netAmount = decimal.Parse(drType["netAmount"].ToString()); objt_OpenStkHead.isSaved = bool.Parse(drType["isSaved"].ToString()); objt_OpenStkHead.isProcessed = bool.Parse(drType["isProcessed"].ToString()); objt_OpenStkHead.processDate = DateTime.Parse(drType["processDate"].ToString()); objt_OpenStkHead.processUser = drType["processUser"].ToString(); objt_OpenStkHead.GLUpdate = bool.Parse(drType["GLUpdate"].ToString()); objt_OpenStkHead.triggerVal = int.Parse(drType["triggerVal"].ToString()); return(objt_OpenStkHead); } return(null); } catch (Exception ex) { throw ex; } }
/// <summary> /// Saves a record to the T_OpenStkHead table. /// </summary> public Boolean Savet_OpenStkHeadSP(T_OpenStkHead t_OpenStkHead, int formMode) { SqlCommand scom; bool retvalue = false; try { scom = new SqlCommand(); scom.CommandType = CommandType.StoredProcedure; scom.CommandText = "T_OpenStkHeadSave"; scom.Parameters.Add("@Docno", SqlDbType.VarChar, 10).Value = t_OpenStkHead.Docno; scom.Parameters.Add("@locationId", SqlDbType.VarChar, 10).Value = t_OpenStkHead.locationId; scom.Parameters.Add("@date", SqlDbType.DateTime, 8).Value = t_OpenStkHead.date; scom.Parameters.Add("@supplier", SqlDbType.VarChar, 20).Value = t_OpenStkHead.supplier; scom.Parameters.Add("@remarks", SqlDbType.VarChar, 50).Value = t_OpenStkHead.remarks; scom.Parameters.Add("@grossAmount", SqlDbType.Decimal, 9).Value = t_OpenStkHead.grossAmount; scom.Parameters.Add("@netAmount", SqlDbType.Decimal, 9).Value = t_OpenStkHead.netAmount; scom.Parameters.Add("@isSaved", SqlDbType.Bit, 1).Value = t_OpenStkHead.isSaved; scom.Parameters.Add("@isProcessed", SqlDbType.Bit, 1).Value = t_OpenStkHead.isProcessed; scom.Parameters.Add("@processDate", SqlDbType.DateTime, 8).Value = t_OpenStkHead.processDate; scom.Parameters.Add("@processUser", SqlDbType.VarChar, 30).Value = t_OpenStkHead.processUser; scom.Parameters.Add("@GLUpdate", SqlDbType.Bit, 1).Value = t_OpenStkHead.GLUpdate; scom.Parameters.Add("@triggerVal", SqlDbType.Int, 4).Value = t_OpenStkHead.triggerVal; 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_OpenStkHead> SelectT_OpenStkHeadMulti(T_OpenStkHead objt_OpenStkHead2) { List <T_OpenStkHead> retval = new List <T_OpenStkHead>(); try { strquery = @"select * from t_OpenStkHead where Docno = '" + objt_OpenStkHead2.Docno + "'"; DataTable dtt_OpenStkHead = u_DBConnection.ReturnDataTable(strquery, CommandType.Text); foreach (DataRow drType in dtt_OpenStkHead.Rows) { if (drType != null) { T_OpenStkHead objt_OpenStkHead = new T_OpenStkHead(); objt_OpenStkHead.Docno = drType["Docno"].ToString(); objt_OpenStkHead.locationId = drType["locationId"].ToString(); objt_OpenStkHead.date = DateTime.Parse(drType["date"].ToString()); objt_OpenStkHead.supplier = drType["supplier"].ToString(); objt_OpenStkHead.remarks = drType["remarks"].ToString(); objt_OpenStkHead.grossAmount = decimal.Parse(drType["grossAmount"].ToString()); objt_OpenStkHead.netAmount = decimal.Parse(drType["netAmount"].ToString()); objt_OpenStkHead.isSaved = bool.Parse(drType["isSaved"].ToString()); objt_OpenStkHead.isProcessed = bool.Parse(drType["isProcessed"].ToString()); objt_OpenStkHead.processDate = DateTime.Parse(drType["processDate"].ToString()); objt_OpenStkHead.processUser = drType["processUser"].ToString(); objt_OpenStkHead.GLUpdate = bool.Parse(drType["GLUpdate"].ToString()); objt_OpenStkHead.triggerVal = int.Parse(drType["triggerVal"].ToString()); retval.Add(objt_OpenStkHead); } } return(retval); } catch (Exception ex) { throw ex; } }