public string genNextCode(MAJOR_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(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 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); }
public List <MAJOR_OBJ> getAll(params spParam[] listFilter) { List <MAJOR_OBJ> lidata = new List <MAJOR_OBJ>(); string sql = "SELECT * FROM major"; 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) { MAJOR_OBJ obj = new MAJOR_OBJ(); Type myTableObject = typeof(MAJOR_OBJ); System.Reflection.PropertyInfo[] selectFieldInfo = myTableObject.GetProperties(); Type myObjectType = typeof(MAJOR_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 MAJOR_OBJ.BusinessObjectID objid; objid = (MAJOR_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 MAJOR_OBJ createObject() { MAJOR_OBJ obj = new MAJOR_OBJ(); return(obj); }