Beispiel #1
0
        /* 根据联系人数据库id,编辑一个联系人到数据库,不修改的字段必须将原字段值传给参数,清空字段值使用空字符串。注意不能为null */
        public void EditContact(int contact_id, string user_id, string mobile, string name, string photo,
                                string home_tel, string work_tel, string other_tel, string fax, string person_email, string work_email,
                                string other_email, string home_street, string home_city, string home_province, string work_street,
                                string work_city, string work_province, string other_street, string other_city, string other_province,
                                string qq, string msn, string other_im, string url, DateTime birthday, string org, string title, string note,
                                string ring)
        {
            Contact       contact = GetContact(contact_id);
            SQLiteCommand cmd     = _Connection.CreateCommand("update t_contact set dst_user_id = @user_id, dst_user_mobile = @mobile, " +
                                                              "name = @name, name_spell = @name_spell, photo = @photo where cid = @contact_id;");

            if (string.IsNullOrEmpty(contact["dst_user_id"].ToString()) || contact["dst_user_mobile"].ToString().Equals(mobile))
            {
                cmd.Parameters.Add("@dst_user_id", DbType.String).Value = user_id;
            }
            else
            {
                cmd.Parameters.Add("@dst_user_id", DbType.String).Value = "";
            }

            cmd.Parameters.Add("@dst_user_mobile", DbType.String).Value = mobile;
            cmd.Parameters.Add("@name", DbType.String).Value            = name;
            cmd.Parameters.Add("@name_spell", DbType.String).Value      = Han2Pinyin.Chinese2PY(name);
            cmd.Parameters.Add("@photo", DbType.String).Value           = photo;
            cmd.Parameters.Add("@contact_id", DbType.Int32).Value       = contact_id;
            cmd.ExecuteNonQuery();

            ContactDetail detail = GetContactDetail(contact_id);

            cmd = _Connection.CreateCommand("update t_contact_detail set home_tel = @home_tel, work_tel = @home_tel, " +
                                            "other_tel = @other_tel, fax = @fax, person_email = @person_email, work_email = @work_email, other_email = @other_email, " +
                                            "home_street = @home_street, home_city = @home_city, home_province = @home_province, work_street = @work_street, " +
                                            "work_city = @work_city, work_province @work_province, other_street = @other_street, other_city = @other_city, " +
                                            "other_province = @other_province, qq = @qq, msn = @msn, other_im = @other_im, url = @url, birthday = @birthday, " +
                                            "org = @org, title = @title, note = @note, ring = @ring where cid = @contact_id;");

            cmd.Parameters.Add("@home_tel", DbType.String).Value       = home_tel;
            cmd.Parameters.Add("@work_tel", DbType.String).Value       = work_tel;
            cmd.Parameters.Add("@other_tel", DbType.String).Value      = other_tel;
            cmd.Parameters.Add("@fax", DbType.String).Value            = fax;
            cmd.Parameters.Add("@person_email", DbType.String).Value   = person_email;
            cmd.Parameters.Add("@work_email", DbType.String).Value     = work_email;
            cmd.Parameters.Add("@other_email", DbType.String).Value    = other_email;
            cmd.Parameters.Add("@home_street", DbType.String).Value    = home_street;
            cmd.Parameters.Add("@home_city", DbType.String).Value      = home_city;
            cmd.Parameters.Add("@home_province", DbType.String).Value  = home_province;
            cmd.Parameters.Add("@work_street", DbType.String).Value    = work_street;
            cmd.Parameters.Add("@work_city", DbType.String).Value      = work_city;
            cmd.Parameters.Add("@work_province", DbType.String).Value  = work_province;
            cmd.Parameters.Add("@other_street", DbType.String).Value   = other_street;
            cmd.Parameters.Add("@other_city", DbType.String).Value     = other_city;
            cmd.Parameters.Add("@other_province", DbType.String).Value = other_province;
            cmd.Parameters.Add("@qq", DbType.String).Value             = qq;
            cmd.Parameters.Add("@msn", DbType.String).Value            = msn;
            cmd.Parameters.Add("@other_im", DbType.String).Value       = other_im;
            cmd.Parameters.Add("@url", DbType.String).Value            = url;
            cmd.Parameters.Add("@birthday", DbType.DateTime).Value     = birthday;
            cmd.Parameters.Add("@org", DbType.String).Value            = org;
            cmd.Parameters.Add("@title", DbType.String).Value          = title;
            cmd.Parameters.Add("@note", DbType.String).Value           = note;
            cmd.Parameters.Add("@ring", DbType.String).Value           = ring;
            cmd.Parameters.Add("@contact_id", DbType.Int32).Value      = contact_id;
            cmd.ExecuteNonQuery();
        }
Beispiel #2
0
        /* ��ȡ��ϵ����ϸ��Ϣ��������ϵ�����ݿ�Id */
        public ContactDetail GetContactDetail(int contactId)
        {
            SQLiteCommand cmd = _Connection.CreateCommand("select * from t_contact_detail where cid = @contactId;");
            cmd.Parameters.Add("@contactId", DbType.Int32).Value = contactId;
            SQLiteDataReader reader = cmd.ExecuteReader();

            ContactDetail contactdetail = new ContactDetail(reader);
            return contactdetail;
        }