コード例 #1
0
ファイル: syncController.cs プロジェクト: pkurowsk/NI-FAFOS
 public syncController(int UserId)
 {
     FranchiseeID = _users.getFranchiseeId(UserId.ToString());
     String connString = Properties.Settings.Default.FAFOS;
     SqlConnection con = new SqlConnection(connString);
     con.Open();
     SqlCommand Franchisee_command = new SqlCommand("SELECT franchisee_id, company_name FROM Franchisee WHERE franchisee_id = " + FranchiseeID, con);
     SqlDataReader reader = Franchisee_command.ExecuteReader();
     reader.Read();
     String[] Franchisee_data = new String[2] { reader[0].ToString(), reader[1].ToString() };
     XML = new InspectionData(Franchisee_data);
 }
コード例 #2
0
ファイル: syncController.cs プロジェクト: pkurowsk/NI-FAFOS
        public syncController(int UserId)
        {
            FranchiseeID = _users.getFranchiseeId(UserId.ToString());
            String        connString = Properties.Settings.Default.FAFOS;
            SqlConnection con        = new SqlConnection(connString);

            con.Open();
            SqlCommand    Franchisee_command = new SqlCommand("SELECT franchisee_id, company_name FROM Franchisee WHERE franchisee_id = " + FranchiseeID, con);
            SqlDataReader reader             = Franchisee_command.ExecuteReader();

            reader.Read();
            String[] Franchisee_data = new String[2] {
                reader[0].ToString(), reader[1].ToString()
            };
            XML = new InspectionData(Franchisee_data);
        }