private void BindGrid()
{
DataTable dt;
string sql = @"SELECT [ID] ,[SettingID] ,[Name] FROM [dbo].[Setting] where [SettingID]='" + stype + "' and (state=1 or state is null)";
if (stype == "40")
{
sql += " order by [Name]";
}
dt = DBZhengce.getDataTable(sql);
try
{
myGrid.DataSource = dt;
myGrid.DataBind();
PgCount = myGrid.PageCount;
PgIndex = myGrid.PageIndex; RCount = dt.Rows.Count;
}
catch
{
//myGrid. = 0;
myGrid.DataSource = dt;
myGrid.DataBind();
}
finally
{
}
}
private void settinghy2js()
{
DataTable dt = DBZhengce.getDataTable("SELECT [HangYeID],[Name] FROM [dbo].[HangYe2] where state=1 order by HangYeID");
//class2js = "[";
string id = string.Empty;
foreach (DataRow dr in dt.Rows)
{
if (id != dr["HangYeID"].ToString())
{
if (id == null || id == string.Empty)
{
class2js += "[";
}
else
{
class2js = class2js.Substring(0, class2js.Length - 1);
class2js += "],[";
}
id = dr["HangYeID"].ToString();
}
class2js += "\"" + dr["Name"].ToString() + "\",";
}
class2js = class2js.Substring(0, class2js.Length - 1);
class2js = "[ [\"请选择小类\"]," + class2js + "]]";
}
public static string getValue(string sql)
{
string rt = "0";
try
{
SqlConnection con = DBZhengce.createConnection();
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
con.Close();
if (dt.Rows.Count > 0)
{
rt = dt.Rows[0][0].ToString();
}
}
catch (Exception ex)
{
WriteDiskLog("getDataTable:" + ex.Message + ",sql:" + sql);;
}
if (Common._sqllog)
{
Common.WriteDiskSql(sql);
}
return(rt);
}
private void noupdate()
{
string sql = "SELECT * FROM [dbo].[zhengce] where state=1 and ( [hangye] is null ) ";
//Response.Write(sql);
int count = DBZhengce.getSelectRowsCount(sql);
Label5.Text = "未处理信息总计：" + count.ToString() + "条";
}
public static string _getParaValue(string para)
{
string value = string.Empty;
DataTable dt = DBZhengce.getDataTable("select value from syspara where para='" + para + "'");
if (dt.Rows.Count > 0)
{
value = dt.Rows[0][0].ToString();
}
return(value);
}
private void setting(int itype, DropDownList ddlname)
{
DataTable dt = DBZhengce.getDataTable("SELECT [ID],[Name] FROM [dbo].[sheng] ");
ddlname.DataSource = dt;
ddlname.DataTextField = "Name";
ddlname.DataValueField = "ID";
ddlname.DataBind();
//ddlname.Items.Insert(0, new ListItem("全国", "0"));
// ddlname.Text = "0";
}
private void setting(int itype, DropDownList ddlname)
{
DataTable dt = DBZhengce.getDataTable("SELECT [ID],[Name] FROM [dbo].[Setting] where SettingID=" + itype + " and state=1 ");
ddlname.DataSource = dt;
ddlname.DataTextField = "Name";
ddlname.DataValueField = "ID";
ddlname.DataBind();
//ddlname.Items.Insert(0, new ListItem("==请选择==", ""));
//ddlname.SelectedValue = "";
}
protected void myGrid_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string name = ((TextBox)(myGrid.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim();
//string id = ((TextBox)(myGrid.Rows[e.RowIndex].Cells[0].Controls[0])).Text.ToString().Trim();
string id = myGrid.DataKeys[e.RowIndex].Value.ToString();
string sql = "update[Setting] set[Name] = '" + name + "' where ID='" + id + "'";
DBZhengce.getRowsCount(sql);
myGrid.EditIndex = -1;
BindGrid();
}
private DataTable hangye2class(int itype, CheckBoxList cl)
{
string sql = "";
sql = "SELECT [ID] ,[HangYeID] ,[Name] ,[state] FROM [dbo].[HangYe2] where [HangYeID] = '" + itype + "' and state=1";
DataTable dt = DBZhengce.getDataTable(sql);
cl.DataSource = dt;
cl.DataTextField = "Name"; //绑定的字段名
cl.DataValueField = "id"; //绑定的值
cl.DataBind();
return(dt);
}
protected void myGrid_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string name = ((TextBox)(myGrid.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim();
string desc = ((TextBox)(myGrid.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim();
string id = myGrid.DataKeys[e.RowIndex].Value.ToString();
//id = myGrid.DataKeys[e.RowIndex].Value.ToString();
string sql = "update [ZhuanXiang2] set[Name] = '" + name + "',[Description]='" + desc + "' where [ID]='" + id + "'";
DBZhengce.getRowsCount(sql);
myGrid.EditIndex = -1;
BindGrid();
}
private DataTable sheng(int itype, CheckBoxList cl)
{
string sql = "";
sql = "SELECT [id],[name] FROM [dbo].[sheng] where state=1";
DataTable dt = DBZhengce.getDataTable(sql);
cl.DataSource = dt;
cl.DataTextField = "name"; //绑定的字段名
cl.DataValueField = "id"; //绑定的值
cl.DataBind();
return(dt);
}
private DataTable NewMethod(int itype, CheckBoxList cl)
{
string sql = "";
sql = "SELECT [ID] ,[SettingID] ,[Name] ,[state] FROM [dbo].[Setting] where SettingID = '" + itype + "' and state=1";
DataTable dt = DBZhengce.getDataTable(sql);
cl.DataSource = dt;
cl.DataTextField = "Name"; //绑定的字段名
cl.DataValueField = "id"; //绑定的值
cl.DataBind();
return(dt);
}
private void settingzcjs(int itype)
{
DataTable dt = DBZhengce.getDataTable("SELECT [ID],[Name] FROM [dbo].[Setting] where SettingID=" + itype + " and state=1 order by id ");
if (itype == 52)
{
foreach (DataRow dr in dt.Rows)
{
classjs += "\"" + dr["Name"].ToString() + "\",";
}
classjs = classjs.Substring(0, classjs.Length - 1);
classjs = "[\"请选择行业\"," + classjs + "]";
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string sql = "";
if (id == 0)
{
//sql = "insert into zqhl_news([title],[content],classid,qz,pic,en,sel,writer,author,typename,cdate)values(";
//sql += "'" + Common.strFilter(title.Text) + "','" + Common.strFilter(content1.Text.Replace("&emsp ", " ")) + "'," + classid + "," + Common.strFilter(qz.Text);
//sql += ",'" + Common.strFilter(pic.Text) + "'," + ((en.Checked) ? "1" : "0") + "," + ((sel.Checked) ? "1" : "0") + ",'" + Common.strFilter(writer.Text) + "','" + Session["adminloginuser"] + "','" + cbtext1 + "','" + cdate.Text + "')";
sql = @"INSERT INTO [dbo].[caijiset]
([url] ,[domain] ,[startstr] ,[endstr]
,[titlestart] ,[titleend] ,[urlstart] ,[urlend]
,[configstart] ,[configend] ,[textstart] ,[textend]
,[fwhaostart] ,[fwhaoend] ,[cwdatestart] ,[cwdateend]
,[fwjigoustart] ,[fwjigouend] ,[fbriqistart] ,[fbriqiend]
,[chinaname] ,[classname] ,[update] ,[state], [userid],[cishu],[cityid],[error])
VALUES
('" + Common.strFilter(url.Text) + "','" + Common.strFilter(domain.Text) + "','" + Common.strFilter(startstr.Text) + "','" + Common.strFilter(endstr.Text) + "','" +
Common.strFilter(titlestart.Text) + "','" + Common.strFilter(titleend.Text) + "','" + Common.strFilter(urlstart.Text) + "','" + Common.strFilter(urlend.Text) + "','" +
Common.strFilter(configstart.Text) + "','" + Common.strFilter(configend.Text) + "','" + Common.strFilter(textstart.Text) + "','" + Common.strFilter(textend.Text) + "','" +
Common.strFilter(fwhaostart.Text) + "','" + Common.strFilter(fwhaoend.Text) + "','" + Common.strFilter(cwdatestart.Text) + "','" + Common.strFilter(cwdateend.Text) + "','" +
Common.strFilter(fwjigoustart.Text) + "','" + Common.strFilter(fwjigouend.Text) + "','" + Common.strFilter(fbriqistart.Text) + "','" + Common.strFilter(fbriqiend.Text) + "','" +
Common.strFilter(chinaname.Text) + "','" + Common.strFilter(classname.Text) + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
+ "',1,'" + Session["userid"] + "','" + Common.strFilter(cishu.Text) + "','" + Common.strFilter(cityid.Text) + "',1)";
}
else
{
sql = @"UPDATE [dbo].[caijiset]
set [url]='" + Common.strFilter(url.Text) + "' ,[domain]='" + Common.strFilter(domain.Text) + "' ,[startstr]='" + Common.strFilter(startstr.Text) + "' ,[endstr]='" + Common.strFilter(endstr.Text)
+ "',[titlestart] ='" + Common.strFilter(titlestart.Text) + "' ,[titleend]='" + Common.strFilter(titleend.Text) + "' ,[urlstart]='" + Common.strFilter(urlstart.Text) + "' ,[urlend]='" + Common.strFilter(urlend.Text)
+ "',[configstart] ='" + Common.strFilter(configstart.Text) + "' ,[configend]='" + Common.strFilter(configend.Text) + "' ,[textstart]='" + Common.strFilter(textstart.Text) + "' ,[textend]='" + Common.strFilter(textend.Text)
+ "',[fwhaostart]='" + Common.strFilter(fwhaostart.Text) + "' ,[fwhaoend]='" + Common.strFilter(fwhaoend.Text) + "' ,[cwdatestart]='" + Common.strFilter(cwdatestart.Text) + "' ,[cwdateend]='" + Common.strFilter(cwdateend.Text)
+ "',[fwjigoustart]='" + Common.strFilter(fwjigoustart.Text) + "' ,[fwjigouend]='" + Common.strFilter(fwjigouend.Text) + "' ,[fbriqistart]='" + Common.strFilter(fbriqistart.Text) + "' ,[fbriqiend]='" + Common.strFilter(fbriqiend.Text)
+ "',[chinaname]='" + Common.strFilter(chinaname.Text) + "' ,[classname]='" + Common.strFilter(classname.Text) + "' ,[update]='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
+ "', [cishu]='" + Common.strFilter(cishu.Text) + "', [cityid]='" + Common.strFilter(cityid.Text) + "', [error]='" + Common.strFilter(error.Text) + "' WHERE id=" + id + "";
}
int count = DBZhengce.getRowsCount(sql);
if (count > 0)
{
msg.Text = "配制信息保存成功";
}
else
{
msg.Text = "保存失败" + sql;
}
Response.Write("<script language=javascript >window.opener.location.reload('zhengcelist.aspx?id=0'); </script > ");
}
public static DataSet getData(string sql)
{
SqlConnection con = DBZhengce.createConnection();
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds, "dataTable");
con.Close();
if (Common._sqllog)
{
Common.WriteDiskSql(sql);
}
return(ds);
}
private void settingzc(int itype, DropDownList ddlname)
{
DataTable dt = DBZhengce.getDataTable("SELECT [ID],[Name] FROM [dbo].[Setting] where SettingID=" + itype + " and state=1 order by id ");
ddlname.DataSource = dt;
ddlname.DataTextField = "Name";
ddlname.DataValueField = "ID";
ddlname.DataBind();
ddlname.Items.Insert(0, new ListItem("==未选择==", "0"));
ddlname.SelectedValue = "";
if (itype == 52)
{
foreach (DataRow dr in dt.Rows)
{
classjs += "\"" + dr["Name"].ToString() + "\",";
}
classjs = classjs.Substring(0, classjs.Length - 1);
classjs = "[\"请选择行业\"," + classjs + "]";
}
}
public static int getRowsCount(string sql)
{
try
{
SqlConnection con = DBZhengce.createConnection();
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
int count = cmd.ExecuteNonQuery();
con.Close();
if (Common._sqllog)
{
Common.WriteDiskSql(sql);
}
//WriteDiskLog("getRowsCount:sql:" + sql); //return 0;
return(count);
}
catch (Exception ex)
{
WriteDiskLog("getRowsCount:" + ex.Message + ",sql:" + sql); return(0);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (TextBox1.Text.Length == 0)
{
Label1.Text = ("输入类型,不允许为空！");
return;
}
string sql = @"INSERT INTO [dbo].[Setting] ([SettingID] ,[Name] ,[state]) VALUES
('" + stype + "','" + TextBox1.Text.Trim().ToString() + "', 1)";
int count = DBZhengce.getRowsCount(sql);
if (count > 0)
{
Label1.Text = "保存成功";
}
else
{
Label1.Text = "保存失败" + sql;
}
BindGrid();
}
public static int getSelectRowsCount(string sql)
{
try
{
SqlConnection con = DBZhengce.createConnection();
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
con.Close();
if (Common._sqllog)
{
Common.WriteDiskSql(sql);
}
return(dt.Rows.Count);
}
catch (Exception ex)
{
WriteDiskLog("getDataTable:" + ex.Message + ",sql:" + sql); return(-1);
}
}
private void BindGrid()
{
DataTable dt;
string sql = @"SELECT [ID] ,[HangYeID] ,[Name] ,[Description] FROM [dbo].[ZhuanXiang2] where (state=1 or state is null) and [HangYeID]=" + stype;
dt = DBZhengce.getDataTable(sql);
try
{
myGrid.DataSource = dt;
myGrid.DataBind();
PgCount = myGrid.PageCount;
PgIndex = myGrid.PageIndex; RCount = dt.Rows.Count;
}
catch
{
//myGrid. = 0;
myGrid.DataSource = dt;
myGrid.DataBind();
}
finally
{
}
}
private void BindGrid()
{
DataTable dt;
string sql = @"SELECT * from zhengce where state=1 ";
if (sname.Text.Length > 0)
{
sql += " and (mingcheng like '%" + sname.Text.Trim() + "%' or keys like '%" + sname.Text.Trim() + "%' )";
}
if (Request.QueryString["chuli"] != null)
{
if (Request.QueryString["chuli"] == "0")
{
sql += " and ( [hangye] is null )";
}
else
{
sql += " and ( [hangye] is not null )";
}
}
//[Tech_LaiYuan]
//if (ddlLaiYuan.SelectedValue != "0")
//{
// sql += " and p.ResultsType=" + ddlLaiYuan.SelectedValue;
//}
//if (ddlDiWei.SelectedValue != "0")
//{
// sql += " and p.ShuiPing=" + ddlDiWei.SelectedValue;
//}
//if (LeiBie.SelectedValue != "0")
//{
// sql += " and p.LeiBie=" + LeiBie.SelectedValue;
//}
//if (ddlhangye.SelectedValue != "0")
//{
// //sql += " and charindex(','+cast("+ ddlhangye.SelectedValue + " as varchar)+',',','+p.YingYongLingYu+',')>0" ;
// sql += " and charindex(','+cast(" + ddlhangye.SelectedValue + " as varchar)+',',','+p.hangye+',')>0";
//}
//if (Session["userid"].ToString() != "3" && Session["userid"].ToString() != "4" && Session["title"].ToString() != "5" && Session["userid"].ToString() != "13")
//{
// sql += " and p.UserID='" + Session["userid"] + "' ";
//}
//if (yewu.SelectedValue.Length > 0)
//{
// sql += " and p.UserID=" + yewu.SelectedValue;
//}
//if (sname.Text.Length > 0)
//{
// string zid = _getzhuanjiaid(sname.Text);
// sql += " and (p.RName like '%" + sname.Text + "%' or c.name like '%" + sname.Text + "%' ) ";
//}
//if (ddlCompany.SelectedValue != "0")
//{
// sql += " and ChiYouRenType=0 and p.ChiYouRenID=" + ddlCompany.SelectedValue;
//}
////if (indexview.Checked)
////{
//// sql += " and indexview=1";
////}
//if (indexlocation.SelectedValue != "0")
//{
// sql += " and indexlocation=" + indexlocation.SelectedValue;
//}
//if (((hezuo.Checked == true)))
//{
// sql += " and hezuo=1";
//}
//if (dian == 0)
//{ sql += " order by p.[Update] desc"; }
//else
{ sql += " order by id desc"; }
//Response.Write(sql+ yewu.SelectedValue);
dt = DBZhengce.getDataTable(sql);
try
{
myGrid.DataSource = dt;
myGrid.DataBind();
PgCount = myGrid.PageCount;
PgIndex = myGrid.PageIndex; RCount = dt.Rows.Count;
}
catch
{
//myGrid. = 0;
myGrid.DataSource = dt;
myGrid.DataBind();
}
finally
{
}
}
private DataTable NewMethod1()
{
DataTable dt = DBZhengce.getDataTable("select * from zhengce where id=" + id);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
mingcheng.Text = dr["mingcheng"].ToString();
fawendanwen.Text = dr["fawendanwen"].ToString();
wenhao.Text = dr["wenhao"].ToString();
try { faburiqi.Text = Convert.ToDateTime(dr["faburiqi"]).ToString("yyyy-MM-dd"); } catch { }
//cengji.Text = dr["cengji"].ToString();
//SetChecked(cengjicb, dr["cengji"].ToString(), ",");
//cengjicb.SelectedValue = dr["cengji"].ToString();
//gldiqu.Text = dr["buwensheng"].ToString(); //地区
SetChecked(gldiqu, dr["buwensheng"].ToString(), ",");
//gongcheng.Text = dr["gongcheng"].ToString();
//lingyu.Text = dr["lingyu"].ToString();
//SetChecked(gongchengc, dr["gongcheng"].ToString(), ",");
//gongchengc.SelectedValue = dr["gongcheng"].ToString();
SetCheckedrbl(gongchengc, dr["gongcheng"].ToString(), ","); //五大工程
SetChecked(hangyec, dr["lingyu"].ToString(), ",");
SetChecked(hangyecbl, dr["hangye"].ToString(), ",");
if (dr["cengji"].ToString() == "11392")//层级
{
cengji1.Checked = true;
zhichiview = "";
gongchengview = "style=\"display:none;\"";
}
else if (dr["cengji"].ToString() == "11393")
{
cengji2.Checked = true;
buweiview = "";
if (dr["buwei"].ToString() == "11397")//工信部
{
buwei1.Checked = true;
gongchengview = "";
}
else if (dr["buwei"].ToString() == "11398")
{
buwei2.Checked = true;
gongchengview = "style=\"display:none;\"";
}
else if (dr["buwei"].ToString() == "11399")
{
buwei3.Checked = true;
gongchengview = "style=\"display:none;\"";
}
else if (dr["buwei"].ToString() == "11400")
{
buwei4.Checked = true;
gongchengview = "style=\"display:none;\"";
}
else if (dr["buwei"].ToString() == "11401")
{
buwei5.Checked = true;
kejiview = "";
gongchengview = "style=\"display:none;\"";
if (dr["zxleixing"].ToString() == "1")//专项
{
zhichiview = "style=\"display:none;\"";
zhengcel1.Checked = true;
xiangmuliview = "";
if (dr["xmleixing"].ToString() == "11743")//项目类型
{
xiangmu1.Checked = true;
zhangxiang1.SelectedValue = dr["zxming"].ToString();//专项名称
zhangxiangli1view = "";
zhangxiangli2view = "style=\"display:none;\"";
zhangxiangli3view = "style=\"display:none;\"";
}
else if (dr["xmleixing"].ToString() == "11744")//项目类型
{
xiangmu2.Checked = true;
zhangxiang2.SelectedValue = dr["zxming"].ToString();//专项名称
zhangxiangli1view = "style=\"display:none;\"";
zhangxiangli2view = "";
zhangxiangli3view = "style=\"display:none;\"";
}
else if (dr["xmleixing"].ToString() == "11745")//项目类型
{
xiangmu3.Checked = true;
zhangxiang3.SelectedValue = dr["zxming"].ToString();//专项名称
zhangxiangli1view = "style=\"display:none;\"";
zhangxiangli2view = "style=\"display:none;\"";
zhangxiangli3view = "";
}
//专项年份
if (dr["zxnian"].ToString() == "2018")
{
Radio3.Checked = true;
}
else if (dr["zxnian"].ToString() == "2016")
{
Radio1.Checked = true;
}
else if (dr["zxnian"].ToString() == "2017")
{
Radio2.Checked = true;
}
else if (dr["zxnian"].ToString() == "2019")
{
Radio4.Checked = true;
}
ketifx.Text = dr["ketifx"].ToString(); //课题方向
shishizq.Text = dr["shishizq"].ToString(); //实施周期
}
else if (dr["zxleixing"].ToString() == "0") //非专项
{
zhengcel2.Checked = true;
zhichiview = "";
}
}
}
else if (dr["cengji"].ToString() == "11394")
{
cengji3.Checked = true;
difangview = "";
zhichiview = "";
gongchengview = "style=\"display:none;\"";
}
//gldiqu.SelectedValue = dr["gldiqu"].ToString();
if (dr["gldixiang"].ToString().Contains("支持园区"))
{
jishu1_1.Checked = true;
}
else if (dr["gldixiang"].ToString().Contains("支持企业"))
{
jishu1_2.Checked = true;
}
else if (dr["gldixiang"].ToString().Contains("科研单位"))
{
jishu1_3.Checked = true;
}
if (dr["zczijin"].ToString() == "1")
{
RadioButton4.Checked = true;
}
else if (dr["zczijin"].ToString() == "0")
{
RadioButton5.Checked = true;
}
if (dr["psfangshi"].ToString().Contains("招投标"))
{
RadioButton1.Checked = true;
}
else if (dr["psfangshi"].ToString().Contains("评审"))
{
RadioButton2.Checked = true;
}
else if (dr["psfangshi"].ToString().Contains("其他"))
{
RadioButton3.Checked = true;
Text3.Value = dr["psfangshi"].ToString().Substring((dr["psfangshi"].ToString().IndexOf("其他：") + 3));
}
//HttpContext.Current.Request["cengji"]
//yiju.Text = dr["yiju"].ToString();
//mubiao.Text = dr["mubiao"].ToString();
youxiaoqi.Text = dr["youxiaoqi"].ToString();
//hangye.Text = dr["hangye"].ToString();
//SetChecked(hangyecl, dr["hangye"].ToString(), ",");
//tbhangye.Text = dr["hangye"].ToString();
//hangyejs.Value = dr["hangye"].ToString();
//chanpin.Text = dr["chanpin"].ToString();
zcywdizhi.Text = dr["zcywdizhi"].ToString();
//mubiao.Text = dr["mubiao"].ToString();
content.Text = dr["zhengceqw"].ToString().Replace("&emsp ", " ");
url.Text = dr["url"].ToString();
////pic.Text = dr["pic"].ToString();
//en.Checked = (dr["en"].ToString() == "0" ? false : true);
//sel.Checked = (dr["sel"].ToString() == "0" ? false : true);
try
{
faburiqi.Text = DateTime.Parse(dr["cdate"].ToString()).ToString("yyyy-MM-dd");
}
catch { }
//try
//{
// classn.Items.FindByValue(dr["classid"].ToString()).Selected = true;
//}
//catch { }
//SetChecked(CheckBoxList1, dr["typename"].ToString(), ",");
//SetChecked(CheckBoxList2, dr["typename"].ToString(), ",");
//SetChecked(CheckBoxList3, dr["typename"].ToString(), ",");
//SetChecked(CheckBoxList4, dr["typename"].ToString(), ",");
}
return(dt);
}
//public static string SetChecked(CheckBoxList checkList, string selval, string separator)
//{
// selval = separator + selval + separator; //例如："0,1,1,2,1"->",0,1,1,2,1,"
// for (int i = 0; i < checkList.Items.Count; i++)
// {
// checkList.Items[i].Selected = false;
// string val = separator + checkList.Items[i].Value + separator;
// if (selval.IndexOf(val) != -1)
// {
// checkList.Items[i].Selected = true;
// selval = selval.Replace(val, separator); //然后从原来的值串中删除已经选中了的
// if (selval == separator) //selval的最后一项也被选中的话，此时经过Replace后，只会剩下一个分隔符
// {
// selval += separator; //添加一个分隔符
// }
// }
// }
// selval = selval.Substring(1, selval.Length - 2); //除去前后加的分割符号
// return selval;
//}
//private DataTable NewMethod(int itype, CheckBoxList cl)
//{
// string sql = "";
// sql = "select * from zqhl_class where en>0 and typeid='" + itype + "' and fl<>4 order by typeid asc,fl asc,sx asc";//fl=4为专家类别
// DataTable dt = DBC.getDataTable(sql);
// cl.DataSource = dt;
// cl.DataTextField = "class";//绑定的字段名
// cl.DataValueField = "id";//绑定的值
// cl.DataBind();
// return dt;
//}
//protected void scfile_Click(object sender, EventArgs e)
//{
// msg.Text = "";
// if (!upfile.HasFile) { msg.Text = "请选择文件后上传"; return; }
// if (upfile.FileBytes.Length > 1024 * 1024)
// { msg.Text = "文件不能大于1M"; return; }
// string ext = upfile.FileName.Substring(upfile.FileName.Length - 3).ToLower();
// if (ext != "png" && ext != "jpg" && ext != "gif")
// {
// msg.Text = "文件格式只能是png或jpg或gif"; return;
// }
// string file = DateTime.Now.ToString("yyyMMddHHmmss.ss");
// string filename = Server.MapPath("../upload/") + file + "." + ext;
// upfile.SaveAs(filename);
// pic.Text = "/upload/" + file + "." + ext;
//}
protected void bc_Click(object sender, EventArgs e)
{
//foreach (Control ct in this.form1.Controls)//循环查询表单里面的子控件
//{
// if (ct.GetType().ToString().Equals("System.Web.UI.WebControls.CheckBox"))
// {
// CheckBox cb = (CheckBox)ct;
// if (cb.Checked == true)
// {
// stext+=(cb.Text + "<br/>");//这句换成取值
// }
// }
//}
///Response.Write(stext);
string classid = "0";
string cbtext1 = "";
string sql = "";
try { Convert.ToDateTime(faburiqi.Text); }
catch
{
msg.Text = "发布日期,时间格式不正确 ！";
return;
}
if (mingcheng.Text == "")
{
msg.Text = "政策名称，不能为空";
return;
}
if (wenhao.Text == "")
{
msg.Text = "政策文号，不能为空";
return;
}
if (fawendanwen.Text == "")
{
msg.Text = "发文单位，不能为空";
return;
}
//if (buwensheng.Text == "")
//{
// msg.Text = "层级，不能为空";
// return;
//}
//单位层级
string cengji = "";
if (Request.Form["cengji"] != null)
{
cengji = (int.Parse(Request.Form["cengji"]) + 11391).ToString();
}
if (cengji == "")
{
msg.Text = "层级，不能为空";
return;
}
//国家部委
string buwei = "";
if (Request.Form["buwei"] != null)
{
buwei = (int.Parse(Request.Form["buwei"]) + 11396).ToString();
}
string xmleixing = "";
if (Request.Form["xiangmu"] != null)
{
xmleixing = (int.Parse(Request.Form["xiangmu"]) + 11742).ToString();
}
string zxming = "";
if (xmleixing == "11743")
{
zxming = zhangxiang1.SelectedValue;
}
else if (xmleixing == "11744")
{
zxming = zhangxiang2.SelectedValue;
}
else if (xmleixing == "11745")
{
zxming = zhangxiang3.SelectedValue;
}
string zxnian = "";
if (Request.Form["zxnian"] != null)
{
zxnian = (int.Parse(Request.Form["zxnian"])).ToString();
}
//if (cbtext1 == "")
//{
// msg.Text = "必须选择一个分类";
// return;
//}
//cbtext1 = cbtext1.Substring(0, cbtext1.Length - 1);
string cbtexthy = "";
for (int i = 0; i < hangyec.Items.Count; i++)
{
if (hangyec.Items[i].Selected == true)
{
//这个打勾的
cbtexthy += hangyec.Items[i].Value + ",";
//if (classid == "0")
//{
// classid = hangye.Items[i].Value;
//}
}
else
{
//这是没打的
}
}
string gongcheng = "";
for (int i = 0; i < gongchengc.Items.Count; i++)
{
if (gongchengc.Items[i].Selected == true)
{
//这个打勾的
gongcheng += gongchengc.Items[i].Value + ",";
//if (classid == "0")
//{
// classid = hangye.Items[i].Value;
//}
}
else
{
//这是没打的
}
}
string gldiqusheng = "";
for (int i = 0; i < gldiqu.Items.Count; i++)
{
if (gldiqu.Items[i].Selected == true)
{
//这个打勾的
gldiqusheng += gldiqu.Items[i].Value + ",";
//if (classid == "0")
//{
// classid = hangye.Items[i].Value;
//}
}
else
{
//这是没打的
}
}
//for (int i = 0; i < cengjicb.Items.Count; i++)
//{
// if (cengjicb.Items[i].Selected == true)
// {
// //这个打勾的
// cengji = cengjicb.Items[i].Value;
// //if (classid == "0")
// //{
// // classid = hangye.Items[i].Value;
// //}
// }
// else
// {
// //这是没打的
// }
//}
string hangye = "";
string hangyesql = "delete from [dbo].[hangye] where zhengceid='" + id + "';";
for (int i = 0; i < hangyecbl.Items.Count; i++)
{
if (hangyecbl.Items[i].Selected == true)
{
//这个打勾的
hangye += hangyecbl.Items[i].Value + ",";
//if (classid == "0")
//{
// classid = hangye.Items[i].Value;
//}
hangyesql += "INSERT INTO [dbo].[hangye]([zhengceid],[hangye]) VALUES ('" + id + "','" + hangyecbl.Items[i].Value + "');";
}
else
{
//这是没打的
}
}
if (hangye == "")
{
msg.Text = "必须选择一个或多个行业";
return;
}
int zczijin = 0;
//string gldixiang = "";
if (RadioButton4.Checked == true)
{
zczijin = 1;
} //固定资产投资比例
if (RadioButton5.Checked == true)
{
zczijin = 0;
} //一定额度资金
//string zcjibie = "";
//string gldixiang = "";
//if (RadioButton6.Checked == true) { zcjibie += "国家中央支持,"; }//资产/规模要求
//if (RadioButton7.Checked == true) { zcjibie += "部委支持,"; }//企业性质要求
//if (RadioButton8.Checked == true) { zcjibie += "地方支持,"; }//技术要求
string gldixiang = "";
//string gldixiang = "";
if (jishu1_1.Checked == true)
{
gldixiang += "园区";
} //组织机构/企业
if (jishu1_2.Checked == true)
{
gldixiang += "企业";
} //个人
if (jishu1_3.Checked == true)
{
gldixiang += " 科研单位";
} //个人
//hangye = tbhangye.Text;
////hangye = hangyejs.Value;
string psfangshi = "";
//string gldixiang = "";
if (RadioButton1.Checked == true)
{
psfangshi = "招投标";
} //招投标
if (RadioButton2.Checked == true)
{
psfangshi = "评审";
} //评审
if (RadioButton3.Checked == true)
{
psfangshi = "其他：" + Text3.Value.ToString();
} //其他
int zxleixing = -1;
if (zhengcel1.Checked)
{
zxleixing = 1;
} //专项
if (zhengcel2.Checked)
{
zxleixing = 0;
} //非专项
if (id == 0)
{
//sql = "insert into zqhl_news([title],[content],classid,qz,pic,en,sel,writer,author,typename,cdate)values(";
//sql += "'" + Common.strFilter(title.Text) + "','" + Common.strFilter(content1.Text.Replace("&emsp ", " ")) + "'," + classid + "," + Common.strFilter(qz.Text);
//sql += ",'" + Common.strFilter(pic.Text) + "'," + ((en.Checked) ? "1" : "0") + "," + ((sel.Checked) ? "1" : "0") + ",'" + Common.strFilter(writer.Text) + "','" + Session["adminloginuser"] + "','" + cbtext1 + "','" + cdate.Text + "')";
sql = @"INSERT INTO [dbo].[zhengce]
([mingcheng] ,[wenhao] ,[faburiqi] ,[fawendanwen]
,[cengji] ,[buwei] ,[buwensheng] ,[gongcheng] ,[lingyu]
,[youxiaoqi] ,[hangye]
,[zhengceqw] ,[zcywdizhi] ,[state] ,[createdate]
,[userid],[caiji],[gldiqu]，[zczijin]
,[zcjibie],[gldixiang],[psfangshi],[zxleixing]
,[xmleixing],[zxming],[zxnian],[ketifx],[shishizq])
VALUES
('" + Common.strFilter(mingcheng.Text) + "','" + Common.strFilter(wenhao.Text) + "','" + Common.strFilter(faburiqi.Text) + "','" + Common.strFilter(fawendanwen.Text) + "','" +
Common.strFilter(cengji) + "','" + Common.strFilter(buwei) + "','" + Common.strFilter(gldiqusheng) + "','" + Common.strFilter(gongcheng) + "','" + Common.strFilter(cbtexthy) + "','" +
Common.strFilter(youxiaoqi.Text) + "','" + Common.strFilter(hangye) + "','" +
Common.strFilter(content1.Text.Replace("&emsp ", " ")) + "','" + Common.strFilter(zcywdizhi.Text) + "',1,'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
+ "','" + Session["userid"] + "',0，'" + Common.strFilter(gldiqusheng) + "','" + zczijin
+ "','" + cengji + "','" + gldixiang + "','" + psfangshi + "','" + zxleixing + "','"
+ xmleixing + "','" + zxming + "','" + zxnian + "','" + Common.strFilter(ketifx.Text) + "','" + Common.strFilter(shishizq.Text) + "');";
//以下字段编辑时上传
//// ,[glchanneng] ,[gldiqu] ,[gldixiang]
// ,[zcshijian] ,[zcshuoming] ,[gmfangshi] ,[gmshuoming]
// ,[psfangshi] ,[psshuoming] ,[shenbaotj] ,[sbjttiaojian]
// ,[xzchanneng] ,[xzdiqu] ,[xzzhuti] ,[xzfashism]
//
}
else
{
//sql = "update zqhl_news set [title]='" + Common.strFilter(title.Text) + "',[content]='" + Common.strFilter(content1.Text.Replace("&emsp ", " ")) + "',classid=" + classid + ",qz=" + Common.strFilter(qz.Text);
//sql += ",pic='" + Common.strFilter(pic.Text) + "',en=" + ((en.Checked) ? "1" : "0") + ",sel=" + ((sel.Checked) ? "1" : "0") + ",writer='" + Common.strFilter(writer.Text) + "',typename='" + cbtext1 + "',cdate='" + cdate.Text + "' where id=" + id;
sql = @"update zhengce set [mingcheng]='" + Common.strFilter(mingcheng.Text) + "',[wenhao]='" + Common.strFilter(wenhao.Text) + "' ,[faburiqi]='" + Common.strFilter(faburiqi.Text) + "',[fawendanwen]='" + Common.strFilter(fawendanwen.Text)
+ "' ,[cengji] ='" + Common.strFilter(cengji) + "' ,[buwei] ='" + Common.strFilter(buwei) + "' ,[buwensheng] ='" + Common.strFilter(gldiqusheng) + "' ,[gongcheng]='" + Common.strFilter(gongcheng) + "' ,[lingyu]='" + Common.strFilter(cbtexthy)
+ "' ,[youxiaoqi]='" + Common.strFilter(youxiaoqi.Text) + "', [gldiqu]='" + Common.strFilter(gldiqusheng) + "' , [zczijin]='" + zczijin + "' , [hangye]='" + Common.strFilter(hangye)
+ "' ,[zhengceqw] ='" + Common.strFilter(content1.Text.Replace("&emsp ", " ")) + "' ,[zcywdizhi] ='" + Common.strFilter(zcywdizhi.Text) + "' ,[zcjibie]='" + Common.strFilter(cengji) + "' ,[gldixiang]='" + Common.strFilter(gldixiang)
+ "' ,[psfangshi]='" + Common.strFilter(psfangshi) + "' ,[zxleixing]='" + zxleixing + "' ,[xmleixing]='" + Common.strFilter(xmleixing) + "' ,zxming='" + zxming + "',zxnian='" + zxnian + "',ketifx='" + Common.strFilter(ketifx.Text) + "',shishizq='" + Common.strFilter(shishizq.Text) + "' ,[update]='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' where id=" + id + ";";
}
int count = DBZhengce.getRowsCount(sql + hangyesql);
if (count > 0)
{
msg.Text = "保存成功";
}
else
{
msg.Text = "保存失败" + sql + hangyesql;
}
//NewMethod2();
if (cengji == "11392")//层级
{
zhichiview = "";
gongchengview = "style=\"display:none;\"";
}
else if (cengji == "11393")
{
buweiview = "";
if (buwei == "11397")//工信部
{
gongchengview = "";
zhichiview = "";
xiangmuliview = "style=\"display:none;\"";
xiangmuliview = "style=\"display:none;\"";
}
else if (buwei == "11398")//发改委
{
zhichiview = "";
gongchengview = "style=\"display:none;\"";
xiangmuliview = "style=\"display:none;\"";
}
else if (buwei == "11399")
{
zhichiview = "";
gongchengview = "style=\"display:none;\"";
xiangmuliview = "style=\"display:none;\"";
}
else if (buwei == "11400")
{
zhichiview = "";
gongchengview = "style=\"display:none;\"";
xiangmuliview = "style=\"display:none;\"";
}
else if (buwei == "11401")//科技部
{
kejiview = "";
zhichiview = "";
gongchengview = "style=\"display:none;\"";
if (zxleixing == 1)//专项
{
xiangmuliview = "";
zhichiview = "style=\"display:none;\"";
if (xmleixing == "11743")//项目类型
{
xiangmu1.Checked = true;
zhangxiang1.SelectedValue = zxming;//专项名称
zhangxiangli1view = "";
zhangxiangli2view = "style=\"display:none;\"";
zhangxiangli3view = "style=\"display:none;\"";
}
else if (xmleixing == "11744")//项目类型
{
xiangmu2.Checked = true;
zhangxiang2.SelectedValue = zxming;//专项名称
zhangxiangli1view = "style=\"display:none;\"";
zhangxiangli2view = "";
zhangxiangli3view = "style=\"display:none;\"";
}
else if (xmleixing == "11745")//项目类型
{
xiangmu3.Checked = true;
zhangxiang3.SelectedValue = zxming;//专项名称
zhangxiangli1view = "style=\"display:none;\"";
zhangxiangli2view = "style=\"display:none;\"";
zhangxiangli3view = "";
}
}
else if (zxleixing == 0)//非专项
{
zhichiview = "";
xiangmuliview = "style=\"display:none;\"";
}
}
}
else if (cengji == "11394")
{
difangview = "";
zhichiview = "";
gongchengview = "style=\"display:none;\"";
}
Response.Write("<script language=javascript >window.opener.location.reload('zhengce.aspx'); </script > ");
}
private void BindGridedit()
{
DataTable dt;
string sql = @"SELECT * FROM [dbo].[caijiset] where [id]='" + Request.QueryString["id"] + "' ";
dt = DBZhengce.getDataTable(sql);
try
{
if (dt.Rows.Count > 0)
{
//string str = "";
DataRow dr = dt.Rows[0];
//ArrayList al2 = new ArrayList();
//int i = 0;
//foreach (DataRow dr in dt.Rows)
//{
// keyword[i] = dr["Name"].ToString();
// i++;
// al2.Add(dr["Name"].ToString());
//}
//keyword = al2;
chinaname.Text = dr["chinaname"].ToString();
classname.Text = dr["classname"].ToString();
url.Text = dr["url"].ToString();
domain.Text = dr["domain"].ToString();
startstr.Text = dr["startstr"].ToString();
endstr.Text = dr["endstr"].ToString();
configstart.Text = dr["configstart"].ToString();
configend.Text = dr["configend"].ToString();
textstart.Text = dr["textstart"].ToString();
textend.Text = dr["textend"].ToString();
fwhaostart.Text = dr["fwhaostart"].ToString();
fwhaoend.Text = dr["fwhaoend"].ToString();
cwdatestart.Text = dr["cwdatestart"].ToString();
cwdateend.Text = dr["cwdateend"].ToString();
fwjigoustart.Text = dr["fwjigoustart"].ToString();
fwjigouend.Text = dr["fwjigouend"].ToString();
fbriqistart.Text = dr["fbriqistart"].ToString();
fbriqiend.Text = dr["fbriqiend"].ToString();
urlstart.Text = dr["urlstart"].ToString();
urlend.Text = dr["urlend"].ToString();
titlestart.Text = dr["titlestart"].ToString();
titleend.Text = dr["titleend"].ToString();
cishu.Text = dr["cishu"].ToString();
cityid.Text = dr["cityid"].ToString();
error.Text = dr["error"].ToString();
}
}
catch
{
//myGrid. = 0;
}
finally
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Common.isAdminLogin())
{
Response.Redirect("login.aspx");
Response.End();
}
//try
//{
// this.content1.Text = Request.Form["content"];
//}
//catch { }
try
{
id = int.Parse(Request.QueryString["id"].ToString());
if (!Page.IsPostBack)
{
DataTable dt;
//NewMethod(1, CheckBoxList1);
//NewMethod(2, CheckBoxList2);
//NewMethod(3, CheckBoxList3);
//NewMethod(4, CheckBoxList4);
setting(2, gldiqu); //地区
//setting(2, xzdiqu); //地区
if (id == 0)
{
//faburiqi.Text = DateTime.Now.ToString("yyyy-MM-dd");
//youxiaoqi.Text = DateTime.Now.ToString("yyyy-MM-dd");
}
else
{
dt = DBZhengce.getDataTable("select * from zhengce where id=" + id);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
mingcheng.Text = dr["mingcheng"].ToString();
//glchanneng.Text = dr["glchanneng"].ToString();
gldiqu.Text = dr["gldiqu"].ToString();
//zcshuoming.Text = dr["zcshuoming"].ToString();
//gmshuoming.Text = dr["gmshuoming"].ToString();
//psshuoming.Text = dr["psshuoming"].ToString();
//sbjttiaojian.Text = dr["sbjttiaojian"].ToString();
//xzchanneng.Text = dr["xzchanneng"].ToString();
//xzdiqu.Text = dr["xzdiqu"].ToString();
//xzzhuti.Text = dr["xzzhuti"].ToString();
//content.Text = dr["xzfashism"].ToString();
if (dr["gldixiang"].ToString().Contains("支持园区/地方（高新区，市等）"))
{
jishu1_1.Checked = true;
}
if (dr["gldixiang"].ToString().Contains("支持企业（支持央企/国企；不限企业类型）"))
{
jishu1_2.Checked = true;
}
if (dr["zczijin"].ToString() == "1")
{
RadioButton4.Checked = true;
}
else
{
RadioButton5.Checked = true;
}
//if (dr["gldixiang"].ToString().Contains("项目"))
//{
// jishu1_3.Checked = true;
//}
//if (dr["gldixiang"].ToString().Contains("其他"))
//{
// jishu1_4.Checked = true;
// txtjishu4_3.Value = dr["gldixiang"].ToString().Substring((dr["gldixiang"].ToString().IndexOf("其他：")+3));
//}
//else
//{
// //msg.Text = dr["gldixiang"].ToString().Contains("其他").ToString();
//}
if (dr["zcjibie"].ToString().Contains("国家中央支持"))
{
RadioButton6.Checked = true;
}
if (dr["zcjibie"].ToString().Contains("部委支持"))
{
RadioButton7.Checked = true;
}
if (dr["zcjibie"].ToString().Contains("地方支持"))
{
RadioButton8.Checked = true;
}
//if (dr["zcjibie"].ToString().Contains("其他"))
//{
// CheckBox11.Checked = true;
// Text4.Value = dr["shenbaotj"].ToString().Substring((dr["shenbaotj"].ToString().IndexOf("其他：") + 3));
//}
//else
//{
// //msg.Text = dr["gldixiang"].ToString().Contains("其他").ToString();
//}
//if (dr["gmfangshi"].ToString().Contains("固定资产投资比例"))
//{
// CheckBox4.Checked = true;
//}
//if (dr["gmfangshi"].ToString().Contains("一定额度资金"))
//{
// CheckBox5.Checked = true;
//}
//if (dr["gmfangshi"].ToString().Contains("退税"))
//{
// CheckBox6.Checked = true;
//}
//if (dr["gmfangshi"].ToString().Contains("其他"))
//{
// CheckBox7.Checked = true;
// Text2.Value = dr["gmfangshi"].ToString().Substring((dr["gmfangshi"].ToString().IndexOf("其他：") + 3));
//}
//else
//{
// //msg.Text = dr["gldixiang"].ToString().Contains("其他").ToString();
//}
//if (dr["zcshijian"].ToString().Contains("投资前"))
//{
// CheckBox1.Checked = true;
//}
//else if (dr["zcshijian"].ToString().Contains("投资后"))
//{
// CheckBox2.Checked = true;
//}
//else if(dr["zcshijian"].ToString().Contains("其他"))
//{
// CheckBox3.Checked = true;
// Text1.Value = dr["zcshijian"].ToString().Substring((dr["zcshijian"].ToString().IndexOf("其他：") + 3));
//}
//else { //msg.Text = dr["zcshijian"].ToString().Contains("其他").ToString();
//}
if (dr["psfangshi"].ToString().Contains("招投标"))
{
RadioButton1.Checked = true;
}
else if (dr["psfangshi"].ToString().Contains("评审"))
{
RadioButton2.Checked = true;
}
else if (dr["psfangshi"].ToString().Contains("其他"))
{
RadioButton3.Checked = true;
Text3.Value = dr["psfangshi"].ToString().Substring((dr["psfangshi"].ToString().IndexOf("其他：") + 3));
}
else
{
//msg.Text = dr["psfangshi"].ToString().Contains("其他").ToString();
}
//SetChecked(CheckBoxList1, dr["typename"].ToString(), ",");
//SetChecked(CheckBoxList2, dr["typename"].ToString(), ",");
//SetChecked(CheckBoxList3, dr["typename"].ToString(), ",");
//SetChecked(CheckBoxList4, dr["typename"].ToString(), ",");
}
}
}
classid = int.Parse(Request.QueryString["class"].ToString());
page = int.Parse(Request.QueryString["page"].ToString());
}
catch { }
}
protected void bc_Click(object sender, EventArgs e)
{
//foreach (Control ct in this.form1.Controls)//循环查询表单里面的子控件
//{
// if (ct.GetType().ToString().Equals("System.Web.UI.WebControls.CheckBox"))
// {
// CheckBox cb = (CheckBox)ct;
// if (cb.Checked == true)
// {
// stext+=(cb.Text + "<br/>");//这句换成取值
// }
// }
//}
///Response.Write(stext);
string classid = "0";
string cbtext1 = "";
string sql = "";
//try { Convert.ToDateTime(faburiqi.Text); }
//catch
//{
// msg.Text = "时间格式不正确 ！";
// return;
//}
//if (pic.Text == "")
//{
// msg.Text = "必须上传图片";
// return;
//}
//if (cbtext1 == "")
//{
// msg.Text = "必须选择一个分类";
// return;
//}
//cbtext1 = cbtext1.Substring(0, cbtext1.Length - 1);
if (id == 0)
{
//sql = "insert into zqhl_news([title],[content],classid,qz,pic,en,sel,writer,author,typename,cdate)values(";
//sql += "'" + Common.strFilter(title.Text) + "','" + Common.strFilter(content1.Text.Replace("&emsp ", " ")) + "'," + classid + "," + Common.strFilter(qz.Text);
//sql += ",'" + Common.strFilter(pic.Text) + "'," + ((en.Checked) ? "1" : "0") + "," + ((sel.Checked) ? "1" : "0") + ",'" + Common.strFilter(writer.Text) + "','" + Session["adminloginuser"] + "','" + cbtext1 + "','" + cdate.Text + "')";
//以下字段编辑时上传
//// ,[glchanneng] ,[gldiqu] ,[gldixiang]
// ,[zcshijian] ,[zcshuoming] ,[gmfangshi] ,[gmshuoming]
// ,[psfangshi] ,[psshuoming] ,[shenbaotj] ,[sbjttiaojian]
// ,[xzchanneng] ,[xzdiqu] ,[xzzhuti] ,[xzfashism]
//
}
else
{
string gldixiang = "";
//string gldixiang = "";
if (jishu1_1.Checked == true)
{
gldixiang += "支持园区/地方（高新区，市等）";
} //组织机构/企业
if (jishu1_2.Checked == true)
{
gldixiang += "支持企业（支持央企/国企；不限企业类型）";
} //个人
//if (jishu1_3.Checked == true) { gldixiang += "项目,"; }//技术转让
//if (jishu1_4.Checked == true) { gldixiang += "其他：" + txtjishu4_3.Value.ToString(); }//其他
string zcshijian = "";
//string gldixiang = "";
//if (CheckBox1.Checked == true) { zcshijian = "投资前"; }//投资前
//if (CheckBox2.Checked == true) { zcshijian = "投资后"; }//投资后
//if (CheckBox3.Checked == true) { zcshijian = "其他：" + Text1.Value.ToString(); }//其他
string psfangshi = "";
//string gldixiang = "";
if (RadioButton1.Checked == true)
{
psfangshi = "招投标";
} //招投标
if (RadioButton2.Checked == true)
{
psfangshi = "评审";
} //评审
if (RadioButton3.Checked == true)
{
psfangshi = "其他：" + Text3.Value.ToString();
} //其他
int zczijin = 0;
//string gldixiang = "";
if (RadioButton4.Checked == true)
{
zczijin = 1;
} //固定资产投资比例
if (RadioButton5.Checked == true)
{
zczijin = 0;
} //一定额度资金
//if (CheckBox6.Checked == true) { gmfangshi += "退税,"; }//技术转让
//if (CheckBox7.Checked == true) { gmfangshi += "其他：" + Text2.Value.ToString(); }//其他
string zcjibie = "";
//string gldixiang = "";
if (RadioButton6.Checked == true)
{
zcjibie += "国家中央支持,";
} //资产/规模要求
if (RadioButton7.Checked == true)
{
zcjibie += "部委支持,";
} //企业性质要求
if (RadioButton8.Checked == true)
{
zcjibie += "地方支持,";
} //技术要求
//if (CheckBox11.Checked == true) { shenbaotj += "其他：" + Text4.Value.ToString(); }//其他
//sql = "update zqhl_news set [title]='" + Common.strFilter(title.Text) + "',[content]='" + Common.strFilter(content1.Text.Replace("&emsp ", " ")) + "',classid=" + classid + ",qz=" + Common.strFilter(qz.Text);
//sql += ",pic='" + Common.strFilter(pic.Text) + "',en=" + ((en.Checked) ? "1" : "0") + ",sel=" + ((sel.Checked) ? "1" : "0") + ",writer='" + Common.strFilter(writer.Text) + "',typename='" + cbtext1 + "',cdate='" + cdate.Text + "' where id=" + id;
sql = @"update zhengce set [gldiqu]='" + Common.strFilter(gldiqu.Text) + "' ,[gldixiang]='" + Common.strFilter(gldixiang) + "',[zcshijian]='" + Common.strFilter(zcshijian)
+ "' ,[zczijin]='" + zczijin + "' ,[zcjibie]='" + Common.strFilter(zcjibie) + "' ,[psfangshi]='" + Common.strFilter(psfangshi)
+ "' ,[update]='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' where id=" + id + "";
}
int count = DBZhengce.getRowsCount(sql);
if (count > 0)
{
msg.Text = "保存成功";
}
else
{
msg.Text = "保存失败" + sql;
}
}
public int GetHtmlfeixi(string url, string title)
{
int count = 0;
string Html = GetHtml(url.Trim());
try
{
Html = Html.ToString().Replace("\"", "").Replace("'", "");
string xinxi = Html.Substring(Html.IndexOf(configstart.Text.Trim()));
xinxi = xinxi.Remove(xinxi.IndexOf(configend.Text.Trim())).Trim();//信息
//Response.Write( xinxi);
string Introduce = Html.Substring(Html.IndexOf(textstart.Text.Trim()) + 7); //全文内容
Introduce = Introduce.Remove(Introduce.IndexOf(textend.Text.Trim())).Trim(); //内容
bool bkeyword = false;
foreach (object k1 in keyword)
{
if (Introduce.Contains(k1.ToString()) || title.Contains(k1.ToString()))
{
bkeyword = true;
break;
}
}
if (bkeyword)
{
//textBox5.Text = title.ToString()+"---|";
//string sql = @"INSERT INTO [dbo].[zhengce]
// ([mingcheng] ,[wenhao] ,[faburiqi] ,[fawendanwen]
// ,[cengji] ,[buwensheng] ,[gongcheng] ,[lingyu]
// ,[yiju] ,[mubiao] ,[youxiaoqi] ,[hangye]
// ,[chanpin] ,[zhengceqw] ,[zcywdizhi] ,[state] ,[createdate]
// ,[userid])
// VALUES
// ('" + Common.strFilter(mingcheng.Text) + "','" + Common.strFilter(wenhao.Text) + "','" + Common.strFilter(faburiqi.Text) + "','" + Common.strFilter(fawendanwen.Text) + "','" +
// Common.strFilter(cengji.SelectedValue) + "','" + Common.strFilter(buwensheng.Text) + "','" + Common.strFilter(gongcheng.Text) + "','" + Common.strFilter(lingyu.Text) + "','" +
// Common.strFilter(yiju.Text) + "','" + Common.strFilter(mubiao.Text) + "','" + Common.strFilter(youxiaoqi.Text) + "','" + Common.strFilter(hangye.SelectedValue) + "','" +
// Common.strFilter(chanpin.Text) + "','" + Common.strFilter(content.Text) + "','" + Common.strFilter(zcywdizhi.Text) + "',1,'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
// + "','" + Session["userid"] + "')";
string wenhao = chuli(xinxi, "[发文字号]", "</span>", 6);
string faburiqi = chuli(xinxi, "[成文日期]", "</span>", 6);
string fawendanwen = chuli(xinxi, "[发文机构]", "</li>", 6);
string youxiaoqi = chuli(xinxi, "[发布日期]", "</span>", 6);
string sql = @"INSERT INTO [dbo].[zhengce]
([mingcheng] ,[wenhao] ,[faburiqi] ,[fawendanwen],[youxiaoqi]
,[zhengceqw] ,[zcywdizhi] ,[state] ,[createdate]
,[userid],[caiji])
VALUES
('" + Common.strFilter(title) + "','" + Common.strFilter(wenhao) + "','" + Common.strFilter(faburiqi) + "','" + Common.strFilter(fawendanwen) + "','" + Common.strFilter(youxiaoqi)
+ "','" + Common.strFilter(Introduce) + "','" + Common.strFilter(url) + "',1,'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
+ "','" + Session["userid"] + "',1)";
count = DBZhengce.getRowsCount(sql);
}
}
catch { return(0); }
if (count > 0)
{
return(1);
}
else
{
return(0);
}
}
protected void sc_Command(object sender, CommandEventArgs e)
{
DBZhengce.getRowsCount("update zhengce set state=0 where id=" + e.CommandArgument);
BindGrid();
noupdate();
}
protected void Page_Load(object sender, EventArgs e)
{
//hangye.AutoPostBack = true;
if (!Common.isAdminLogin())
{
Response.Redirect("login.aspx");
Response.End();
}
try
{
this.content1.Text = Request.Form["content"];
}
catch { }
try
{
id = int.Parse(Request.QueryString["id"].ToString());
if (!Page.IsPostBack)
{
DataTable dt;
//NewMethod(1, CheckBoxList1);
//NewMethod(2, CheckBoxList2);
//NewMethod(3, CheckBoxList3);
//NewMethod(4, CheckBoxList4);
//setting(51, cengji); //发文单位所属层级
NewMethodRBL(51, cengjicb); // 单位层级
settingzc(2, buwensheng); //发文的部委/省级
//setting(50, gongcheng); //政策所属：五大工程，其他
//setting(6, lingyu); //政策所属：十大重点领域
NewMethod(6, hangyec); //政策所属：十大重点领域
NewMethod(50, gongchengc); //政策所属：五大工程
//hangye2(52, hangyecl);//政策所属：针对行业
NewMethod(52, hangyecbl); //针对行业
//settingzcjs(52); //针对行业
//settinghy2js(); //行业小类
if (id == 0)
{
faburiqi.Text = DateTime.Now.ToString("yyyy-MM-dd");
youxiaoqi.Text = DateTime.Now.ToString("yyyy-MM-dd");
}
else
{
dt = DBZhengce.getDataTable("select * from zhengce where id=" + id);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
mingcheng.Text = dr["mingcheng"].ToString();
fawendanwen.Text = dr["fawendanwen"].ToString();
wenhao.Text = dr["wenhao"].ToString();
try { faburiqi.Text = Convert.ToDateTime(dr["faburiqi"]).ToString("yyyy-MM-dd"); } catch { }
//cengji.Text = dr["cengji"].ToString();
//SetChecked(cengjicb, dr["cengji"].ToString(), ",");
cengjicb.SelectedValue = dr["cengji"].ToString();
buwensheng.Text = dr["buwensheng"].ToString();
//gongcheng.Text = dr["gongcheng"].ToString();
//lingyu.Text = dr["lingyu"].ToString();
SetChecked(gongchengc, dr["gongcheng"].ToString(), ",");
SetChecked(hangyec, dr["lingyu"].ToString(), ",");
SetChecked(hangyecbl, dr["hangye"].ToString(), ",");
yiju.Text = dr["yiju"].ToString();
mubiao.Text = dr["mubiao"].ToString();
youxiaoqi.Text = dr["youxiaoqi"].ToString();
//hangye.Text = dr["hangye"].ToString();
//SetChecked(hangyecl, dr["hangye"].ToString(), ",");
//tbhangye.Text = dr["hangye"].ToString();
//hangyejs.Value = dr["hangye"].ToString();
//chanpin.Text = dr["chanpin"].ToString();
zcywdizhi.Text = dr["zcywdizhi"].ToString();
//mubiao.Text = dr["mubiao"].ToString();
content.Text = dr["zhengceqw"].ToString().Replace("&emsp ", " ");
url.Text = dr["url"].ToString();
////pic.Text = dr["pic"].ToString();
//en.Checked = (dr["en"].ToString() == "0" ? false : true);
//sel.Checked = (dr["sel"].ToString() == "0" ? false : true);
try
{
faburiqi.Text = DateTime.Parse(dr["cdate"].ToString()).ToString("yyyy-MM-dd");
}
catch { }
//try
//{
// classn.Items.FindByValue(dr["classid"].ToString()).Selected = true;
//}
//catch { }
//SetChecked(CheckBoxList1, dr["typename"].ToString(), ",");
//SetChecked(CheckBoxList2, dr["typename"].ToString(), ",");
//SetChecked(CheckBoxList3, dr["typename"].ToString(), ",");
//SetChecked(CheckBoxList4, dr["typename"].ToString(), ",");
}
}
}
classid = int.Parse(Request.QueryString["class"].ToString());
page = int.Parse(Request.QueryString["page"].ToString());
}
catch { }
}
//public static string SetChecked(CheckBoxList checkList, string selval, string separator)
//{
// selval = separator + selval + separator; //例如："0,1,1,2,1"->",0,1,1,2,1,"
// for (int i = 0; i < checkList.Items.Count; i++)
// {
// checkList.Items[i].Selected = false;
// string val = separator + checkList.Items[i].Value + separator;
// if (selval.IndexOf(val) != -1)
// {
// checkList.Items[i].Selected = true;
// selval = selval.Replace(val, separator); //然后从原来的值串中删除已经选中了的
// if (selval == separator) //selval的最后一项也被选中的话，此时经过Replace后，只会剩下一个分隔符
// {
// selval += separator; //添加一个分隔符
// }
// }
// }
// selval = selval.Substring(1, selval.Length - 2); //除去前后加的分割符号
// return selval;
//}
//private DataTable NewMethod(int itype, CheckBoxList cl)
//{
// string sql = "";
// sql = "select * from zqhl_class where en>0 and typeid='" + itype + "' and fl<>4 order by typeid asc,fl asc,sx asc";//fl=4为专家类别
// DataTable dt = DBC.getDataTable(sql);
// cl.DataSource = dt;
// cl.DataTextField = "class";//绑定的字段名
// cl.DataValueField = "id";//绑定的值
// cl.DataBind();
// return dt;
//}
//protected void scfile_Click(object sender, EventArgs e)
//{
// msg.Text = "";
// if (!upfile.HasFile) { msg.Text = "请选择文件后上传"; return; }
// if (upfile.FileBytes.Length > 1024 * 1024)
// { msg.Text = "文件不能大于1M"; return; }
// string ext = upfile.FileName.Substring(upfile.FileName.Length - 3).ToLower();
// if (ext != "png" && ext != "jpg" && ext != "gif")
// {
// msg.Text = "文件格式只能是png或jpg或gif"; return;
// }
// string file = DateTime.Now.ToString("yyyMMddHHmmss.ss");
// string filename = Server.MapPath("../upload/") + file + "." + ext;
// upfile.SaveAs(filename);
// pic.Text = "/upload/" + file + "." + ext;
//}
protected void bc_Click(object sender, EventArgs e)
{
//foreach (Control ct in this.form1.Controls)//循环查询表单里面的子控件
//{
// if (ct.GetType().ToString().Equals("System.Web.UI.WebControls.CheckBox"))
// {
// CheckBox cb = (CheckBox)ct;
// if (cb.Checked == true)
// {
// stext+=(cb.Text + "<br/>");//这句换成取值
// }
// }
//}
///Response.Write(stext);
string classid = "0";
string cbtext1 = "";
string sql = "";
try { Convert.ToDateTime(faburiqi.Text); }
catch
{
msg.Text = "发布日期,时间格式不正确 ！";
return;
}
if (mingcheng.Text == "")
{
msg.Text = "政策名称，不能为空";
return;
}
if (wenhao.Text == "")
{
msg.Text = "政策文号，不能为空";
return;
}
if (fawendanwen.Text == "")
{
msg.Text = "发文单位，不能为空";
return;
}
if (buwensheng.Text == "")
{
msg.Text = "部委省级，不能为空";
return;
}
//if (cbtext1 == "")
//{
// msg.Text = "必须选择一个分类";
// return;
//}
//cbtext1 = cbtext1.Substring(0, cbtext1.Length - 1);
string cbtexthy = "";
for (int i = 0; i < hangyec.Items.Count; i++)
{
if (hangyec.Items[i].Selected == true)
{
//这个打勾的
cbtexthy += hangyec.Items[i].Value + ",";
//if (classid == "0")
//{
// classid = hangye.Items[i].Value;
//}
}
else
{
//这是没打的
}
}
string gongcheng = "";
for (int i = 0; i < gongchengc.Items.Count; i++)
{
if (gongchengc.Items[i].Selected == true)
{
//这个打勾的
gongcheng += gongchengc.Items[i].Value + ",";
//if (classid == "0")
//{
// classid = hangye.Items[i].Value;
//}
}
else
{
//这是没打的
}
}
string cengji = "";
for (int i = 0; i < cengjicb.Items.Count; i++)
{
if (cengjicb.Items[i].Selected == true)
{
//这个打勾的
cengji = cengjicb.Items[i].Value;
//if (classid == "0")
//{
// classid = hangye.Items[i].Value;
//}
}
else
{
//这是没打的
}
}
string hangye = "";
for (int i = 0; i < hangyecbl.Items.Count; i++)
{
if (hangyecbl.Items[i].Selected == true)
{
//这个打勾的
hangye += hangyecbl.Items[i].Value + ",";
//if (classid == "0")
//{
// classid = hangye.Items[i].Value;
//}
}
else
{
//这是没打的
}
}
//hangye = tbhangye.Text;
////hangye = hangyejs.Value;
if (hangye == "")
{
msg.Text = "必须选择一个或多个行业";
return;
}
if (id == 0)
{
//sql = "insert into zqhl_news([title],[content],classid,qz,pic,en,sel,writer,author,typename,cdate)values(";
//sql += "'" + Common.strFilter(title.Text) + "','" + Common.strFilter(content1.Text.Replace("&emsp ", " ")) + "'," + classid + "," + Common.strFilter(qz.Text);
//sql += ",'" + Common.strFilter(pic.Text) + "'," + ((en.Checked) ? "1" : "0") + "," + ((sel.Checked) ? "1" : "0") + ",'" + Common.strFilter(writer.Text) + "','" + Session["adminloginuser"] + "','" + cbtext1 + "','" + cdate.Text + "')";
sql = @"INSERT INTO [dbo].[zhengce]
([mingcheng] ,[wenhao] ,[faburiqi] ,[fawendanwen]
,[cengji] ,[buwensheng] ,[gongcheng] ,[lingyu]
,[yiju] ,[mubiao] ,[youxiaoqi] ,[hangye]
,[zhengceqw] ,[zcywdizhi] ,[state] ,[createdate]
,[userid],[caiji])
VALUES
('" + Common.strFilter(mingcheng.Text) + "','" + Common.strFilter(wenhao.Text) + "','" + Common.strFilter(faburiqi.Text) + "','" + Common.strFilter(fawendanwen.Text) + "','" +
Common.strFilter(cengji) + "','" + Common.strFilter(buwensheng.Text) + "','" + Common.strFilter(gongcheng) + "','" + Common.strFilter(cbtexthy) + "','" +
Common.strFilter(yiju.Text) + "','" + Common.strFilter(mubiao.Text) + "','" + Common.strFilter(youxiaoqi.Text) + "','" + Common.strFilter(hangye) + "','" +
Common.strFilter(content1.Text.Replace("&emsp ", " ")) + "','" + Common.strFilter(zcywdizhi.Text) + "',1,'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
+ "','" + Session["userid"] + "',0)";
//以下字段编辑时上传
//// ,[glchanneng] ,[gldiqu] ,[gldixiang]
// ,[zcshijian] ,[zcshuoming] ,[gmfangshi] ,[gmshuoming]
// ,[psfangshi] ,[psshuoming] ,[shenbaotj] ,[sbjttiaojian]
// ,[xzchanneng] ,[xzdiqu] ,[xzzhuti] ,[xzfashism]
//
}
else
{
//sql = "update zqhl_news set [title]='" + Common.strFilter(title.Text) + "',[content]='" + Common.strFilter(content1.Text.Replace("&emsp ", " ")) + "',classid=" + classid + ",qz=" + Common.strFilter(qz.Text);
//sql += ",pic='" + Common.strFilter(pic.Text) + "',en=" + ((en.Checked) ? "1" : "0") + ",sel=" + ((sel.Checked) ? "1" : "0") + ",writer='" + Common.strFilter(writer.Text) + "',typename='" + cbtext1 + "',cdate='" + cdate.Text + "' where id=" + id;
sql = @"update zhengce set [mingcheng]='" + Common.strFilter(mingcheng.Text) + "',[wenhao]='" + Common.strFilter(wenhao.Text) + "' ,[faburiqi]='" + Common.strFilter(faburiqi.Text) + "',[fawendanwen]='" + Common.strFilter(fawendanwen.Text)
+ "' ,[cengji] ='" + Common.strFilter(cengji) + "' ,[buwensheng] ='" + Common.strFilter(buwensheng.Text) + "' ,[gongcheng]='" + Common.strFilter(gongcheng) + "' ,[lingyu]='" + Common.strFilter(cbtexthy)
+ "' ,[yiju]='" + Common.strFilter(yiju.Text) + "' ,[mubiao]='" + Common.strFilter(mubiao.Text) + "' ,[youxiaoqi]='" + Common.strFilter(youxiaoqi.Text) + "' ,[hangye]='" + Common.strFilter(hangye)
+ "' ,[zhengceqw] ='" + Common.strFilter(content1.Text.Replace("&emsp ", " ")) + "' ,[zcywdizhi] ='" + Common.strFilter(zcywdizhi.Text) + "' ,[update]='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' where id=" + id + "";
}
int count = DBZhengce.getRowsCount(sql);
if (count > 0)
{
msg.Text = "保存成功";
}
else
{
msg.Text = "保存失败" + sql;
}
Response.Write("<script language=javascript >window.opener.location.reload('zhengce.aspx'); </script > ");
}
