using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using com.unicafe.ui;
using com.unicafe.common;
using com.unicafe.security;

namespace com.ascs.plp.publics
{
	/// <summary>
	/// ProductInfo 的摘要說明。
	/// </summary>
	public class ProductInfo : com.unicafe.ui.UnicafePage
	{
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.Label Label4;
		protected System.Web.UI.WebControls.Label Label5;
		protected System.Web.UI.WebControls.Label Label6;
		protected System.Data.SqlClient.SqlConnection sqlcn_plp;
		protected System.Data.SqlClient.SqlCommand cmd;
		protected System.Data.SqlClient.SqlDataReader dr;
		protected System.Web.UI.WebControls.Label Label7;
		protected System.Web.UI.WebControls.Label Label8;
		protected System.Web.UI.WebControls.Label Label9;
		protected System.Web.UI.WebControls.Label Label10;
		protected System.Web.UI.WebControls.Label Label11;
		protected System.Web.UI.WebControls.Label Label12;
		protected System.Web.UI.WebControls.Label Label13;
		protected string sql;
	
		/// *****************************************************************************
		/// BEIGIN
		/// <summary>
		/// 頁面加載事件處理函數
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		/// *****************************************************************************
		private void Page_Load(object sender, System.EventArgs e)
		{
			sqlcn_plp = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
			cmd = sqlcn_plp.CreateCommand();
			sql = "Select CPDM,SFSY,CPMC,CPJC,SCCS,CSBM,CPXH,CPGG,BXQ,YJLDWDM,CCJLDWDM,HSXS,SFTJ From CPJBXX Where CPDM = '" + this.Request.QueryString["CPDM"] + "'";
			cmd.CommandText = sql;
			sqlcn_plp.Open();
			try
			{
				dr = cmd.ExecuteReader();
				while (dr.Read())
				{
					Label1.Text = dr[0].ToString();
					Label2.Text = (dr[1].ToString()=="1"?"是":"否");
					Label3.Text = dr[2].ToString();
					Label4.Text = dr[3].ToString();
					Label5.Text = dr[4].ToString();
					Label6.Text = dr[5].ToString();
					Label7.Text = dr[6].ToString();
					Label8.Text = dr[7].ToString();
					Label9.Text = ((dr[8].ToString()=="")?("未設定"):(dr[8].ToString()+"個月"));
					Label10.Text = ((dr[9].ToString()=="")?("未設定"):(FindInfo.FindJldw(dr[9].ToString())));
					Label11.Text = ((dr[10].ToString()=="")?("未設定"):(FindInfo.FindJldw(dr[10].ToString())));
					Label12.Text = dr[11].ToString();
					Label13.Text = (dr[12].ToString()=="T"?"是":"否");
				}
			}
			catch(Exception ex)
			{
				if(sqlcn_plp.State.ToString() == "Open") sqlcn_plp.Close();
				LogService.Write ("Open(ProductInfo.aspx?CPDM="+this.Request.QueryString["CPDM"]);
				LogService.Write ("在根據產品代號打開產品詳細信息查詢窗口時發生錯誤。");
				LogService.Write (ex.Message);
			}
		}
		/// *****************************************************************************
		/// END
		/// *****************************************************************************


		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN：該調用是 ASP.NET Web 窗體設計器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
		/// 此方法的內容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.ID = "ProductInfo";
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
	}
}