public int UpdateStage_Type(Stage_TypeEntity t_Stage_Type) { SqlParameter[] p=new SqlParameter[]{ new SqlParameter("@Stage_type_id",t_Stage_Type.Stage_type_id), new SqlParameter("@Stage_type_name",t_Stage_Type.Stage_type_name) }; int i=SqlDBHelp.GetExecute("update Stage_Type set stage_type_id=@Stage_type_id,stage_type_name=@Stage_type_name where stage_type_id=@Stage_type_id", p) ; return i; }
//根据外键进行查询 //插入操作 public int InsertStage_Type(Stage_TypeEntity t_Stage_Type) { //定义插入数据的参数数组 SqlParameter[] p=new SqlParameter[]{ new SqlParameter("@Stage_type_id",t_Stage_Type.Stage_type_id), new SqlParameter("@Stage_type_name",t_Stage_Type.Stage_type_name) }; int i=SqlDBHelp.GetExecute("insert into Stage_Type values (@Stage_type_id,@Stage_type_name)", p) ; return i; }
//根据外键进行查询 //插入操作 public static int InsertStage_Type(Stage_TypeEntity t_Stage_Type) { int i=-1; //定义插入数据的参数数组 try { i=dal.InsertStage_Type(t_Stage_Type); } catch(Exception ex) { throw new Exception(ex.Message); } return i; }
public Stage_TypeEntity SelectStage_TypeByID(int t_stage_type_id) { Stage_TypeEntity t_Stage_Type= new Stage_TypeEntity(); SqlDataReader sdr=null; using(sdr=SqlDBHelp.GetReader("select * from Stage_Type where stage_type_id="+t_stage_type_id)) { if(sdr.Read()) { t_Stage_Type.Stage_type_id=(int)sdr.GetValue(0); t_Stage_Type.Stage_type_name=(string)sdr.GetValue(1); } } sdr.Close(); return t_Stage_Type; }
//根据主键查询整个表 public IList<Stage_TypeEntity> GetAllStage_Type() { IList<Stage_TypeEntity> t_Stage_Types = new List<Stage_TypeEntity>(); SqlDataReader sdr = null; using(sdr=SqlDBHelp.GetReader("select * from Stage_Type")) { while(sdr.Read()) { Stage_TypeEntity t_Stage_Type= new Stage_TypeEntity(); t_Stage_Type.Stage_type_id=(int)sdr.GetValue(0); t_Stage_Type.Stage_type_name=(string)sdr.GetValue(1); t_Stage_Types.Add(t_Stage_Type); } sdr.Close(); } return t_Stage_Types; }