//���� 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(); }