protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//用户登录验证
pyrc.zoneNet login = new pyrc.zoneNet();
//login.tempsession();//测试用
login.loginCheck();
login.authority(1);
SqlConnection sqlconn = new SqlConnection();
sqlconn.ConnectionString = ConfigurationManager.ConnectionStrings["zoneNetConn"].ConnectionString;
//临时id=用户编号+时间,用于附件上传
Label1.Text = DateTime.Now.ToString("yyyyMMddHHmmss");
//问题类别列表
SqlDataAdapter sqldar = new SqlDataAdapter("select * from [optQuestion]", sqlconn);
DataSet Ds = new DataSet();
sqldar.Fill(Ds, "List");
B02.DataSource = Ds.Tables["List"].DefaultView;
B02.DataTextField = "Q01";
B02.DataValueField = "Q00";
sqlconn.Open();
B02.DataBind();
sqlconn.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//用户登录验证
pyrc.zoneNet login = new pyrc.zoneNet();
//login.tempsession();//测试用
login.loginCheck();
login.authority(4);
//Label1为隐藏控件，用于传值到upfile.aspx
Label1.Text = Request.QueryString["id"];
//加载数据
if (Request.QueryString["id"] != null)
{
int id = System.Int32.Parse(Request.QueryString["id"]);
int m = System.Int32.Parse(Request.QueryString["m"]);
if (m == 1)
{
Button1.Enabled = false; Button1.Visible = false; Button4.Visible = false; iframe1.Visible = false; exChange.Visible = false;
}
; //1：查看，0：编辑
SqlConnection sqlconn = new SqlConnection();
sqlconn.ConnectionString = ConfigurationManager.ConnectionStrings["zoneNetConn"].ConnectionString;
//问题类别列表
SqlDataAdapter sqldar = new SqlDataAdapter("select * from [optQuestion]", sqlconn);
DataSet Ds = new DataSet();
sqldar.Fill(Ds, "List");
B02.DataSource = Ds.Tables["List"].DefaultView;
B02.DataTextField = "Q01";
B02.DataValueField = "Q00";
sqlconn.Open();
B02.DataBind();
sqlconn.Close();
var cmd = new SqlCommand("SELECT * FROM TableApply a left join optHandleState b on a.B08=b.C00 left join optQuestion c on a.B02=c.Q00 left join TableUser d on a.B01=d.U00 where B00=" + id, sqlconn);
sqlconn.Open();
SqlDataReader read = cmd.ExecuteReader(CommandBehavior.CloseConnection);
if (read.Read())
{
U05.Text = read["U05"].ToString();
U04.Text = read["U04"].ToString();
U06.Text = read["U06"].ToString();
U07.Text = read["U07"].ToString();
U08.Text = read["U08"].ToString();
B02.SelectedValue = read["Q00"].ToString();
B03.Text = read["B03"].ToString();
B05.Text = read["B05"].ToString();
B04.InnerText = read["B04"].ToString();
B10.InnerText = read["B10"].ToString();
B12.InnerText = read["B12"].ToString();
}
read.Close();
//当前跟进
var cmd1 = new SqlCommand("SELECT * FROM TableApply a left join (select D01, D03 from TableHandleState where D00 in (select max(D00) mD00 from TableHandleState group by D01)) e on a.B00 = e.D01 left join TableUser b on e.D03=b.U00 where B00 = " + id, sqlconn);
sqlconn.Open();
read = cmd1.ExecuteReader(CommandBehavior.CloseConnection);
if (read.Read())
{
D03.Text = read["U04"].ToString();
}
read.Close();
zoneNet1.ConnectionString = ConfigurationManager.ConnectionStrings["zoneNetConn"].ConnectionString;
zoneNet1.SelectParameters.Clear();
zoneNet1.SelectCommand = "SELECT * FROM [dbo].[TableUpfile] where F01=@id and F06=1 and F07=0 order by F00 asc";
zoneNet1.SelectParameters.Add("id", System.TypeCode.Int32, id.ToString());
Repeater1.DataSourceID = "zoneNet1";
Repeater1.DataBind();
zoneNet2.ConnectionString = ConfigurationManager.ConnectionStrings["zoneNetConn"].ConnectionString;
zoneNet2.SelectParameters.Clear();
zoneNet2.SelectCommand = "SELECT * FROM [dbo].[TableUpfile] where F01=@id and F06=1 and F07=1 order by F00 asc";
zoneNet2.SelectParameters.Add("id", System.TypeCode.Int32, id.ToString());
Repeater2.DataSourceID = "zoneNet2";
Repeater2.DataBind();
zoneNet3.ConnectionString = ConfigurationManager.ConnectionStrings["zoneNetConn"].ConnectionString;
zoneNet3.SelectParameters.Clear();
zoneNet3.SelectCommand = "SELECT * FROM [dbo].[TableHandleState] a left join TableUser b on a.D02=b.U00 where D01=@id order by D00 asc";
zoneNet3.SelectParameters.Add("id", System.TypeCode.Int32, id.ToString());
Repeater3.DataSourceID = "zoneNet3";
Repeater3.DataBind();
//流转人列表
SqlDataAdapter sqldar1 = new SqlDataAdapter("select * from [TableUser] where (U16=2 or U16=3) and U17=1", sqlconn);//U16:1=园区，2=内部，3=管理员；U17:1=有效
DataSet Ds1 = new DataSet();
sqldar1.Fill(Ds1, "List");
U00.DataSource = Ds1.Tables["List"].DefaultView;
U00.DataTextField = "U04";
U00.DataValueField = "U00";
sqlconn.Open();
U00.DataBind();
sqlconn.Close();
}
}
}
/**************************** Inputs ****************************/
#if false
define IREM_INPUT_JOY_LOW(PL, STATE, WAY, B01, B02, B04, B08) \
PORT_BIT(0x0001, STATE, IPT_JOYSTICK_ ##B01) WAY PORT_PLAYER(PL) \
