/// <summary>
/// ��ȡһ����¼
/// </summary>
/// <param name="infoId">��¼���</param>
/// <returns>���ݶ���</returns>
public XYECOM.Model.DemandInfo GetItem(int infoId)
{
string sql = "select * from i_Demand where sd_id = " + infoId + "";
XYECOM.Model.DemandInfo info = null;
using (SqlDataReader reader = XYECOM.Core.Data.SqlHelper.ExecuteReader(sql))
{
if (reader.Read())
{
info = new XYECOM.Model.DemandInfo();
if (reader["AuditingState"].ToString() != "")
{
if (reader["AuditingState"].ToString().Equals("1"))
info.AuditingState = XYECOM.Model.AuditingState.Passed;
else
info.AuditingState = XYECOM.Model.AuditingState.NoPass;
}
else
{
info.AuditingState = XYECOM.Model.AuditingState.Null;
}
info.InfoID = infoId;
info.Title = reader["SD_Title"].ToString();
info.Price = MyConvert.GetDecimal(reader["SD_Price"].ToString());
info.PublishTime = Core.MyConvert.GetDateTime(reader["SD_PublishDate"].ToString());
info.EndTime = Core.MyConvert.GetDateTime(reader["SD_EndDate"].ToString());
info.UseFulDate = Core.MyConvert.GetInt32(reader["SD_Date"].ToString());
info.InfoType = Core.MyConvert.GetInt32(reader["SD_flag"].ToString());
info.MessageNum = Core.MyConvert.GetInt32(reader["SD_MessageNum"].ToString());
info.NotReadingNum = Core.MyConvert.GetInt32(reader["SD_NoMessgeNum"].ToString());
info.InfoContent = reader["SD_Description"].ToString();
info.UserID = Core.MyConvert.GetInt64(reader["U_ID"].ToString());
info.TypeName = reader["TypeName"].ToString();
info.HtmlPage = reader["SD_HTMLPage"].ToString();
info.WebSite = reader["website"].ToString();
info.Summary = reader["summary"].ToString();
info.ClickNum = Core.MyConvert.GetInt64(reader["SD_ClickNum"].ToString());
info.IsCommend = reader["SD_Vouch"].ToString() == "1";
info.Area = reader["Area"].ToString();
info.Trade = reader["Trade"].ToString();
info.TypeId = Core.MyConvert.GetInt32(reader["TypeId"].ToString());
info.AreaId = Core.MyConvert.GetInt32(reader["AreaId"].ToString());
info.TradeId = Core.MyConvert.GetInt32(reader["TradeId"].ToString());
info.IsPause = Core.MyConvert.GetBoolean(reader["SD_IsSupply"].ToString());
}
}
return info;
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
seo.Robots = true;
if (!pageinfo.IsPost)
{
//���ɵĶ���ֵ�����ڿ���ɾ��
es = offerinfo;
ed = machininginfo;
ibi = investmentinfo;
esi = serviceinfo;
string infoFlag = XYECOM.Core.XYRequest.GetQueryString("flag");
int lngInfoId = XYECOM.Core.MyConvert.GetInt32(XYECOM.Core.XYRequest.GetQueryString("infoid"));
if (lngInfoId <= 0 || infoFlag == "")
{
ShowErrorMsg("��Ϣ�����ڻ��ѱ�ɾ����");
return;
}
XYECOM.Configuration.SEOInfo seoInfo = null;
module = moduleConfig.GetItem(infoFlag);
//����������
string descTableName = "";
//����������࣬��Ҫ����SEO
string allClassName = "";
//��Ϣ����Id
long sortId =0;
//����Ϣ
if (module.EName.Equals("offer") || module.PEName.Equals("offer"))
{
pageinfo.ModuleFlag = "offer";
linkmodule = "buyoffer";
descTableName = "i_Supply";
offerinfo = new XYECOM.Business.Supply().GetItem(lngInfoId);
if (offerinfo == null || offerinfo.AuditingState != XYECOM.Model.AuditingState.Passed)
{
ShowErrorMsg("��Ϣ�����ڻ�δͨ����ˣ�");
return;
}
//���˹ؼ���
FilterKeyWord(offerinfo);
sortId = offerinfo.SortID;
curInfoUserId = offerinfo.UserID;
seoInfo = SEO.GetInfoPageSEO(module.EName);
if (seoInfo != null)
{
seo.Title = seoInfo.Title.Replace("{keyword}", offerinfo.Title);
seo.Description = seoInfo.Description.Replace("{keyword}", offerinfo.Title);
seo.Keywords = seoInfo.Keywords.Replace("{keyword}", offerinfo.SortName);
if (seoInfo.IsMatch)
{
allClassName = GetAllClassNameForSEO(infoFlag, offerinfo.SortID);
seo.Title += "_" + allClassName;
seo.Description += "," + allClassName;
seo.Keywords += "," + allClassName.Replace("_",",");
}
}
if (seo.Title.Equals("")){ seo.Title = offerinfo.Title; }
titleinfo = "�Ҷ�����" + config.WebName + "�����ġ�" + offerinfo.Title + "���ܸ���Ȥ";
fieldbody = GetFiledInnerHTML(offerinfo.SortID, module.EName, offerinfo.FieldID);
}
//�ӹ���Ϣ
if (module.EName.Equals("venture") || module.PEName.Equals("venture"))
{
pageinfo.ModuleFlag = "venture";
linkmodule = "buymachining";
descTableName = "i_Demand";
machininginfo = new XYECOM.Business.Demand().GetItem(lngInfoId);
if (machininginfo == null || machininginfo.AuditingState != XYECOM.Model.AuditingState.Passed)
{
ShowErrorMsg("��Ϣ�����ڻ�δͨ����ˣ�");
return;
}
//���˹ؼ���
FilterKeyWord(machininginfo);
sortId = machininginfo.TypeId;
curInfoUserId = machininginfo.UserID;
seoInfo = SEO.GetInfoPageSEO(module.EName);
if (seoInfo != null)
{
seo.Title = seoInfo.Title.Replace("{keyword}", machininginfo.Title);
seo.Description = seoInfo.Description.Replace("{keyword}", machininginfo.Title);
seo.Keywords = seoInfo.Keywords.Replace("{keyword}", machininginfo.SortName);
if (seoInfo.IsMatch)
{
allClassName = GetAllClassNameForSEO(infoFlag, machininginfo.TypeId);
seo.Title += "_" + allClassName;
seo.Description += "," + allClassName;
seo.Keywords += "," + allClassName.Replace("_",",");
}
}
if (seo.Title.Equals("")){seo.Title = machininginfo.Title;}
titleinfo = "�Ҷ�����" + config.WebName + "�����ġ�" + machininginfo.Title + "���ܸ���Ȥ";
fieldbody = GetFiledInnerHTML(machininginfo.TypeId, module.EName, machininginfo.FieldID);
}
//������Ϣ
if (module.EName.Equals("investment") || module.PEName.Equals("investment"))
{
pageinfo.ModuleFlag = "investment";
linkmodule = "buyinvestment";
descTableName ="i_InviteBusinessmanInfo";
investmentinfo = new XYECOM.Business.InviteBusinessmanInfo().GetItem(lngInfoId);
if(investmentinfo ==null || investmentinfo.AuditingState != XYECOM.Model.AuditingState.Passed)
{
ShowErrorMsg("��Ϣ�����ڻ�δͨ����ˣ�");
return;
}
//���˹ؼ���
FilterKeyWord(investmentinfo);
sortId = investmentinfo.SortID;
curInfoUserId = investmentinfo.UserID;
seoInfo = SEO.GetInfoPageSEO(module.EName);
if (seoInfo != null)
{
seo.Title = seoInfo.Title.Replace("{keyword}", investmentinfo.Title);
seo.Description = seoInfo.Description.Replace("{keyword}", investmentinfo.Title);
seo.Keywords = seoInfo.Keywords.Replace("{keyword}", investmentinfo.SortName);
if (seoInfo.IsMatch)
{
allClassName = GetAllClassNameForSEO(infoFlag, investmentinfo.SortID);
seo.Title += "_" + allClassName;
seo.Description += "," + allClassName;
seo.Keywords += "," + allClassName.Replace("_",",");
}
}
if (seo.Title.Equals("")){seo.Title = investmentinfo.Title;}
titleinfo = "�Ҷ�����" + config.WebName + "�����ġ�" + investmentinfo.Title + "���ܸ���Ȥ";
fieldbody = GetFiledInnerHTML(investmentinfo.SortID, module.EName, investmentinfo.FieldID);
}
//������Ϣ
if (module.EName.Equals("service") || module.PEName.Equals("service"))
{
pageinfo.ModuleFlag = "service";
linkmodule = "buyservice";
descTableName ="i_Surrogate";
serviceinfo = new XYECOM.Business.ServiceInfo().GetItem(lngInfoId);
if (serviceinfo == null || serviceinfo.AuditingState != XYECOM.Model.AuditingState.Passed)
{
ShowErrorMsg("��Ϣ�����ڻ�δͨ����ˣ�");
return;
}
//���˹ؼ���
FilterKeyWord(serviceinfo);
sortId = serviceinfo.SortID;
curInfoUserId = serviceinfo.UserID;
seoInfo = SEO.GetInfoPageSEO(module.EName);
if (seoInfo != null)
{
seo.Title = seoInfo.Title.Replace("{keyword}", serviceinfo.Title);
seo.Description = seoInfo.Description.Replace("{keyword}", serviceinfo.Title);
seo.Keywords = seoInfo.Keywords.Replace("{keyword}", serviceinfo.SortName);
if (seoInfo.IsMatch)
{
allClassName = GetAllClassNameForSEO(infoFlag, serviceinfo.SortID);
seo.Title += "_" + allClassName;
seo.Description += "," + allClassName;
seo.Keywords += "," + allClassName.Replace("_",",");
}
}
if (seo.Title.Equals("")){seo.Title = serviceinfo.Title;}
titleinfo = "�Ҷ�����" + config.WebName + "�����ġ�" + serviceinfo.Title + "���ܸ���Ȥ";
fieldbody = GetFiledInnerHTML(serviceinfo.SortID, module.EName, serviceinfo.FieldID);
}
UpdateNavigation(module.EName, sortId);
offerinfo.SellBuy = machininginfo.SellBuy = investmentinfo.SellBuy = serviceinfo.SellBuy = "buy";
if (lngInfoId > 0)
{
dtimg = XYECOM.Core.Function.GetDataTable(" where DescTabID=" + lngInfoId + " and DescTabName='"+descTableName+"' and At_Index > 1 ", " ", "XYV_Attachment");
}
if (SEO.IsAppendWebName)
{
seo.Title = seo.Title + "_" + webInfo.WebName;
seo.Description = seo.Description + "," + webInfo.WebName;
seo.Keywords = seo.Keywords + "," + webInfo.WebName;
}
infoid = lngInfoId +"";
dtm = GetExpressMessage(module.EName);
//�û���Ϣ
if (curInfoUserId > 0)
{
XYECOM.Business.UserInfo ui = new XYECOM.Business.UserInfo();
eui = ui.GetItem(Convert.ToInt64(curInfoUserId));
try
{
areaname = eui.AreaInfo.FullNameAll;
}
catch { }
XYECOM.Business.UserReg ur = new XYECOM.Business.UserReg();
eu = ur.GetItem(Convert.ToInt64(curInfoUserId));
uinformation = eu.InFormation * 2;
yearnum = DateTime.Compare(DateTime.Now, eu.RegDate).ToString();
}
}
}
