//����
public void PubAll(String ids, String pubtime, String endtime)
{
DAO db = new DAO();
String sql = "update JpArticle set status='����',pubtime=@pubtime,endtime=@endtime where @aids like '%,'+cast(aid as varchar(12))+',%'";
SqlParameter[] prams ={
db.MakeInParam("@aids", SqlDbType.VarChar, ids),
db.MakeInParam("@pubtime", SqlDbType.DateTime, pubtime),
db.MakeInParam("@endtime", SqlDbType.DateTime, endtime),
};
db.Execute(sql, prams);
sql = "select aid, cid from JpArticle where @aids like '%,'+cast(aid as varchar(12))+',%'";
prams = new SqlParameter[]{
db.MakeInParam("@aids", SqlDbType.VarChar, ids)
};
DataTable dt = db.GetDataTable(sql, prams);
db.Close();
for (int i = 0; i < dt.Rows.Count; i++)
{
String l_cid = "";
int l_aid = 0;
l_cid = dt.Rows[i]["cid"].ToString();
l_aid = Int32.Parse(dt.Rows[i]["aid"].ToString());
JpColumns col = new JpColumns(l_cid);
//map_add(pubtime, endtime, l_cid, l_aid);
if (col.shtml.Equals("1"))// ��ǰ������Ŀ�Ǵ���̬�����������Զ�ˢ�£���վ��ҳ��������Ŀ��ҳ����ǰ����ҳ
{
shtmlpublish(true, l_cid, l_aid);
col.shtmlpublish(0, 0);
//�����ǰ��Ŀ����һ����Ŀ����������е��ϼ�Ŀ¼
if (l_cid.Length > 3)
{
for (int j = 0; j < (l_cid.Length / 3 - 1); j++)
{
JpColumns col_sj = new JpColumns(l_cid.Substring(0, 3 * (j + 1)));
col_sj.shtmlpublish(0, 0);
}
}
}
if (col.shtml.Equals("0"))// ��ʱ�������߶�̬����������ˢ�������Ŀ
{
col.shtmlRelation();// ������Ŀ��صľ�̬��Ŀ����
}
col.RssFlush(true);// RSS����
}
//���·���ʱͬʱ������ҳ�����õĶ���ҳ
PubHtml_Config();
}
