using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
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 System.Data.SqlClient;
using OA.Components;
using OA.Components.DAL;
using OA.Components.DAL.Divan;
namespace OA.WebForms.Divan
{
/// <summary>
/// WebForm1 篕璶磞瓃
/// </summary>
public class DivanRequest : System.Web.UI.Page
{
#region 猔舱ン
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.Label Label13;
protected System.Web.UI.WebControls.Label Label3;
protected System.Web.UI.WebControls.Label Label5;
protected System.Web.UI.WebControls.Label Label4;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.Label Label15;
protected System.Web.UI.WebControls.CheckBox cbHas_audio;
protected System.Web.UI.WebControls.CheckBox cbHas_Videobit;
protected System.Web.UI.WebControls.CheckBox cbState;
protected System.Web.UI.WebControls.Label lbState;
protected System.Web.UI.WebControls.Label Label6;
protected System.Web.UI.WebControls.Label Label9;
protected System.Web.UI.WebControls.Label Label10;
protected System.Web.UI.WebControls.Label lbList;
protected System.Web.UI.WebControls.DataGrid dgShowDetailes;
protected System.Web.UI.WebControls.DropDownList ddlExigency_grade;
protected System.Web.UI.WebControls.Button btnSibmit;
protected System.Web.UI.WebControls.Button btnCancel;
protected System.Web.UI.WebControls.Label Label12;
protected System.Web.UI.HtmlControls.HtmlInputText txtDianNo;
protected System.Web.UI.HtmlControls.HtmlInputText txtName;
protected System.Web.UI.HtmlControls.HtmlInputText txtDept;
protected System.Web.UI.HtmlControls.HtmlInputText txtUser_no;
protected System.Web.UI.HtmlControls.HtmlInputText txtSize;
protected System.Web.UI.HtmlControls.HtmlInputText txtCount;
protected System.Web.UI.HtmlControls.HtmlInputText txt_Tel_1;
protected System.Web.UI.HtmlControls.HtmlInputText txtAddress;
protected System.Web.UI.HtmlControls.HtmlInputText txt_Remark;
protected System.Web.UI.HtmlControls.HtmlInputText TxtSubject;
protected System.Web.UI.HtmlControls.HtmlInputText txtDivanDept;
protected Billy.CalendarInput cdlBegin_Date;
protected Billy.CalendarInput cdlEnd_Date;
protected System.Web.UI.HtmlControls.HtmlInputButton btnFlag;
private DataTable dtList;
private WindowSecurity userSecurity;
//private string CurrentUser;
private string windowNo;
#endregion
#region 妮┦
private int getDivanID
{
get
{
return Convert.ToInt32(ViewState["getDivanID"]);
}
set
{
ViewState["getDivanID"] = value;
}
}
private string CurrentUser
{
get
{
return ViewState["CurrentUser"].ToString();
}
set
{
ViewState["CurrentUser"] = value;
}
}
private string UserName
{
get
{
return ViewState["UserName"].ToString();
}
set
{
ViewState["UserName"] = value;
}
}
private string UserDept
{
get
{
return ViewState["UserDept"].ToString();
}
set
{
ViewState["UserDept"] = value;
}
}
//玂穦某篈
private int State
{
get
{
return Convert.ToInt32(ViewState["State"].ToString());
}
set
{
ViewState["State"] = value;
}
}
//玂跌繵篈
private int VideoState
{
get
{
return Convert.ToInt32(ViewState["VideoState"].ToString());
}
set
{
ViewState["VideoState"] = value;
}
}
//玂繵篈
private int AudioState
{
get
{
return Convert.ToInt32(ViewState["AudioState"].ToString());
}
set
{
ViewState["AudioState"] = value;
}
}
#endregion
#region 更ㄆン
private void Page_Load(object sender, System.EventArgs e)
{
OA.Components.Common.CheckUser();
this.CurrentUser = OA.Components.Common.CurrentUser;
this.windowNo = OA.Window.CompanySetting;
userSecurity = new WindowSecurity(this.CurrentUser, this.windowNo);
//礚ヴ舦
if(!userSecurity.AnySecurity)
{
OA.Components.Common.Alert("眤⊿Τ秈セ舦");
Response.End();
}
if(!this.IsPostBack)
{
this.getDivanID = Convert.ToInt32(this.Request.QueryString["ID"]);
FillData();
}
}
#endregion
#region 浪琩ゅセ琌
private bool CheckData()
{
bool status = false;
if(this.TxtSubject.Value =="")
{
OA.Components.Common.Alert("穦某肈ぃ");
return false;
}
if(this.txtDivanDept.Value =="")
{
OA.Components.Common.Alert("籔穦虫ぃ");
return false;
}
if(this.cdlBegin_Date.Text=="")
{
OA.Components.Common.Alert("秨﹍ら戳ぃ");
return false;
}
if(this.cdlEnd_Date.Text=="")
{
OA.Components.Common.Alert("挡ら戳ぃ");
return false;
}
return status;
}
#endregion
#region 睲ゅセ
private void ClearData()
{
this.TxtSubject.Value ="";
this.txtDivanDept.Value ="";
this.cdlBegin_Date.Text ="";
this.cdlEnd_Date.Text ="";
this.ddlExigency_grade.SelectedIndex=0;
}
#endregion
#region 眔场㎝﹎
private void GetUserNameAndDept()
{
this.CurrentUser = OA.Components.Common.CurrentUser;
dtList = DivanClass.GetUserDept(CurrentUser);
DataView dv = dtList.Copy().DefaultView;
if(dv.Count>0)
{
this.UserName = dv[0]["user_name"].ToString();
this.UserDept = dv[0]["dept_nm"].ToString();
}
}
#endregion
#region 恶计沮呼絬
private void FillData()
{
dtList = DivanClass.DivanShowDetailes(this.getDivanID);
DataView dv = dtList.Copy().DefaultView;
if(dv.Count>1)
{
this.txtDianNo.Value = dv[0]["divan_no"].ToString();
this.txtName.Value = dv[0]["divan_name"].ToString();
this.txtDept.Value = dv[0]["owner_dept_no"].ToString();
this.txtUser_no.Value = dv[0]["user_no"].ToString();
this.txtSize.Value = dv[0]["divan_size"].ToString();
this.txtCount.Value = dv[0]["lodge_amount"].ToString();
this.VideoState = Convert.ToInt32(dv[0]["has_video"]);
this.AudioState = Convert.ToInt32(dv[0]["has_audio"]);
this.State = Convert.ToInt32(dv[0]["state"].ToString());
if(VideoState ==1)
{
this.cbHas_Videobit.Checked = true;
}
else
{
this.cbHas_Videobit.Checked = false;
}
if(this.AudioState ==1)
{
this.cbHas_audio.Checked = true;
}
else
{
this.cbHas_audio.Checked = false;
}
if(this.State ==3)
{
this.cbState.Checked = true;
}
if(this.State ==2)
{
this.cbState.Checked = true;
}
//if(this.State ==1)
//{
// this.lbState.Text = "赣穦某礚猭ㄏノ";
//}
this.txt_Tel_1.Value = dv[0]["Tel_1"].ToString()+","+dv[0]["Tel_2"].ToString()+","+dv[0]["Tel_3"].ToString();
this.txtAddress.Value = dv[0]["address"].ToString();
this.txt_Remark.Value = dv[0]["divan_description"].ToString();
this.dgShowDetailes.DataSource = dtList;
this.dgShowDetailes.DataBind();
}
else
{
this.txtDianNo.Value = dv[0]["divan_no"].ToString();
this.txtName.Value = dv[0]["divan_name"].ToString();
this.txtDept.Value = dv[0]["owner_dept_no"].ToString();
this.txtUser_no.Value = dv[0]["user_no"].ToString();
this.txtSize.Value = dv[0]["divan_size"].ToString();
this.txtCount.Value = dv[0]["lodge_amount"].ToString();
this.VideoState = Convert.ToInt32(dv[0]["has_video"]);
this.AudioState = Convert.ToInt32(dv[0]["has_audio"]);
this.State = Convert.ToInt32(dv[0]["state"].ToString());
if(VideoState ==1)
{
this.cbHas_Videobit.Checked = true;
}
else
{
this.cbHas_Videobit.Checked = false;
}
if(this.AudioState ==1)
{
this.cbHas_audio.Checked = true;
}
else
{
this.cbHas_audio.Checked = false;
}
if(this.State ==3)
{
this.cbState.Checked = true;
}
if(this.State ==2)
{
this.cbState.Checked = true;
}
//if(this.State ==1)
//{
// this.lbState.Text = "赣穦某礚猭ㄏノ";
//}
this.txt_Tel_1.Value = dv[0]["Tel_1"].ToString()+","+dv[0]["Tel_2"].ToString()+","+dv[0]["Tel_3"].ToString();
this.txtAddress.Value = dv[0]["address"].ToString();
this.txt_Remark.Value = dv[0]["divan_description"].ToString();
this.lbList.Visible = false;
}
}
#endregion
#region 喷靡赣丁琿琌Τビ叫
#endregion
#region 玂计沮よ猭
private void SavaData()
{
GetUserNameAndDept();//眔ノめ闽戈
//bool status ; //眔確祅癘丁
//status = Componts.DivanClass.CheckApplyData(this.getDivanID,this.cdlBegin_Date.Text,this.cdlEnd_Date.Text);
if(this.State ==1)
{
OA.Components.Common.Alert("赣穦某既礚猭ㄏノ叫ぃ璶ビ叫赣穦某!");
return;
}
if(getDivanID.ToString()=="0")
{
OA.Components.Common.Alert("礚把计礚舦秈セ");
return;
}
try
{
//this.btnFlag.Attributes.Add("onclick","if(!comfirm('祅癘ㄏノい,琌膥尿ビ叫赣穦某')) return false;");
//if(status == false)
//{
// this.Response.Write("<script>!confirm('祅癘ㄏノい,琌膥尿ビ叫赣穦某')</script>");
//}
SqlConnection sqlConn = new SqlConnection(OA.Components.Common.DbConnectionString);
SqlCommand sqlComm = sqlConn.CreateCommand();
sqlComm.CommandType = CommandType.StoredProcedure;
sqlComm.CommandText = "Pr_Divan_InsertDivanApply";
sqlConn.Open();
//础眖把计
sqlComm.Parameters.Add("@ID",SqlDbType.Int);
sqlComm.Parameters.Add("@Subject",SqlDbType.VarChar,60);
sqlComm.Parameters.Add("@Attend_dept",SqlDbType.VarChar,300);
sqlComm.Parameters.Add("@Begin_date",SqlDbType.DateTime);
sqlComm.Parameters.Add("@End_date",SqlDbType.DateTime);
sqlComm.Parameters.Add("@Exigency_grade",SqlDbType.Char,1);
sqlComm.Parameters.Add("@apply_user",SqlDbType.VarChar,20);
sqlComm.Parameters.Add("@user_name",SqlDbType.VarChar,12);
sqlComm.Parameters.Add("@user_dept",SqlDbType.VarChar,100);
sqlComm.Parameters["@ID"].Value = this.getDivanID;
sqlComm.Parameters["@Subject"].Value = this.TxtSubject.Value;
sqlComm.Parameters["@Attend_dept"].Value = this.txtDivanDept.Value;
sqlComm.Parameters["@Begin_date"].Value = this.cdlBegin_Date.Text;
sqlComm.Parameters["@End_date"].Value = this.cdlEnd_Date.Text;
sqlComm.Parameters["@Exigency_grade"].Value = this.ddlExigency_grade.SelectedIndex;
sqlComm.Parameters["@apply_user"].Value = this.CurrentUser ;
sqlComm.Parameters["@user_name"].Value = this.UserName;
sqlComm.Parameters["@user_dept"].Value = this.UserDept;
sqlComm.ExecuteNonQuery();
sqlConn.Close();
ClearData();
}
catch(Exception ee)
{
OA.Components.Common.Alert(ee.Message);
}
}
#endregion
#region Web Form 砞璸ㄣ玻ネ祘Α絏
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: ASP.NET Web Form 砞璸ㄣ┮惠㊣
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 砞璸ㄣや穿┮ゲ斗よ猭 - 叫づㄏノ祘Α絏絪胯竟э
/// 硂よ猭ず甧
/// </summary>
private void InitializeComponent()
{
this.btnSibmit.Click += new System.EventHandler(this.btnSibmit_Click);
this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
#region 矗ユ秙ㄆン
private void btnSibmit_Click(object sender, System.EventArgs e)
{
if (!CheckData())
{
SavaData(); //玂计沮
FillData();
}
}
#endregion
#region 闽超怠
private void btnCancel_Click(object sender, System.EventArgs e)
{
Response.Write("<script>window.close();</script>");
}
#endregion
}
}