コード例 #1
0
        /// <summary>
        /// Saves a record to the core_ledger_account table.
        /// </summary>
        public void Insert(core_ledger_account_Objects objCls)
        {
            MySqlConnection scon = Connectivity.Cls_Connection.getConnection();
            MySqlCommand scom = new MySqlCommand("core_ledger_accountInsert", scon);
            scom.CommandType = CommandType.StoredProcedure;

            scom.Parameters.Add("COL_Id_Ledger_Account", MySqlDbType.Int32,0);
            scom.Parameters.Add("COL_Ledger_Account_Name", MySqlDbType.VarChar,45);
            scom.Parameters.Add("COL_Balance_Carried_Forward", MySqlDbType.Double,0);
            scom.Parameters.Add("COL_Created_Date", MySqlDbType.DateTime,0);
            scom.Parameters.Add("COL_Created_User", MySqlDbType.Int32,0);
            scom.Parameters.Add("COL_Edited_Date", MySqlDbType.DateTime,0);
            scom.Parameters.Add("COL_Edited_User", MySqlDbType.Int32,0);
            scom.Parameters.Add("COL_Is_Active", MySqlDbType.Bit,0);

            scom.Parameters["COL_Id_Ledger_Account"].Value = objCls.Id_Ledger_Account;
            scom.Parameters["COL_Ledger_Account_Name"].Value = objCls.Ledger_Account_Name;
            scom.Parameters["COL_Balance_Carried_Forward"].Value = objCls.Balance_Carried_Forward;
            scom.Parameters["COL_Created_Date"].Value = objCls.Created_Date;
            scom.Parameters["COL_Created_User"].Value = objCls.Created_User;
            scom.Parameters["COL_Edited_Date"].Value = objCls.Edited_Date;
            scom.Parameters["COL_Edited_User"].Value = objCls.Edited_User;
            scom.Parameters["COL_Is_Active"].Value = objCls.Is_Active;

            scon.Open();
            scom.ExecuteNonQuery();
            scon.Close();
        }
コード例 #2
0
        /// <summary>
        /// Saves a record to the core_ledger_account table.
        /// </summary>
        public void Insert(core_ledger_account_Objects objCls)
        {
            MySqlConnection scon = Connectivity.Cls_Connection.getConnection();
            MySqlCommand    scom = new MySqlCommand("core_ledger_accountInsert", scon);

            scom.CommandType = CommandType.StoredProcedure;


            scom.Parameters.Add("COL_Id_Ledger_Account", MySqlDbType.Int32, 0);
            scom.Parameters.Add("COL_Ledger_Account_Name", MySqlDbType.VarChar, 45);
            scom.Parameters.Add("COL_Balance_Carried_Forward", MySqlDbType.Double, 0);
            scom.Parameters.Add("COL_Created_Date", MySqlDbType.DateTime, 0);
            scom.Parameters.Add("COL_Created_User", MySqlDbType.Int32, 0);
            scom.Parameters.Add("COL_Edited_Date", MySqlDbType.DateTime, 0);
            scom.Parameters.Add("COL_Edited_User", MySqlDbType.Int32, 0);
            scom.Parameters.Add("COL_Is_Active", MySqlDbType.Bit, 0);

            scom.Parameters["COL_Id_Ledger_Account"].Value       = objCls.Id_Ledger_Account;
            scom.Parameters["COL_Ledger_Account_Name"].Value     = objCls.Ledger_Account_Name;
            scom.Parameters["COL_Balance_Carried_Forward"].Value = objCls.Balance_Carried_Forward;
            scom.Parameters["COL_Created_Date"].Value            = objCls.Created_Date;
            scom.Parameters["COL_Created_User"].Value            = objCls.Created_User;
            scom.Parameters["COL_Edited_Date"].Value             = objCls.Edited_Date;
            scom.Parameters["COL_Edited_User"].Value             = objCls.Edited_User;
            scom.Parameters["COL_Is_Active"].Value = objCls.Is_Active;


            scon.Open();
            scom.ExecuteNonQuery();
            scon.Close();
        }