/// <summary> /// Get Dip Input values /// </summary> /// <returns>List of dip input</returns> public List <DipInput> GetDipInputValues() { List <DipInput> dipInputs = new List <DipInput>(); var strDate = DateAndTime.Year(DateAndTime.Today) + Strings.Right("00" + CommonUtility.GetStringValue(DateAndTime.Month(DateAndTime.Today)), 2) + Strings.Right("00" + CommonUtility.GetStringValue(DateAndTime.Day(DateAndTime.Today)), 2); var strSql = "select A.ID, A.GradeID, B.FullName from TankInfo as A INNER JOIN Grade as B ON A.GradeID=B.ID where B.FuelType=\'G\'"; var dt = GetRecords(strSql, DataSource.CSCPump); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { DipInput input = new DipInput { TankId = CommonUtility.GetStringValue(dr["ID"]), Grade = CommonUtility.GetStringValue(dr["FullName"]), GradeId = CommonUtility.GetStringValue(dr["GradeID"]) }; string query = "select * from DipInput where TankID=" + CommonUtility.GetStringValue(dr["ID"]) + " and CONVERT(char(8), DipDate, 112)=\'" + strDate + "\'"; var rsDip = GetRecords(query, DataSource.CSCTrans); if (rsDip == null || rsDip.Rows.Count == 0) { input.DipValue = ""; } else { input.DipValue = CommonUtility.GetStringValue(rsDip.Rows[0]["DipValue"]); } dipInputs.Add(input); } } return(dipInputs); }
/// <summary> /// Get Dip Inputs for Report /// </summary> /// <returns>List of dip inputs</returns> public List <DipInput> GetDipInputsForReport(string strDate) { List <DipInput> dipInputs = new List <DipInput>(); var dt = GetRecords("select * from DipInput where CONVERT(char(8), DipDate, 112)=\'" + strDate + "\'", DataSource.CSCTrans); foreach (DataRow dr in dt.Rows) { DipInput input = new DipInput { TankId = CommonUtility.GetStringValue(dr["TankID"]), Grade = CommonUtility.GetStringValue(dr["Grade"]), DipValue = CommonUtility.GetStringValue(dr["DipValue"]) }; dipInputs.Add(input); } return(dipInputs); }