Example #1
0
 private void Update_Spouse(xing xd, ic.memberC mem_obj)
 {
     ic.spouseC objSpouse = mem_obj.objSpouse;
     string[]   tb_col    = null;
     object[]   _row      = null;
     tb_col = new string[]
     {
         "mem_id",
         "spouse_id",
         "spouse_name",
         "phone_no",
         "marriage_year",
         "marriage_date",
         "marriage_fs_id",
         "couple_id",
         "pastor_name",
         "church_name",
         "church_id", "un_id"
     };
     _row = new object[]
     {
         objSpouse.mem_id,
         objSpouse.spouse_id,
         objSpouse.spouse_name,
         objSpouse.phone_no,
         objSpouse.marriage_year,
         objSpouse.marriage_date,
         objSpouse.marriage_fs_id,
         objSpouse.couple_id,
         objSpouse.pastor,
         objSpouse.church,
         0, objSpouse.un_id
     };
     xd.SingleUpdateCommandALL("ng_spouse_tb", tb_col, _row, 1);
 }
Example #2
0
        public void Save_spouse(xing xd, ic.memberC mem_obj)
        {
            ic.spouseC objSpouse = mem_obj.objSpouse;

            string[] tb_col = null;
            object[] _row   = null;
            tb_col = new string[]
            {
                "mem_id",
                "spouse_id",
                "spouse_name",
                "phone_no",
                "marriage_year",
                "marriage_date",
                "marriage_fs_id",
                "couple_id",
                "exp_type",
                "pastor_name",
                "pastor_id",
                "church_name",
                "church_id",
                "lch_id",
                "lch_type_id",
                "fs_time_stamp"
            };
            _row = new object[]
            {
                objSpouse.mem_id,
                objSpouse.spouse_id,
                objSpouse.spouse_name,
                objSpouse.phone_no,
                objSpouse.marriage_year,
                objSpouse.marriage_date,
                objSpouse.marriage_fs_id,
                objSpouse.couple_id,
                emm.export_type.insert.ToByte(),
                objSpouse.pastor,
                0,
                objSpouse.church,
                0,
                datam.LCH_ID,
                datam.LCH_TYPE_ID,
                0//fs_time_stamp
            };
            objSpouse.un_id = xd.SingleInsertCommandTSPInt("ng_spouse_tb", tb_col, _row);
        }