public DataTransfer() { m_iResponseCode = RESPONSE_CODE_NONE; m_stResponseErrorMsg = ""; m_stResponseErrorMsgDetail = ""; m_stResponseDataString = ""; m_bResponseDataBool = false; m_dtoResponseDataCustomerDTO = null; m_dtoResponseDataCardDTO = null; m_dtoResponseDataGasStationDTO = null; m_dtoResponseDataRechargeDTO = null; m_dtoResponseDataSaleGasDTO = null; m_dtoResponseDataSystemAdminDTO = null; m_dtoResponseDataGasStoreDTO = null; m_dtoResponseDataGasStoreUpdateDTO = null; m_dsResponseDataSet = null; m_iCurrentPriceGas92 = 0; m_iCurrentPriceGas95 = 0; m_iCurrentPriceGasDO = 0; m_fGasStoreGas92Total = 0; m_fGasStoreGas95Total = 0; m_fGasStoreGasDOTotal = 0; }
public bool AddSystemAdmin(SystemAdminDTO dtoSysAdmin) { bool result = true; string query = string.Format("INSERT INTO SYSTEM_ADMIN (SYS_ADMIN, SYS_PWD, SYS_GAS92_CURRENT_PRICE, SYS_GAS95_CURRENT_PRICE, SYS_GASDO_CURRENT_PRICE, SYS_GAS92_NEW_PRICE, SYS_GAS95_NEW_PRICE, SYS_GASDO_NEW_PRICE, SYS_APPLY_DATE) " + " VALUES (@SYS_ADMIN, @SYS_PWD, @SYS_GAS92_TOTAL, @SYS_GAS95_TOTAL, @SYS_GASDO_TOTAL, @SYS_GAS92_CURRENT_PRICE, @SYS_GAS95_CURRENT_PRICE, @SYS_GASDO_CURRENT_PRICE, @SYS_GAS92_NEW_PRICE, @SYS_GAS95_NEW_PRICE, @SYS_GASDO_NEW_PRICE, @SYS_APPLY_DATE)"); SqlParameter[] sqlParameters = new SqlParameter[9]; sqlParameters[0] = new SqlParameter("@SYS_ADMIN", SqlDbType.NVarChar); sqlParameters[0].Value = Convert.ToString(dtoSysAdmin.SysAdminAccount); sqlParameters[1] = new SqlParameter("@SYS_PWD", SqlDbType.NVarChar); sqlParameters[1].Value = Convert.ToString(dtoSysAdmin.SysAdminPwd); sqlParameters[2] = new SqlParameter("@SYS_GAS92_CURRENT_PRICE", SqlDbType.Int); sqlParameters[2].Value = Convert.ToInt32(dtoSysAdmin.SysGas92CurrentPrice); sqlParameters[3] = new SqlParameter("@SYS_GAS95_CURRENT_PRICE", SqlDbType.Int); sqlParameters[3].Value = Convert.ToInt32(dtoSysAdmin.SysGas95CurrentPrice); sqlParameters[4] = new SqlParameter("@SYS_GASDO_CURRENT_PRICE", SqlDbType.Int); sqlParameters[4].Value = Convert.ToInt32(dtoSysAdmin.SysGasDOCurrentPrice); sqlParameters[5] = new SqlParameter("@SYS_GAS92_NEW_PRICE", SqlDbType.Int); sqlParameters[5].Value = Convert.ToInt32(dtoSysAdmin.SysGas92NewPrice); sqlParameters[6] = new SqlParameter("@SYS_GAS95_NEW_PRICE", SqlDbType.Int); sqlParameters[6].Value = Convert.ToInt32(dtoSysAdmin.SysGas95NewPrice); sqlParameters[7] = new SqlParameter("@SYS_GASDO_NEW_PRICE", SqlDbType.Int); sqlParameters[7].Value = Convert.ToInt32(dtoSysAdmin.SysGasDONewPrice); sqlParameters[8] = new SqlParameter("@SYS_APPLY_DATE", SqlDbType.DateTime); sqlParameters[8].Value = Convert.ToDateTime(dtoSysAdmin.SysApplyDate); result = m_dbConnection.ExecuteInsertQuery(query, sqlParameters); return result; }
public frmSGMSaleGas(SystemAdminDTO adminDTO, GasStationDTO gasStationDTO, int priceGas92, int priceGas95, int priceGasDO, float totalGas92, float totalGas95, float totalGasDO) { InitializeComponent(); _adminDTO = adminDTO; _gasStationDTO = gasStationDTO; m_iCurrentPriceGas92 = priceGas92; m_iCurrentPriceGas95 = priceGas95; m_iCurrentPriceGasDO = priceGasDO; m_iCurrentTotalGas92 = totalGas92; m_iCurrentTotalGas95 = totalGas95; m_iCurrentTotalGasDO = totalGasDO; m_jsHelper = new JSonHelper(); frmMsg = new frmSGMMessage(); frmCardInfo = new frmSGMCardDetail(_cardDTO, _rechargeDTO); lblCurrentPrice.Text = SGMText.SALEGAS_CURRENT_PRICE + SGMText.GAS_92_TEXT + " : " + m_iCurrentPriceGas92 + " , " + SGMText.GAS_95_TEXT + " : "+ m_iCurrentPriceGas95 + " , " + SGMText.GAS_DO_TEXT + " : " + m_iCurrentPriceGasDO; }
public DataTransfer GetCurrentPrice(int iGasType) { DataTransfer dataResult = new DataTransfer(); try { string query = string.Format("SELECT (CAST(SYS_APPLY_DATE AS FLOAT) - CAST(GETDATE() AS FLOAT)) AS RESULT_DATE, * FROM SYSTEM_ADMIN"); DataTable tblResult = m_dbConnection.ExecuteSelectQuery(query, new SqlParameter[0]); if (tblResult.Rows.Count > 0) { double resultDate = Double.Parse(tblResult.Rows[0]["RESULT_DATE"].ToString()); if (resultDate >= 0) { if (iGasType == SystemAdminDTO.GAS_TYPE_92) { dataResult.ResponseDataInt = Int32.Parse(tblResult.Rows[0]["SYS_GAS92_NEW_PRICE"].ToString()); } else if (iGasType == SystemAdminDTO.GAS_TYPE_95) { dataResult.ResponseDataInt = Int32.Parse(tblResult.Rows[0]["SYS_GAS95_NEW_PRICE"].ToString()); } else if (iGasType == SystemAdminDTO.GAS_TYPE_DO) { dataResult.ResponseDataInt = Int32.Parse(tblResult.Rows[0]["SYS_GASDO_NEW_PRICE"].ToString()); } else { dataResult.ResponseCurrentPriceGas92 = Int32.Parse(tblResult.Rows[0]["SYS_GAS92_NEW_PRICE"].ToString()); dataResult.ResponseCurrentPriceGas95 = Int32.Parse(tblResult.Rows[0]["SYS_GAS92_NEW_PRICE"].ToString()); dataResult.ResponseCurrentPriceGasDO = Int32.Parse(tblResult.Rows[0]["SYS_GAS92_NEW_PRICE"].ToString()); } } else { if (iGasType == SystemAdminDTO.GAS_TYPE_92) { dataResult.ResponseDataInt = Int32.Parse(tblResult.Rows[0]["SYS_GAS92_CURRENT_PRICE"].ToString()); } else if (iGasType == SystemAdminDTO.GAS_TYPE_95) { dataResult.ResponseDataInt = Int32.Parse(tblResult.Rows[0]["SYS_GAS95_CURRENT_PRICE"].ToString()); } else if (iGasType == SystemAdminDTO.GAS_TYPE_DO) { dataResult.ResponseDataInt = Int32.Parse(tblResult.Rows[0]["SYS_GASDO_CURRENT_PRICE"].ToString()); } else { dataResult.ResponseCurrentPriceGas92 = Int32.Parse(tblResult.Rows[0]["SYS_GAS92_CURRENT_PRICE"].ToString()); dataResult.ResponseCurrentPriceGas95 = Int32.Parse(tblResult.Rows[0]["SYS_GAS95_CURRENT_PRICE"].ToString()); dataResult.ResponseCurrentPriceGasDO = Int32.Parse(tblResult.Rows[0]["SYS_GASDO_CURRENT_PRICE"].ToString()); } } SystemAdminDTO dtoSysAdmin = new SystemAdminDTO(); dtoSysAdmin.SysAdminAccount = tblResult.Rows[0]["SYS_ADMIN"].ToString(); dtoSysAdmin.SysAdminPwd = tblResult.Rows[0]["SYS_PWD"].ToString(); dtoSysAdmin.SysGas92CurrentPrice = Int32.Parse(tblResult.Rows[0]["SYS_GAS92_CURRENT_PRICE"].ToString()); dtoSysAdmin.SysGas95CurrentPrice = Int32.Parse(tblResult.Rows[0]["SYS_GAS95_CURRENT_PRICE"].ToString()); dtoSysAdmin.SysGasDOCurrentPrice = Int32.Parse(tblResult.Rows[0]["SYS_GASDO_CURRENT_PRICE"].ToString()); dtoSysAdmin.SysGas92NewPrice = Int32.Parse(tblResult.Rows[0]["SYS_GAS92_NEW_PRICE"].ToString()); dtoSysAdmin.SysGas95NewPrice = Int32.Parse(tblResult.Rows[0]["SYS_GAS95_NEW_PRICE"].ToString()); dtoSysAdmin.SysGasDONewPrice = Int32.Parse(tblResult.Rows[0]["SYS_GASDO_NEW_PRICE"].ToString()); dtoSysAdmin.SysApplyDate = DateTime.Parse(tblResult.Rows[0]["SYS_APPLY_DATE"].ToString()); dataResult.ResponseDataSystemAdminDTO = dtoSysAdmin; dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_SUCCESS; } else { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_FAIL; dataResult.ResponseErrorMsg = SGMText.SYS_ADMIN_GET_PRICE_ERR; } } catch (Exception ex) { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_FAIL; dataResult.ResponseErrorMsg = SGMText.SYS_ADMIN_GET_PRICE_ERR; dataResult.ResponseErrorMsgDetail = ex.Message + " : " + ex.StackTrace; } return dataResult; }
public DataTransfer UpdateSystemAdminPrice(SystemAdminDTO dtoSysAdmin) { DataTransfer dataResult = new DataTransfer(); try { string query = string.Format("UPDATE SYSTEM_ADMIN SET SYS_GAS92_CURRENT_PRICE = @SYS_GAS92_CURRENT_PRICE, SYS_GAS95_CURRENT_PRICE = @SYS_GAS95_CURRENT_PRICE, SYS_GASDO_CURRENT_PRICE = @SYS_GASDO_CURRENT_PRICE, " + "SYS_GAS92_NEW_PRICE = @SYS_GAS92_NEW_PRICE, SYS_GAS95_NEW_PRICE = @SYS_GAS95_NEW_PRICE, SYS_GASDO_NEW_PRICE = @SYS_GASDO_NEW_PRICE, SYS_APPLY_DATE = @SYS_APPLY_DATE " + " WHERE SYS_ADMIN = @SYS_ADMIN"); SqlParameter[] sqlParameters = new SqlParameter[8]; sqlParameters[0] = new SqlParameter("@SYS_ADMIN", SqlDbType.NVarChar); sqlParameters[0].Value = Convert.ToString(dtoSysAdmin.SysAdminAccount); sqlParameters[1] = new SqlParameter("@SYS_GAS92_CURRENT_PRICE", SqlDbType.Int); sqlParameters[1].Value = Convert.ToInt32(dtoSysAdmin.SysGas92CurrentPrice); sqlParameters[2] = new SqlParameter("@SYS_GAS95_CURRENT_PRICE", SqlDbType.Int); sqlParameters[2].Value = Convert.ToInt32(dtoSysAdmin.SysGas95CurrentPrice); sqlParameters[3] = new SqlParameter("@SYS_GASDO_CURRENT_PRICE", SqlDbType.Int); sqlParameters[3].Value = Convert.ToInt32(dtoSysAdmin.SysGasDOCurrentPrice); sqlParameters[4] = new SqlParameter("@SYS_GAS92_NEW_PRICE", SqlDbType.Int); sqlParameters[4].Value = Convert.ToInt32(dtoSysAdmin.SysGas92NewPrice); sqlParameters[5] = new SqlParameter("@SYS_GAS95_NEW_PRICE", SqlDbType.Int); sqlParameters[5].Value = Convert.ToInt32(dtoSysAdmin.SysGas95NewPrice); sqlParameters[6] = new SqlParameter("@SYS_GASDO_NEW_PRICE", SqlDbType.Int); sqlParameters[6].Value = Convert.ToInt32(dtoSysAdmin.SysGasDONewPrice); sqlParameters[7] = new SqlParameter("@SYS_APPLY_DATE", SqlDbType.DateTime); sqlParameters[7].Value = Convert.ToDateTime(dtoSysAdmin.SysApplyDate); bool result = m_dbConnection.ExecuteUpdateQuery(query, sqlParameters); if (result) { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_SUCCESS; dataResult.ResponseErrorMsg = SGMText.ADMIN_UPDATE_PRICE_SUCCESS; } else { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_FAIL; dataResult.ResponseErrorMsg = SGMText.ADMIN_UPDATE_PRICE_ERR; } } catch (Exception ex) { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_FAIL; dataResult.ResponseErrorMsg = SGMText.ADMIN_UPDATE_PRICE_ERR; dataResult.ResponseErrorMsgDetail = ex.Message + " : " + ex.StackTrace; } return dataResult; }
//public DataSet GetSystemAdminInfo(string admin, string pwd) //{ // string query = string.Format("SELECT * FROM SYSTEM_ADMIN WHERE SYS_ADMIN = @SYS_ADMIN AND SYS_PWD = @SYS_PWD"); // SqlParameter[] sqlParameters = new SqlParameter[2]; // sqlParameters[0] = new SqlParameter("@SYS_ADMIN", SqlDbType.NVarChar); // sqlParameters[0].Value = Convert.ToString(admin); // sqlParameters[1] = new SqlParameter("@SYS_PWD", SqlDbType.NVarChar); // sqlParameters[1].Value = Convert.ToString(pwd); // DataTable tblResult = m_dbConnection.ExecuteSelectQuery(query, sqlParameters); // if (tblResult.Rows.Count > 0) // { // DataSet ds = new DataSet(); // ds.Tables.Add(tblResult.Copy()); // return ds; // } // return null; //} public SystemAdminDTO GetSystemAdminInfo(string admin, string pwd) { SystemAdminDTO dtoSysAdmin = null; string query = string.Format("SELECT * FROM SYSTEM_ADMIN WHERE SYS_ADMIN = @SYS_ADMIN AND SYS_PWD = @SYS_PWD"); SqlParameter[] sqlParameters = new SqlParameter[2]; sqlParameters[0] = new SqlParameter("@SYS_ADMIN", SqlDbType.NVarChar); sqlParameters[0].Value = Convert.ToString(admin); sqlParameters[1] = new SqlParameter("@SYS_PWD", SqlDbType.NVarChar); sqlParameters[1].Value = Convert.ToString(pwd); DataTable tblResult = m_dbConnection.ExecuteSelectQuery(query, sqlParameters); if (tblResult.Rows.Count > 0) { dtoSysAdmin = new SystemAdminDTO(); foreach (DataRow dr in tblResult.Rows) { dtoSysAdmin.SysAdminAccount = dr["SYS_ADMIN"].ToString(); dtoSysAdmin.SysAdminPwd = dr["SYS_PWD"].ToString(); dtoSysAdmin.SysGas92CurrentPrice = Int32.Parse(dr["SYS_GAS92_CURRENT_PRICE"].ToString()); dtoSysAdmin.SysGas95CurrentPrice = Int32.Parse(dr["SYS_GAS95_CURRENT_PRICE"].ToString()); dtoSysAdmin.SysGasDOCurrentPrice = Int32.Parse(dr["SYS_GASDO_CURRENT_PRICE"].ToString()); dtoSysAdmin.SysGas92NewPrice = Int32.Parse(dr["SYS_GAS92_NEW_PRICE"].ToString()); dtoSysAdmin.SysGas95NewPrice = Int32.Parse(dr["SYS_GAS95_NEW_PRICE"].ToString()); dtoSysAdmin.SysGasDONewPrice = Int32.Parse(dr["SYS_GASDO_NEW_PRICE"].ToString()); dtoSysAdmin.SysApplyDate = DateTime.Parse(dr["SYS_APPLY_DATE"].ToString()); } } return dtoSysAdmin; }