/// <summary> /// Xóa một khoa /// Cập nhật lại mã khoa ở bộ môn liên quan /// </summary> /// <param name="id"></param> /// <returns></returns> public int DeleteFaculty(string codeview) { int ret = 0; string sql = "DeleteFaculty '" + codeview + "'"; SqlCommand cm = new SqlCommand(); cm.CommandText = sql; cm.CommandType = CommandType.Text; ret = db.doCommand(ref cm); return(ret); }
public int Update(NATION_OBJ obj) { int ret = 0; DBBase db = new DBBase(ConfigurationSettings.AppSettings["connectionString"].ToString()); string sql = @"UPDATE NATION SET code=@code ,codeview=@codeview , name=@name , note=@note , edituser=@edituser ,edittime=@edittime ,lock=@lock , lockdate=@lockdate 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("@codeview", SqlDbType.VarChar).Value = obj.CODEVIEW; com.Parameters.Add("@name", SqlDbType.NVarChar).Value = obj.NAME; com.Parameters.Add("@note", SqlDbType.NVarChar).Value = obj.NOTE; com.Parameters.Add("@edituser", SqlDbType.VarChar).Value = obj.EDITUSER; com.Parameters.Add("@edittime", SqlDbType.DateTime).Value = obj.EDITTIME; com.Parameters.Add("@lock", SqlDbType.Int).Value = obj.LOCK; com.Parameters.Add("@lockdate", SqlDbType.DateTime).Value = obj.LOCKDATE; com.Parameters.Add("@code_key", SqlDbType.VarChar).Value = obj._ID.CODE; ret = db.doCommand(ref com); return(ret); }
public int Update(DETAILEDREGISTRATION_OBJ obj) { int ret = 0; DBBase db = new DBBase(ConfigurationSettings.AppSettings["connectionString"].ToString()); string sql = @"UPDATE detailedregistration SET code=@code ,subjectcode=@subjectcode , studentcode=@studentcode , usedcredit=@usedcredit , registrationdate=@registrationdate ,educationprogramcode=@educationprogramcode ,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("@codeview", SqlDbType.VarChar).Value = obj.CODEVIEW; com.Parameters.Add("@subjectcode", SqlDbType.VarChar).Value = obj.SUBJECTCODE; com.Parameters.Add("@studentcode", SqlDbType.NVarChar).Value = obj.STUDENTCODE; com.Parameters.Add("@usedcredit", SqlDbType.Int).Value = obj.USEDCREDIT; com.Parameters.Add("@registrationdate", SqlDbType.DateTime).Value = obj.REGISTRATIONDATE; com.Parameters.Add("@educationprogramcode", SqlDbType.DateTime).Value = obj.EDUCATIONPROGRAMCODE; ret = db.doCommand(ref com); return(ret); }
public int Insert(MENU_OBJ obj) { int ret = 0; string sql = "INSERT INTO AU_MENU(ID , MENUID, MENUIDCHA , TITLE , URL , SORT , TRANGTHAI , I_CREATE_DATE) VALUES(@id,@menuid, @menuidcha, @title, @url,@sort,@trangthai,@create_Date)"; SqlCommand com = new SqlCommand(); com.CommandText = sql; com.CommandType = CommandType.Text; com.Parameters.Add("@id", SqlDbType.VarChar).Value = obj.ID; com.Parameters.Add("@menuid", SqlDbType.VarChar).Value = obj.MenuId; com.Parameters.Add("@menuidcha", SqlDbType.VarChar).Value = obj.MenuIdCha; com.Parameters.Add("@title", SqlDbType.NVarChar).Value = obj.Title; com.Parameters.Add("@url", SqlDbType.NVarChar).Value = obj.Url; com.Parameters.Add("@trangthai", SqlDbType.Int).Value = obj.TrangThai; com.Parameters.Add("@sort", SqlDbType.Int).Value = obj.Sort; com.Parameters.Add("@create_Date", SqlDbType.DateTime).Value = DateTime.Now; ret = db.doCommand(ref com); return(ret); }
//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); }
public int Insert(graduatestudent_OBJ obj) { int ret = 0; DBBase db = new DBBase(ConfigurationSettings.AppSettings["connectionString"].ToString()); string sql = "INSERT INTO graduatestudent(studentcode,graduationperiodcode) VALUES(@studentcode,@graduationperiodcode)"; SqlCommand com = new SqlCommand(); com.CommandText = sql; com.CommandType = CommandType.Text; com.Parameters.Add("@studentcode", SqlDbType.VarChar).Value = obj.studentcode; com.Parameters.Add("@graduationperiodcode", SqlDbType.VarChar).Value = obj.graduationperiodcode; ret = db.doCommand(ref com); return(ret); }
public int Insert(COURSETIME_OBJ obj) { int ret = 0; DBBase db = new DBBase(ConfigurationSettings.AppSettings["connectionString"].ToString()); string sql = "exec addcoursetime @start=@timestart @end=@timeend @day=@dayinweek"; SqlCommand com = new SqlCommand(); com.CommandText = sql; com.CommandType = CommandType.Text; 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; ret = db.doCommand(ref com); return(ret); }
//public string genNextCode(ROOM_OBJ obj) //{ // //Phải viết lại theo mô hình nào đó // Random rnd = new Random(); // int i = rnd.Next(int.MaxValue); // return (i % 10000000000).ToString(); //} public int Insert(ROOM_OBJ obj) { int ret = 0; DBBase db = new DBBase(ConfigurationSettings.AppSettings["connectionString"].ToString()); string sql = "INSERT INTO ROOM(code, numberfloor,codeview,buildingcode) VALUES(@code,@numberfloor,@codeview,@buildingcode)"; SqlCommand com = new SqlCommand(); com.CommandText = sql; com.CommandType = CommandType.Text; com.Parameters.Add("@code", SqlDbType.VarChar).Value = obj.CODE; com.Parameters.Add("@numberfloor", SqlDbType.VarChar).Value = obj.NUMBERFLOOR; com.Parameters.Add("@codeview", SqlDbType.VarChar).Value = obj.CODEVIEW; com.Parameters.Add("@buildingcode", SqlDbType.VarChar).Value = obj.BUILDINGCODE; ret = db.doCommand(ref com); return(ret); }
public int Insert(MAJOR_OBJ obj) { int ret = 0; DBBase db = new DBBase(ConfigurationSettings.AppSettings["connectionString"].ToString()); string sql = "INSERT INTO MAJOR(code,codeview,name,facilitycode) VALUES(@code,@codeview,@name,@facilitycode)"; SqlCommand com = new SqlCommand(); com.CommandText = sql; com.CommandType = CommandType.Text; com.Parameters.Add("@code", SqlDbType.VarChar).Value = obj.CODE; com.Parameters.Add("@codeview", SqlDbType.VarChar).Value = obj.CODEVIEW; com.Parameters.Add("@name", SqlDbType.NVarChar).Value = obj.NAME; com.Parameters.Add("@facilitycode", SqlDbType.VarChar).Value = obj.FACILITYCODE; ret = db.doCommand(ref com); return(ret); }
public int Insert(NATION_OBJ obj) { int ret = 0; DBBase db = new DBBase(ConfigurationSettings.AppSettings["connectionString"].ToString()); string sql = "INSERT INTO NATION(code,codeview, name, note, edituser,edittime,lock, lockdate) VALUES(@code,@codeview, @name, @note, @edituser,@edittime,@lock, @lockdate)"; SqlCommand com = new SqlCommand(); com.CommandText = sql; com.CommandType = CommandType.Text; com.Parameters.Add("@code", SqlDbType.VarChar).Value = obj.CODE; com.Parameters.Add("@codeview", SqlDbType.VarChar).Value = obj.CODEVIEW; com.Parameters.Add("@name", SqlDbType.NVarChar).Value = obj.NAME; com.Parameters.Add("@note", SqlDbType.NVarChar).Value = obj.NOTE; com.Parameters.Add("@edituser", SqlDbType.VarChar).Value = obj.EDITUSER; com.Parameters.Add("@edittime", SqlDbType.DateTime).Value = obj.EDITTIME; com.Parameters.Add("@lock", SqlDbType.Int).Value = obj.LOCK; com.Parameters.Add("@lockdate", SqlDbType.DateTime).Value = obj.LOCKDATE; ret = db.doCommand(ref com); return(ret); }
public int Update(graduatestudent_OBJ obj) { int ret = 0; DBBase db = new DBBase(ConfigurationSettings.AppSettings["connectionString"].ToString()); string sql = @"UPDATE graduatestudent SET studentcode=@studentcode ,graduationperiodcode=@graduationperiodcode WHERE code=@code_key "; SqlCommand com = new SqlCommand(); com.CommandText = sql; com.CommandType = CommandType.Text; com.Parameters.Add("@studentcode", SqlDbType.VarChar).Value = obj.studentcode; com.Parameters.Add("@graduationperiodcode", SqlDbType.VarChar).Value = obj.graduationperiodcode; com.Parameters.Add("@code_key", SqlDbType.VarChar).Value = obj._ID.CODE; ret = db.doCommand(ref com); return(ret); }
public int Insert(STUDENT_OBJ obj) { int ret = 0; DBBase db = new DBBase(ConfigurationSettings.AppSettings["connectionString"].ToString()); string sql = "INSERT INTO branch(code,codeview, name, note, edituser,edittime,lock, lockdate, universitycode, lang) VALUES(@code,@codeview, @name, @note, @edituser,@edittime,@lock, @lockdate, @universitycode, @lang)"; SqlCommand com = new SqlCommand(); com.CommandText = sql; com.CommandType = CommandType.Text; com.Parameters.Add("@code", SqlDbType.VarChar).Value = obj.CODE; com.Parameters.Add("@name", SqlDbType.NVarChar).Value = obj.NAME; //com.Parameters.Add("@note", SqlDbType.NVarChar).Value = obj.NOTE; //com.Parameters.Add("@edituser", SqlDbType.VarChar).Value = obj.EDITUSER; //com.Parameters.Add("@edittime", SqlDbType.DateTime).Value = obj.EDITTIME; //com.Parameters.Add("@lock", SqlDbType.Int).Value = obj.LOCK; //com.Parameters.Add("@lockdate", SqlDbType.DateTime).Value = obj.LOCKDATE; //com.Parameters.Add("@universitycode", SqlDbType.VarChar).Value = obj.UNIVERSITYCODE; //com.Parameters.Add("@lang", SqlDbType.VarChar).Value = obj.LANG; ret = db.doCommand(ref com); return(ret); }
public int Update(ROOM_OBJ obj) { int ret = 0; DBBase db = new DBBase(ConfigurationSettings.AppSettings["connectionString"].ToString()); string sql = @"UPDATE ROOM SET code=@code ,numberfloor=@numberflorr ,codeview=@codeview ,buildingcode=@buildingcode 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("@numberfloor", SqlDbType.VarChar).Value = obj.NUMBERFLOOR; com.Parameters.Add("@codeview", SqlDbType.VarChar).Value = obj.CODEVIEW; com.Parameters.Add("@buildingcode", SqlDbType.VarChar).Value = obj.BUILDINGCODE; com.Parameters.Add("@code_key", SqlDbType.VarChar).Value = obj._ID.CODE; ret = db.doCommand(ref com); return(ret); }
public int Insert(EDUCATIONLEVEL_OBJ obj) { int ret = 0; DBBase db = new DBBase(ConfigurationSettings.AppSettings["connectionString"].ToString()); string sql = "INSERT INTO EDUCATIONLEVEL(code,codeview, name, note, edituser,edittime,lock, lockdate, theorder, thetype, comparelevel, whois) VALUES(@code,@codeview, @name, @note, @edituser,@edittime,@lock, @lockdate, @theorder, @thetype, @comparelevel, @whois)"; SqlCommand com = new SqlCommand(); com.CommandText = sql; com.CommandType = CommandType.Text; com.Parameters.Add("@code", SqlDbType.VarChar).Value = obj.CODE; com.Parameters.Add("@codeview", SqlDbType.VarChar).Value = obj.CODEVIEW; com.Parameters.Add("@name", SqlDbType.NVarChar).Value = obj.NAME; com.Parameters.Add("@note", SqlDbType.NVarChar).Value = obj.NOTE; com.Parameters.Add("@edituser", SqlDbType.VarChar).Value = obj.EDITUSER; com.Parameters.Add("@edittime", SqlDbType.DateTime).Value = obj.EDITTIME; com.Parameters.Add("@lock", SqlDbType.Int).Value = obj.LOCK; com.Parameters.Add("@lockdate", SqlDbType.DateTime).Value = obj.LOCKDATE; com.Parameters.Add("@theorder", SqlDbType.Int).Value = obj.THEORDER; com.Parameters.Add("@thetype", SqlDbType.VarChar).Value = obj.THETYPE; com.Parameters.Add("@comparelevel", SqlDbType.Int).Value = obj.COMPARELEVEL; com.Parameters.Add("@whois", SqlDbType.VarChar).Value = obj.WHOIS; ret = db.doCommand(ref com); return(ret); }
public int Update(MAJOR_OBJ obj) { int ret = 0; DBBase db = new DBBase(ConfigurationSettings.AppSettings["connectionString"].ToString()); string sql = @"UPDATE MAJOR SET code=@code ,codeview=@codeview , name=@name , facilitycode =@facilitycode 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("@codeview", SqlDbType.VarChar).Value = obj.CODEVIEW; com.Parameters.Add("@name", SqlDbType.NVarChar).Value = obj.NAME; com.Parameters.Add("@facilitycode", SqlDbType.VarChar).Value = obj.FACILITYCODE; com.Parameters.Add("@code_key", SqlDbType.VarChar).Value = obj._ID.CODE; ret = db.doCommand(ref com); return(ret); }