Example #1
0
        internal override void AddEntity(DataPersistance dp, object NewEntity)
        {
            if (!object.ReferenceEquals(dp, this.dp))
            {
                return;
            }

            string strPK = BuildPKWhere(NewEntity);
            string Query = strPK.Length > 0 ? string.Concat(SqlQuery,
                                                            " AND (", strPK, ")") : SqlQuery;

            IDataReader rdr = dp.ExecuteReader(Query);

            try
            {
                if (rdr.Read()) // Kalo PK data baru valid, tambahkan
                {
                    object[] Values = new object[rdr.FieldCount];

                    rdr.GetValues(Values);
                    ((DataTable)wrdt.Target).Rows.Add(Values);
                }
            }
            finally
            {
                rdr.Close();
            }
        }
Example #2
0
        internal override void EditEntity(DataPersistance dp, object OldEntity, object NewEntity)
        {
            if (!object.ReferenceEquals(dp, this.dp))
            {
                return;
            }

            string strPK = BuildPKWhere(NewEntity);
            string Query = strPK.Length > 0 ? string.Concat(SqlQuery,
                                                            " AND (", strPK, ")") : SqlQuery;

            DataTable   dt  = (DataTable)wrdt.Target;
            IDataReader rdr = dp.ExecuteReader(Query);

            try
            {
                if (rdr.Read())     //Kalo PK Data Baru Valid
                {
                    object[] Values = new object[rdr.FieldCount];
                    rdr.GetValues(Values);

                    if (OldEntity == null)  //Data baru tidak ada, tambahkan
                    {
                        dt.Rows.Add(Values);
                    }
                    else
                    {
                        // kalo data lama ada, edit
                        strPK = BuildPKWhere(OldEntity);
                        DataRow[] drs = dt.Select(BuildPKWhere(OldEntity));
                        if (drs.Length > 0)
                        {
                            DataRow dr = drs[0];
                            for (int i = 0; i < Values.Length; i++)
                            {
                                dr[i] = Values[i];
                            }
                        }
                        else  // Data baru tidak ada, tambahkan
                        {
                            dt.Rows.Add(Values);
                        }
                    }
                }
                else   // Data Baru tidak valid
                {
                    // Kalo data lama ada, hapus
                    DataRow[] drs = dt.Select(BuildPKWhere(OldEntity));
                    if (drs.Length > 0)
                    {
                        dt.Rows.Remove(drs[0]);
                    }
                }
            }
            finally
            {
                rdr.Close();
            }
        }
        public bool Read()
        {
            if (rdr == null)
            {
                rdr = Dp.ExecuteReader(SqlSelect, Parameters);
                BuildSetter();
            }
            if (rdr.Read())
            {
                if (ReadOnNewEntity)
                {
                    _Entity = new TEntity();
                }

                for (int i = 0; i < Setter.Length; i++)
                {
                    if (Setter[i] != null)
                    {
                        object obj = rdr.GetValue(i);
                        if (obj == null || obj == DBNull.Value)
                        {
                            obj = GetDefaultValue(rdr.GetFieldType(i));
                        }
                        if (EnumType[i] == null)
                        {
                            Setter[i](_Entity, obj);
                        }
                        else
                        {
                            Setter[i](_Entity, EnumDef.GetEnumValue(
                                          EnumType[i], obj));
                        }
                    }
                }

                return(true);
            }
            return(false);
        }
Example #4
0
        bool IModuleAccessForm.ShowDialog(ModuleAccess ma,
                                          Dictionary <string, List <string> > ListKey,
                                          ref bool AllDocumentData)
        {
            labelControl2.Text = string.Concat(ma.FolderName, "\\",
                                               ma.ModuleName);
            this.ma            = ma;
            _OnLoad            = true;
            checkEdit5.Checked = ma.GetVariable <bool>(
                SecurityVarName.DocumentView, false);
            checkEdit6.Checked = ma.GetVariable <bool>(
                SecurityVarName.ReportView, false);

            checkEdit1.Checked = ma.GetVariable <bool>(
                SecurityVarName.DocumentNew, false);
            checkEdit2.Checked = ma.GetVariable <bool>(
                SecurityVarName.DocumentEdit, false);
            checkEdit3.Checked = ma.GetVariable <bool>(
                SecurityVarName.DocumentDelete, false);
            checkEdit7.Checked = ma.GetVariable <bool>(
                SecurityVarName.DocumentPrint, false);
            checkEdit8.Checked = ma.GetVariable <bool>(
                SecurityVarName.DocumentDesignPrint, false);

            checkEdit12.Checked = ma.GetVariable <bool>(
                SecurityVarName.ReportPrint, false);
            checkEdit11.Checked = ma.GetVariable <bool>(
                SecurityVarName.ReportDesignPrint, false);
            checkEdit10.Checked = ma.GetVariable <bool>(
                SecurityVarName.ReportSave, false);
            checkEdit4.Checked = ma.GetVariable <bool>(
                SecurityVarName.ReportLayoutSave, false);
            _OnLoad = false;

            this.ListKey = ListKey;

            if (ma.ListDataField.Count == 0)
            {
                xtraTabPage2.PageVisible = false;
            }
            else
            {
                DataPersistance dp = BaseSecurity.CurrentLogin.Dp;
                checkEdit14.Checked = AllDocumentData;
                foreach (ModuleDataField mdf in ma.ListDataField)
                {
                    List <Item> ListItem = new List <Item>();
                    ListDataField.Add(mdf.DataFieldName, ListItem);
                    comboBoxEdit1.Properties.Items.Add(mdf.DataFieldName);

                    IDataReader rdr = dp.ExecuteReader(mdf.SqlQuery);
                    while (rdr.Read())
                    {
                        bool   Pilih   = false;
                        string DataKey = (string)rdr[0];
                        foreach (string key in ListKey[mdf.DataFieldName])
                        {
                            if (key == DataKey)
                            {
                                Pilih = true;
                                break;
                            }
                        }
                        ListItem.Add(new Item(Pilih, DataKey));
                    }
                    rdr.Close();
                }
                comboBoxEdit1.SelectedIndex = 0;
            }

            if (ShowDialog(BaseWinFramework.MdiParent) == DialogResult.OK)
            {
                AllDocumentData = this.AllDocumentData;
                return(true);
            }
            else
            {
                return(false);
            }
        }