/// <summary> /// Lay Vung kenh theo ID /// </summary> /// <param name="ID"></param> /// <returns></returns> public DMVung_GPSEntity GetVungKenh(int ID) { DMVung_GPSEntity vungKenh = new DMVung_GPSEntity(); if (g_sqlCon.State == ConnectionState.Closed) { g_sqlCon.Open(); } SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.Int) }; parameters[0].Value = ID; using (SqlDataReader sqldrVungKenh = SqlHelper.ExecuteReader(g_sqlCon, CommandType.StoredProcedure, "V3_DM_VUNG_GPS_GET_BY_ID", parameters)) { if (sqldrVungKenh != null) { vungKenh.KenhVung = Convert.ToInt32(sqldrVungKenh["ID"]); vungKenh.TenVungGPS = sqldrVungKenh["TenVungGPS"].ToString(); vungKenh.KenhVung = Convert.ToInt32(sqldrVungKenh["KenhVung"]); vungKenh.KenhGop = Convert.ToInt32(sqldrVungKenh["KenhGop"]); vungKenh.ToaDoVung = sqldrVungKenh["ToaDoVung"].ToString(); vungKenh.BanKinhTimXe = Convert.ToInt32(sqldrVungKenh["BanKinhTimXe"]); } } // đóng kêt nối db g_sqlCon.Close(); return(vungKenh); }
/// <summary> /// Cap nhat kenh vung /// </summary> /// <param name="DMVung_GPS"></param> /// <returns></returns> public bool Insert(DMVung_GPSEntity DMVung_GPS) { if (g_sqlCon.State == ConnectionState.Closed) { g_sqlCon.Open(); } SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@TenVungGPS", SqlDbType.NVarChar, 50), new SqlParameter("@KenhVung", SqlDbType.Int), new SqlParameter("@KenhGop", SqlDbType.Int), new SqlParameter("@ToaDoVung", SqlDbType.VarChar, 5000), new SqlParameter("@BanKinhTimXe", SqlDbType.Int), new SqlParameter("@Output", SqlDbType.Bit) }; parameters[0].Value = DMVung_GPS.TenVungGPS; parameters[1].Value = DMVung_GPS.KenhVung; parameters[2].Value = DMVung_GPS.KenhGop; parameters[3].Value = DMVung_GPS.ToaDoVung; parameters[4].Value = DMVung_GPS.BanKinhTimXe; parameters[5].Direction = ParameterDirection.Output; SqlHelper.ExecuteNonQuery(g_sqlCon, CommandType.StoredProcedure, "V3_DM_VUNG_GPS_INSERT", parameters); g_sqlCon.Close(); return(Convert.ToBoolean(parameters[5].Value)); }
private void gridVungGPS_Click(object sender, EventArgs e) { if (gridVungGPS.SelectedItems.Count > 0) { isSelectedRow = true; gDMVung_GPSEntity = (DMVung_GPSEntity)((GridEXSelectedItem)gridVungGPS.SelectedItems[0]).GetRow().DataRow; FillDataToForm(); } }
/// <summary> /// Cap nhat kenh vung /// </summary> /// <param name="DMVung_GPS"></param> /// <returns></returns> public bool Insert(DMVung_GPSEntity DMVung_GPS) { return(new Taxi.Data.DM.DMVung_GPS().Insert(DMVung_GPS)); }
/// <summary> /// Cap nhat kenh vung /// </summary> /// <param name="DMVung_GPS"></param> /// <returns></returns> public bool Update(DMVung_GPSEntity DMVung_GPS) { return(new Taxi.Data.DM.DMVung_GPS().Update(DMVung_GPS)); }