/// <summary>
/// 企业信息实体化
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
public static CatalogInfo LoadSingleCatalogInfo(IDataReader reader)
{
if (reader.Read())
{
CatalogInfo _cataloginfo = new CatalogInfo();
_cataloginfo.id = TypeConverter.ObjectToInt(reader["id"]);
_cataloginfo.parentid = TypeConverter.ObjectToInt(reader["parentid"]);
_cataloginfo.sort = TypeConverter.ObjectToInt(reader["sort"]);
_cataloginfo.parentlist = reader["parentlist"].ToString().Trim();
_cataloginfo.displayorder = TypeConverter.ObjectToInt(reader["displayorder"]);
_cataloginfo.name = reader["name"].ToString().Trim();
_cataloginfo.haschild = reader["haschild"].ToString() == "True" ? 1 : 0;
_cataloginfo.companycount = TypeConverter.ObjectToInt(reader["companycount"]);
_cataloginfo.cllogo = reader["cllogo"].ToString();
reader.Close();
return _cataloginfo;
}
reader.Close();
return null;
}
/// <summary>
/// 企业信息实体化
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
public static CatalogInfo LoadSingleCatalogInfo(DataRow dr)
{
CatalogInfo _cataloginfo = new CatalogInfo();
_cataloginfo.id = TypeConverter.ObjectToInt(dr["id"]);
_cataloginfo.parentid = TypeConverter.ObjectToInt(dr["parentid"]);
_cataloginfo.sort = TypeConverter.ObjectToInt(dr["sort"]);
_cataloginfo.parentlist = dr["parentlist"].ToString().Trim();
_cataloginfo.displayorder = TypeConverter.ObjectToInt(dr["displayorder"]);
_cataloginfo.name = dr["name"].ToString().Trim();
_cataloginfo.haschild = dr["haschild"].ToString() == "True" ? 1 : 0;
_cataloginfo.companycount = TypeConverter.ObjectToInt(dr["companycount"]);
_cataloginfo.cllogo = dr["cllogo"].ToString();
return _cataloginfo;
}
/// <summary>
/// 创建行业类目
/// </summary>
/// <param name="_cataloginfo"></param>
/// <returns></returns>
public static int CreateCatalogInfo(CatalogInfo _cataloginfo)
{
return DatabaseProvider.GetInstance().CreateCatalog(_cataloginfo);
}
/// <summary>
/// 创建新行业类别
/// </summary>
/// <param name="cli"></param>
/// <returns></returns>
public static int CreateCatalogInfo(CatalogInfo cli)
{
return SAS.Data.DataProvider.Catalogies.CreateCatalogInfo(cli);
}
/// <summary>
/// 更新行业类别信息
/// </summary>
/// <param name="_catalog"></param>
public static void UpdateCatalogInfo(CatalogInfo _catalog)
{
DatabaseProvider.GetInstance().UpdateCatalogInfo(_catalog);
}
/// <summary>
/// 获取行业类别实体（缓存）
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static CatalogInfo GetCatalogCacheInfo(int id)
{
CatalogInfo cinfo = new CatalogInfo();
DataTable dt = GetAllCatalog();
foreach (DataRow dr in dt.Select("[id] = " + id))
{
cinfo.id = TypeConverter.StrToInt(dr["id"].ToString(), 0);
cinfo.name = dr["name"].ToString();
cinfo.parentid = TypeConverter.StrToInt(dr["parentid"].ToString(), 0);
cinfo.parentlist = dr["parentlist"].ToString();
cinfo.sort = TypeConverter.StrToInt(dr["sort"].ToString(), 0);
cinfo.cllogo = dr["cllogo"].ToString();
cinfo.displayorder = TypeConverter.StrToInt(dr["displayorder"].ToString(), 0);
cinfo.haschild = TypeConverter.StrToInt(dr["haschild"].ToString(), 0);
cinfo.companycount = TypeConverter.StrToInt(dr["companycount"].ToString(), 0);
return cinfo;
}
return null;
}
/// <summary>
/// 更新行业类别信息
/// </summary>
/// <param name="_catalog"></param>
public static void UpdateCatalogInfo(CatalogInfo _catalog)
{
SAS.Data.DataProvider.Catalogies.UpdateCatalogInfo(_catalog);
}
private void NewRootCategory()
{
CatalogInfo gc = new CatalogInfo();
gc.name = Utils.HtmlEncode(SASRequest.GetString("categoryname").Trim());
gc.parentid = 0;
gc.sort = 0;
gc.parentlist = "0";
gc.companycount = 0;
gc.haschild = 0;
int newcategoryid = Catalogs.CreateCatalogInfo(gc);
gc.id = newcategoryid;
ResetStatus();
this.RegisterStartupScript("PAGE", "window.location='company_cataloggrid.aspx';");
}
private void NewChildCategory()
{
int parentid = SASRequest.GetInt("parentcategoryid", 0);
CatalogInfo parentgc = Catalogs.GetCatalogInfo(parentid);
CatalogInfo gc = new CatalogInfo();
gc.name = Utils.HtmlEncode(SASRequest.GetString("categoryname").Trim());
gc.parentid = parentid;
gc.sort = parentgc.sort + 1;
if (parentgc.parentlist.Trim() == "0")
{
gc.parentlist = parentgc.id.ToString();
}
else
{
gc.parentlist = parentgc.parentlist + "," + parentgc.id;
}
gc.companycount = 0;
gc.haschild = 0;
int newcategoryid = Catalogs.CreateCatalogInfo(gc);
gc.id = newcategoryid;
parentgc.haschild = 1;
Catalogs.UpdateCatalogInfo(parentgc);
ResetStatus();
this.RegisterStartupScript("PAGE", "window.location='company_cataloggrid.aspx';");
}
private void MoveSubCategory(CatalogInfo parentgc, DataTable dt)
{
DataRow[] datarow = dt.Select("parentid=" + parentgc.id.ToString());
if (datarow.Length == 0)
return;
foreach (DataRow dr in datarow)
{
CatalogInfo gc = Catalogs.GetCatalogInfo(int.Parse(dr["id"].ToString()));
gc.parentlist = parentgc.parentlist + "," + parentgc.id;
gc.sort = parentgc.sort + 1;
Catalogs.UpdateCatalogInfo(gc);
MoveSubCategory(gc, dt);
}
}
/// <summary>
/// 创建行业类目
/// </summary>
/// <returns></returns>
public int CreateCatalog(CatalogInfo _cataloginfo)
{
DbParameter[] parms =
{
DbHelper.MakeInParam("@parentid", (DbType)SqlDbType.Int, 4,_cataloginfo.parentid),
DbHelper.MakeInParam("@sort", (DbType)SqlDbType.Int, 4,_cataloginfo.sort),
DbHelper.MakeInParam("@parentlist", (DbType)SqlDbType.NVarChar, 50,_cataloginfo.parentlist),
DbHelper.MakeInParam("@displayorder", (DbType)SqlDbType.Int, 4,_cataloginfo.displayorder),
DbHelper.MakeInParam("@name", (DbType)SqlDbType.NVarChar, 50,_cataloginfo.name),
DbHelper.MakeInParam("@haschild", (DbType)SqlDbType.Bit, 1,_cataloginfo.haschild),
DbHelper.MakeInParam("@cllogo", (DbType)SqlDbType.VarChar, 100,_cataloginfo.cllogo),
DbHelper.MakeInParam("@companycount", (DbType)SqlDbType.Int, 4,_cataloginfo.companycount)
};
string commandText = String.Format("INSERT INTO [{0}catalog] ([parentid], [sort], [parentlist], [displayorder], [name], [haschild], [cllogo], [companycount]) VALUES (@parentid, @sort, @parentlist, @displayorder, @name, @haschild, @cllogo, @companycount);SELECT SCOPE_IDENTITY() AS id", BaseConfigs.GetTablePrefix);
return TypeConverter.ObjectToInt(DbHelper.ExecuteScalar(CommandType.Text, commandText, parms), -1);
}
/// <summary>
/// 更新行业类别信息
/// </summary>
/// <param name="_catalog"></param>
/// <returns></returns>
public bool UpdateCatalogInfo(CatalogInfo _cataloginfo)
{
DbParameter[] parms =
{
DbHelper.MakeInParam("@parentid", (DbType)SqlDbType.Int, 4,_cataloginfo.parentid),
DbHelper.MakeInParam("@sort", (DbType)SqlDbType.Int, 4,_cataloginfo.sort),
DbHelper.MakeInParam("@parentlist", (DbType)SqlDbType.NVarChar, 50,_cataloginfo.parentlist),
DbHelper.MakeInParam("@displayorder", (DbType)SqlDbType.Int, 4,_cataloginfo.displayorder),
DbHelper.MakeInParam("@name", (DbType)SqlDbType.NVarChar, 50,_cataloginfo.name),
DbHelper.MakeInParam("@haschild", (DbType)SqlDbType.Bit, 1,_cataloginfo.haschild),
DbHelper.MakeInParam("@cllogo", (DbType)SqlDbType.VarChar, 100,_cataloginfo.cllogo),
DbHelper.MakeInParam("@companycount", (DbType)SqlDbType.Int, 4,_cataloginfo.companycount),
DbHelper.MakeInParam("@categoryid", (DbType)SqlDbType.Int, 4,_cataloginfo.id)
};
string commandText = String.Format("Update [{0}catalog] SET [parentid] = @parentid, [sort] = @sort, [parentlist] = @parentlist, [displayorder] = @displayorder, [name] = @name, [haschild] = @haschild, [cllogo] = @cllogo, [companycount] = @companycount WHERE [id] = @categoryid", BaseConfigs.GetTablePrefix);
DbHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
return true;
}
