c# ACCESS/SQL 部分實現代碼

c# ACCESS/SQL 部分實現代碼

//執行更新類,返回影響行數的操作
OleDbConnection oconn1 = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + MainForm.MDbFile);

string Sqlstr = string.Format("update clt_list set type='{0}'  where id='{1}'", Aphonetype, Aphone);

　　　　try
            {
                oconn1.Open();
                OleDbCommand comm1 = new OleDbCommand(Sqlstr, oconn1);
int res = comm1.ExecuteNonQuery();
return res;
            }
catch { return 0; }
finally { oconn1.Close();}

//查詢/讀取類,返回reader(習慣稱記錄集)
if (Acoid == 0 && Alinkmanid == 0)
return new CallType.PhoneInfo();

            CallType.PhoneInfo pPI = new CallType.PhoneInfo();
            List<CallType.PhoneInfo.PhoneList> phoneList1 = new List<CallType.PhoneInfo.PhoneList>();
            CallType.PhoneInfo.PhoneList tmpList = new CallType.PhoneInfo.PhoneList();

            OleDbConnection oconn1 = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + MainForm.MDbFile);
try
            {
                List<CallType.wpLoginInfo> Userlist = new List<CallType.wpLoginInfo>();
string wheretext = "";
                 wheretext = wheretext + " and co_id=" + Acoid.ToString();   
                 wheretext = wheretext + " and clt_id=" + Alinkmanid.ToString(); 

string cmdText = "select autoid, phone_type,phone from clt_phone_list where phone<>'' " + wheretext;
                OleDbCommand odcommand = new OleDbCommand(cmdText, oconn1);
                oconn1.Open();
                OleDbDataReader odReader = odcommand.ExecuteReader();
while (odReader.Read())
                {   CallType.wpLoginInfo tmpUser = new CallType.wpLoginInfo();
if (!odReader.IsDBNull(0)) { tmpList.PhoneId = odReader.GetInt32(0); }
if (!odReader.IsDBNull(1)) { tmpList.PhoneType = odReader.GetString(1); }
if (!odReader.IsDBNull(2)) { tmpList.PhoneNum  = odReader.GetString(2); }
                    phoneList1.Add(tmpList);
                }
                odReader.Close();
                pPI.Phone = phoneList1;
return pPI ;
            }
catch (Exception)
            {
return pPI;
            }
finally
            {
                oconn1.Close();
            }