using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.UI.WebControls;
using System.Web;
using System.Web.UI;
using System.Text;
using System.IO;

namespace AjaxSimple.Business
{
	/// <summary>
	/// jobs表操作邏輯
	/// </summary>
	public class EmployeesDesc
	{
		private SqlCommand cmd = null;
		private SqlConnection cn = null;

		public EmployeesDesc()
		{
			
		}	


		#region 模糊查詢
		/// <summary>
		/// 模糊查詢 
		/// </summary>
		/// <param name="desc">工作內(nèi)容</param>
		/// <returns>dr結(jié)果集</returns>
		[Ajax.AjaxMethod]
		public string GetEmployeesDesc(string desc)
		{
			cn = new SqlConnection(ConfigurationSettings.AppSettings["strconn"]);
			if(desc == "" || desc == null)
			{
				cmd = new SqlCommand("SELECT * FROM jobs", cn);
			}
			else
			{
				cmd = new SqlCommand("SELECT * FROM jobs WHERE (CHARINDEX(@job_desc, job_desc) > 0)", cn);
				cmd.Parameters.Add(new SqlParameter("@job_desc", SqlDbType.VarChar));
				cmd.Parameters["@job_desc"].Value = desc;
			}

			try
			{
				cn.Open();
				SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
				DataGrid dg = BuiderDataGrid(dr);
				//構(gòu)造htw
				StringBuilder sb = new StringBuilder(dg.ToString());
				StringWriter tw = new StringWriter(sb);
				HtmlTextWriter htw = new HtmlTextWriter(tw);
				dg.RenderControl(htw);
				dr.Close();

				return sb.ToString();
			}
			catch(Exception ex)
			{
				System.Web.HttpContext.Current.Response.Write("<script>alert('" + ex.Message + "');</script>");
				return null;
			}
		}
		#endregion

		#region 添加數(shù)據(jù)
		/// <summary>
		/// 添加數(shù)據(jù)
		/// </summary>
		/// <param name="desc">工作內(nèi)容</param>
		/// <param name="max_lvl">最大工作權(quán)限</param>
		/// <param name="min_lvl">最小工作權(quán)限</param>
		/// <returns>bool</returns>
		[Ajax.AjaxMethod]
		public bool AddEmployeesDesc(string desc, int max_lvl, int min_lvl)
		{
			cn = new SqlConnection(ConfigurationSettings.AppSettings["strconn"]);
			cmd = new SqlCommand("insert into jobs(job_desc, max_lvl, min_lvl) values(@job_desc, @max_lvl, @min_lvl)", cn);
            cmd.Parameters.Add(new SqlParameter("@job_desc", desc));
			cmd.Parameters.Add(new SqlParameter("@max_lvl", max_lvl));
			cmd.Parameters.Add(new SqlParameter("@min_lvl", min_lvl));
			
			try
			{
				cn.Open();
				if(cmd.ExecuteNonQuery() == 1)
				{
					Cls();
					return true;
				}
			}
			catch(Exception ex)
			{
				System.Web.HttpContext.Current.Response.Write("<script>alert('" + ex.Message + "');</script>");
				Cls();

				return false;
			}
			
			return false;
		}
		#endregion

		#region 刪除數(shù)據(jù)
		/// <summary>
		/// 刪除數(shù)據(jù)
		/// </summary>
		/// <param name="job_id">編號</param>
		/// <returns>bool</returns>
		[Ajax.AjaxMethod]
		public bool DelEmployeesDesc(int id)
		{
			cn = new SqlConnection(ConfigurationSettings.AppSettings["strconn"]);
			cmd = new SqlCommand("delete from jobs where job_id = @job_id", cn);
			cmd.Parameters.Add(new SqlParameter("@job_id", id));
			
			try
			{
				cn.Open();
				if(cmd.ExecuteNonQuery() == 1)
				{
					Cls();
					return true;
				}
			}
			catch(Exception ex)
			{
				System.Web.HttpContext.Current.Response.Write("<script>alert('" + ex.Message + "');</script>");
				Cls();

				return false;
			}
			
			return false;
		}
		#endregion

		#region 釋放資源
		/// <summary>
		/// 釋放資源
		/// </summary>
		private void Cls()
		{
			cmd.Parameters.Clear();
			cmd.Dispose();
			cn.Close();
		}
		#endregion

		#region 構(gòu)造DataGrid
		/// <summary>
		/// 構(gòu)造DataGrid
		/// </summary>
		/// <param name="dr"></param>
		/// <returns></returns>
		private DataGrid BuiderDataGrid(SqlDataReader dr)
		{
			DataGrid dg = new DataGrid();
			dg.AutoGenerateColumns = true;
			dg.DataSource = dr;
			dg.BorderColor = System.Drawing.Color.Blue;
			dg.BorderStyle = BorderStyle.None;
            dg.BackColor = System.Drawing.Color.White;
			dg.Attributes.Add("BorderWidth", "1px");
			dg.Attributes.Add("CellPadding", "1");
			dg.Attributes.Add("Width", "536px");
			dg.DataBind();

			return dg;
		}
		#endregion
	}
}//--end--