public string genNextCode(EDUCATIONLEVEL_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 Update(EDUCATIONLEVEL_OBJ obj)
{
int ret = 0;
DBBase db = new DBBase(ConfigurationSettings.AppSettings["connectionString"].ToString());
string sql = @"UPDATE EDUCATIONLEVEL SET
code=@code
,codeview=@codeview
, name=@name
, note=@note
, edituser=@edituser
,edittime=@edittime
,lock=@lock
, lockdate=@lockdate
, theorder=@theorder
, comparelevel=@comparelevel
, whois=@whois
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;
com.Parameters.Add("@theorder", SqlDbType.Int).Value = obj.THEORDER;
com.Parameters.Add("@comparelevel", SqlDbType.Int).Value = obj.COMPARELEVEL;
com.Parameters.Add("@whois", SqlDbType.VarChar).Value = obj.COMPARELEVEL;
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 List <EDUCATIONLEVEL_OBJ> getAll(params spParam[] listFilter)
{
List <EDUCATIONLEVEL_OBJ> lidata = new List <uni.EDUCATIONLEVEL_OBJ>();
string sql = "SELECT * FROM educationlevel";
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)
{
EDUCATIONLEVEL_OBJ obj = new EDUCATIONLEVEL_OBJ();
Type myTableObject = typeof(EDUCATIONLEVEL_OBJ);
System.Reflection.PropertyInfo[] selectFieldInfo = myTableObject.GetProperties();
Type myObjectType = typeof(EDUCATIONLEVEL_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
EDUCATIONLEVEL_OBJ.BusinessObjectID objid;
objid = (EDUCATIONLEVEL_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 EDUCATIONLEVEL_OBJ createObject()
{
EDUCATIONLEVEL_OBJ obj = new EDUCATIONLEVEL_OBJ();
return(obj);
}