public COURSETIME_OBJ GetByID(COURSETIME_OBJ.BusinessObjectID id) { List <COURSETIME_OBJ> li = getAll(new spParam("CODE", SqlDbType.VarChar, id.CODE, 0)); if (li == null || li.Count == 0) { return(null); } return(li[0]); }
//public int Update(COURSETIME_OBJ obj) //{ // int ret = 0; // DBBase db = new DBBase(ConfigurationSettings.AppSettings["connectionString"].ToString()); // string sql = @"UPDATE COURSETIME SET // code=@code, // ,timestart=@timestart // ,timeend=@timeend // ,dayinweek=@dayinweek // ,codeview=@codeview // WHERE code=@code_key // "; // SqlCommand com = new SqlCommand(); // com.CommandText = sql; // com.CommandType = CommandType.Text; // com.Parameters.Add("@code", SqlDbType.VarChar).Value = obj.CODE; // com.Parameters.Add("@timestart", SqlDbType.VarChar).Value = obj.TIMESTART; // com.Parameters.Add("@timeend", SqlDbType.VarChar).Value = obj.TIMEEND; // com.Parameters.Add("@dayinweek", SqlDbType.VarChar).Value = obj.DAYINWEEK; // com.Parameters.Add("@codeview", SqlDbType.VarChar).Value = obj.CODEVIEW; // com.Parameters.Add("@code_key", SqlDbType.VarChar).Value = obj._ID.CODE; // ret = db.doCommand(ref com); // return ret; //} public int Delete(COURSETIME_OBJ.BusinessObjectID obj) { int ret = 0; DBBase db = new DBBase(ConfigurationSettings.AppSettings["connectionString"].ToString()); string sql = @"DELETE FROM COURSETIME WHERE code=@code_key"; SqlCommand com = new SqlCommand(); com.CommandText = sql; com.CommandType = CommandType.Text; com.Parameters.Add("@code_key", SqlDbType.VarChar).Value = obj.CODE; ret = db.doCommand(ref com); return(ret); }