C# (CSharp) RMS.COMMON.MASTER.RMS_KOTA示例

示例#1

        void LOAD_DATAAREA(RMS.COMMON.MASTER.RMS_KOTA obj)
        {
            DataTable dt = b.SEARCH_BYKODEAREA(obj);

            if (dt.Rows.Count > 0)
            {
                c.IDAREA     = int.Parse(dt.Rows[0]["IDAREA"].ToString());
                txtKODE.Text = dt.Rows[0]["KODEAREA"].ToString();
                txtNAMA.Text = dt.Rows[0]["NAMAAREA"].ToString();
            }
        }

示例#2

        public FormAREA(MASTER.FormKOTA _frm, int Type, RMS.COMMON.MASTER.RMS_KOTA obj)
        {
            InitializeComponent();
            this.frm  = _frm;
            this.Type = Type;

            if (Type == 1)
            {
                LOAD_DATA(obj);
            }
        }

示例#3

        void LOAD_DATAKOTA(RMS.COMMON.MASTER.RMS_KOTA obj)
        {
            DataTable dt = b.CARI_BYIDKOTA(obj);

            if (dt.Rows.Count > 0)
            {
                c.IDKOTA     = int.Parse(dt.Rows[0]["IDKOTA"].ToString());
                txtKODE.Text = dt.Rows[0]["KODEKOTA"].ToString();
                txtNAMA.Text = dt.Rows[0]["NAMAKOTA"].ToString();
            }
        }

示例#4

 public void GET_DATA_KOTA(RMS.COMMON.MASTER.RMS_KOTA obj, string _namaField)
 {
     if (_namaField == "ORIGIN")
     {
         txtKODEASAL.Text = obj.KODEKOTA;
         txtASAL.Text     = obj.NAMAKOTA;
         c.IDKOTAASAL     = obj.IDKOTA;
     }
     else
     {
         txtKODETUJUAN.Text = obj.KODEKOTA;
         txtTUJUAN.Text     = obj.NAMAKOTA;
         c.IDKOTATUJUAN     = obj.IDKOTA;
     }
 }

示例#5

        public FormTERUSAN(MASTER.FormKOTA _frm, int Type, RMS.COMMON.MASTER.RMS_KOTA obj)
        {
            InitializeComponent();
            this.frm  = _frm;
            this.Type = Type;

            if (Type == 0)
            {
                LOAD_DATAKOTA(obj);
            }
            else
            {
                LOAD_DATAKOTA(obj);
                //LOAD_DATAKOTA(obj);
            }
        }

示例#6

 public void DELETE(RMS.COMMON.MASTER.RMS_KOTA obj)
 {
     try
     {
         using (Database db = new Database())
         {
             DataTable dt = new DataTable();
             db.Commands.Add(db.CreateCommand(QUERY_DELETE));
             // db.Commands[0].Parameters.Add(new Parameter("@KODESALES", MySqlDbType.VarChar, obj.KODE));
             dt = db.Commands[0].ExecuteDataTable();
         }
     }
     catch (Exception ex)
     {
         throw new Exception(ex.Message);
     }
 }

示例#7

        public DataTable GET_TERUSANBYID(RMS.COMMON.MASTER.RMS_KOTA obj)
        {
            DataTable dt = new DataTable();

            try
            {
                using (Database db = new Database())
                {
                    db.Commands.Add(db.CreateCommand(QUERY_GETTERUSAN_BYID));
                    db.Commands[0].Parameters.Add(new Parameter("@IDKOTA", MySqlDbType.VarChar, obj.IDKOTA));
                    dt = db.Commands[0].ExecuteDataTable();
                }
                return(dt);
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

示例#8

        // UNTUK PENCARIAN AREA BY NAMA
        public DataTable SEARCH_BYNAMAAREA(RMS.COMMON.MASTER.RMS_KOTA obj)
        {
            DataTable dt = new DataTable();

            try
            {
                using (Database db = new Database())
                {
                    db.Commands.Add(db.CreateCommand(QUERY_SEARCH_BYNAMEAREA));
                    db.Commands[0].Parameters.Add(new Parameter("@NAMAAREA", MySqlDbType.VarChar, obj.NAMAAREA));
                    dt = db.Commands[0].ExecuteDataTable();
                }
                return(dt);
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

示例#9

        public void INSERTTERUSAN(RMS.COMMON.MASTER.RMS_KOTA obj)
        {
            try
            {
                using (Database db = new Database())
                {
                    DataTable dt = new DataTable();
                    db.Commands.Add(db.CreateCommand(QUERY_INSERTTERUSAN));
                    db.Commands[0].Parameters.Add(new Parameter("@IDKOTA", MySqlDbType.Int32, obj.IDKOTA));
                    db.Commands[0].Parameters.Add(new Parameter("@NAMATERUSAN", MySqlDbType.VarChar, obj.NAMATERUSAN));


                    dt = db.Commands[0].ExecuteDataTable();
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

示例#10

 public DataTable SEARCH_BYKODE(RMS.COMMON.MASTER.RMS_KOTA obj)
 {
     return(p.SEARCH_BYKODE(obj));
 }

示例#11

 public DataTable GETKOTA(RMS.COMMON.MASTER.RMS_KOTA obj)
 {
     return(p.GETKOTA(obj));
 }

示例#12

 public void INSERTKOTA(RMS.COMMON.MASTER.RMS_KOTA obj)
 {
     p.INSERTKOTA(obj);
 }

示例#13

 public DataTable SEARCH_BYNAMAAREAKOTA(RMS.COMMON.MASTER.RMS_KOTA obj)
 {
     return(p.SEARCH_BYNAMAAREAKOTA(obj));
 }

示例#14

 public void UPDATEKOTA(RMS.COMMON.MASTER.RMS_KOTA obj)
 {
     p.UPDATEKOTA(obj);
 }

示例#15

 public void INSERTTERUSAN(RMS.COMMON.MASTER.RMS_KOTA obj)
 {
     p.INSERTTERUSAN(obj);
 }

示例#16

 public DataTable CARI_BYKODEKOTA(RMS.COMMON.MASTER.RMS_KOTA obj)
 {
     return(p.CARI_BYKODEKOTA(obj));
 }

示例#17

 public DataTable GET_TERUSANBYID(RMS.COMMON.MASTER.RMS_KOTA obj)
 {
     return(p.GET_TERUSANBYID(obj));
 }

示例#18

 public DataTable GETTERUSAN_BYNAMA(RMS.COMMON.MASTER.RMS_KOTA obj)
 {
     return(p.GETTERUSAN_BYNAMA(obj));
 }

示例#19

 public void DELETETERUSAN(RMS.COMMON.MASTER.RMS_KOTA obj)
 {
     p.DELETETERUSAN(obj);
 }

示例#20

 public DataTable GETAREA_BYKODE(RMS.COMMON.MASTER.RMS_KOTA obj)
 {
     return(p.GETAREA_BYKODE(obj));
 }