1
using System;2
using System.Collections.Generic;3
using System.Linq;4
using System.Web;5
using System.Data;6
using System.Data.SqlClient;7
using System.Web.Configuration;8

9

/**//// <summary>10
/// Summary description for FamilyData11
/// </summary>12
public class FamilyData13


{14
private readonly string _conStrings;15
public FamilyData()16

{17
_conStrings = WebConfigurationManager.ConnectionStrings["CNPCEditConnectionStrings"].ConnectionString;18
//19
// TODO: Add constructor logic here20
//21
}22
public class FamilyName23

{24
private int _FamilyID;25
public int FamilyID26

{27

get
{ return _FamilyID; }28
set29

{30
_FamilyID = value;31
}32
}33
private string _FamilyName;34
public string FamilyNamex35

{36

get
{ return _FamilyName; }37
set38

{39
_FamilyName = value;40
}41
}42
private string _FamilyNameCh;43
public string FamilyNameCh44

{45

get
{ return _FamilyNameCh; }46
set47

{48
_FamilyNameCh = value;49
}50
} 51
}52
public List<FamilyName> GetFamilyName()53

{54
List<FamilyName> name = new List<FamilyName>();55
SqlConnection con = new SqlConnection(_conStrings);56
SqlCommand cmd = new SqlCommand(); 57
cmd.CommandText = "Select FamilyID, FamilyName, FamilyNameCh from Family";58
cmd.Connection = con;59
using (con)60

{61
con.Open();62
SqlDataReader sdr = cmd.ExecuteReader();63
while (sdr.Read())64

{65
FamilyName newName = new FamilyName();66
newName.FamilyID = (int)sdr["FamilyID"];67
newName.FamilyNamex = (string)sdr["FamilyName"];68
newName.FamilyNameCh= (string)sdr["FamilyNameCh"];69
name.Add(newName);70
}71
}72
return name; 73
}74
public void UpdateFamily(FamilyName familyToUpdate)75

{76
SqlConnection con = new SqlConnection(_conStrings);77
SqlCommand cmd = new SqlCommand();78
cmd.CommandText = "update Family set FamilyName=@FamilyName, FamilyNameCh=@FamilyNameCh where FamilyID=@FamilyID ";79
cmd.Connection = con;80
cmd.Parameters.AddWithValue("@FamilyID", familyToUpdate.FamilyID);81
cmd.Parameters.AddWithValue("@FamilyName", familyToUpdate.FamilyNamex);82
cmd.Parameters.AddWithValue("@FamilyNameCh", familyToUpdate.FamilyNameCh);83
using (con)84

{85
con.Open();86
cmd.ExecuteNonQuery();87
}88

89
}90
}91


浙公网安备 33010602011771号