public string genNextCode(graduatestudent_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(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 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 List <graduatestudent_OBJ> getAll(params spParam[] listFilter) { List <graduatestudent_OBJ> lidata = new List <uni.graduatestudent_OBJ>(); string sql = "SELECT * FROM graduatestudent"; string swhere = ""; SqlCommand cm = new SqlCommand(); foreach (var item in listFilter) { if (swhere != "") { swhere += " AND "; } if (item.data == null) { //cm.Parameters.Add("@" + f.Name, st); //cm.Parameters["@" + f.Name].Value = DBNull.Value; swhere += "[" + item.name + "]" + " is null"; } else { if (item.searchtype == 0) { swhere += "[" + item.name + "]= @" + item.name; cm.Parameters.Add(new SqlParameter("@" + item.name, item.data)); } else { swhere += "[" + item.name + "] LIKE @" + item.name; cm.Parameters.Add(new SqlParameter("@" + item.name, "%" + item.data + "%")); } } } if (swhere != "") { sql += " WHERE " + swhere; } cm.CommandText = sql; cm.CommandType = CommandType.Text; DataSet ds = new DataSet(); int ret = db.getCommand(ref ds, "Tmp", cm); if (ret < 0) { return(null); } else { foreach (DataRow dr in ds.Tables["Tmp"].Rows) { graduatestudent_OBJ obj = new graduatestudent_OBJ(); Type myTableObject = typeof(graduatestudent_OBJ); System.Reflection.PropertyInfo[] selectFieldInfo = myTableObject.GetProperties(); Type myObjectType = typeof(graduatestudent_OBJ.BusinessObjectID); System.Reflection.PropertyInfo[] fieldInfo = myObjectType.GetProperties(); //set object value foreach (System.Reflection.PropertyInfo info in selectFieldInfo) { if (info.Name != "_ID") { if (dr.Table.Columns.Contains(info.Name)) { if (!dr.IsNull(info.Name)) { info.SetValue(obj, dr[info.Name], null); } } } else { //set id value graduatestudent_OBJ.BusinessObjectID objid; objid = (graduatestudent_OBJ.BusinessObjectID)info.GetValue(obj, null); foreach (System.Reflection.PropertyInfo info1 in fieldInfo) { if (dr.Table.Columns.Contains(info1.Name)) { info1.SetValue(objid, dr[info1.Name], null); } } info.SetValue(obj, objid, null); } } lidata.Add(obj); } } return(lidata); }
public graduatestudent_OBJ createObject() { graduatestudent_OBJ obj = new graduatestudent_OBJ(); return(obj); }