winform中的增删改查

浅浅的花香味﹌ 2022-07-12 18:12 208阅读 0赞

今天写了一个小demo，关于C\#的增删改查，下面就是代码：

1.向数据库中插入数据：

public bool Savedata(T\_PEOPLE people) \{  
try\{  
//向数据库插入数据  
string strSql="";  
strSql = string.Format("insert into T\_PEOPLE(F\_KEY,F\_NAME,F\_SEX,F\_AGE,F\_BIRTHDAY,F\_CARDNO,F\_ADDRESS,F\_FLAG)values('\{0\}','\{1\}','\{2\}','\{3\}','\{4\}','\{5\}','\{6\}','\{7\}')", Guid.NewGuid(), people.F\_NAME, people.F\_SEX, people.F\_AGE, people.F\_BIRTHDAY, people.F\_CARDNO, people.F\_ADDRESS, "0");  
bool bolFlag = m\_DBClass.ExecutSql(strSql);  
return bolFlag;  
\}catch\{throw;\}  
\}  
  
2.删除数据库中的数据：

public bool Dlete(string Id)  
\{  
try  
\{  
//删除数据库一条信息  
string strSql = "";  
strSql = string.Format("delete from T\_PEOPLE where F\_KEY='\{0\}'",Id);  
bool bolFlag = m\_DBClass.ExecutSql(strSql);  
  
return bolFlag;  
\}  
catch \{ throw; \}

3.修改数据库中的数据

public bool Update(T\_PEOPLE people,string id)  
\{  
try  
\{  
//向数据库修改数据  
string strSql = "";  
strSql = string.Format("update T\_PEOPLE set F\_NAME='\{0\}',F\_AGE='\{1\}',F\_SEX='\{2\}',F\_BIRTHDAY='\{3\}',F\_CARDNO='\{4\}',F\_ADDRESS='\{5\}' where F\_KEY='\{6\}'", people.F\_NAME, people.F\_AGE,people.F\_SEX,people.F\_BIRTHDAY,people.F\_CARDNO,people.F\_ADDRESS,id);  
bool bolFlag = m\_DBClass.ExecutSql(strSql);  
return bolFlag;  
\}  
catch \{ throw; \}  
\}

4.查询数据库中的数据

public DataTable getData(List<DataQueryModel> listModel)  
\{  
try  
\{  
string strSql = "select \* from T\_PEOPLE where 1=1";  
if (listModel != null)  
\{  
for (int intI = 0; intI < listModel.Count; intI++)  
\{  
strSql += string.Format(" and \{0\}='\{1\}'", listModel\[intI\].Field, listModel\[intI\].Value);  
\}  
\}  
DataTable dtData = new DataTable();  
dtData = m\_DBClass.QueryGetDataTable(strSql);  
  
return dtData;  
\}  
catch \{ throw; \}  
\}