using
?TestWeb.HR.BusinessLogicLayer;
using
?TestWeb.HR.DataAccessLayer;
public
?
partial
?
class
?HR_CompanyView?:?System.Web.UI.UserControl
...
{
????
protected
?
void
?Page_Load(
object
?sender,?EventArgs?e)
????
...
{
????????
if
?(
!
this
.IsPostBack)
????????
...
{
????????????GetAllCompanies();?
//
初試加載所有公司
????????}
}
????
/**/
///
?
<summary>
????
///
?返回所有公司
????
///
?
</summary>
????
private
?
void
?GetAllCompanies()
????
...
{
????????
try
????????
...
{
????????????List
<
Company
>
?companyList?
=
?
new
?List
<
Company
>
();
????????????companyList?
=
?Company.GetAllCompanies();
????????????
if
?(companyList?
!=
?
null
)
????????????
...
{
????????????????
this
.GridView1.DataSource?
=
?companyList;
????????????????
this
.GridView1.DataBind();
????????????}
????????}
????????
catch
?(Exception?ex)
????????
...
{
????????????ShowMessage.ErrorMessage(
this
.Page,?ex.Message);
????????}
????}
????
/**/
///
?
<summary>
????
///
?編輯公司
????
///
?
</summary>
????
///
?
<param?name="sender"></param>
????
///
?
<param?name="e"></param>
????
protected
?
void
?GridView1_RowEditing(
object
?sender,?GridViewEditEventArgs?e)
????
...
{
????????
this
.GridView1.EditIndex?
=
?e.NewEditIndex;
????????GetAllCompanies();
????}
????
/**/
///
?
<summary>
????
///
?取消編輯
????
///
?
</summary>
????
///
?
<param?name="sender"></param>
????
///
?
<param?name="e"></param>
????
protected
?
void
?GridView1_RowCancelingEdit(
object
?sender,?GridViewCancelEditEventArgs?e)
????
...
{
????????
this
.GridView1.EditIndex?
=
?
-
1
;
????????GetAllCompanies();
????}
????
/**/
///
?
<summary>
????
///
?更新公司
????
///
?
</summary>
????
///
?
<param?name="sender"></param>
????
///
?
<param?name="e"></param>
????
protected
?
void
?GridView1_RowUpdating(
object
?sender,?GridViewUpdateEventArgs?e)
????
...
{
????????GridViewRow?uprow?
=
?
this
.GridView1.Rows[e.RowIndex];
????????TextBox?text1?
=
?(TextBox)uprow.Cells[
0
].FindControl(
"
TextBox1
"
);
????????TextBox?text2?
=
?(TextBox)uprow.Cells[
0
].FindControl(
"
TextBox2
"
);
????????TextBox?text3?
=
?(TextBox)uprow.Cells[
0
].FindControl(
"
TextBox3
"
);
????????HyperLink?hlk?
=
?(HyperLink)uprow.Cells[
0
].FindControl(
"
HyperLink1
"
);
????????
int
?companyId?
=
?Convert.ToInt32(
this
.GridView1.DataKeys[e.RowIndex].Value);
????????
//
直接調(diào)用存儲(chǔ)過程進(jìn)行更新
????????
string
?connectionstring?
=
?ConfigurationManager.ConnectionStrings[
"
TESTDB_Database_Connection
"
].ConnectionString;
????????SqlCommand?upcmd?
=
?
new
?SqlCommand();
????????upcmd.CommandType?
=
?CommandType.StoredProcedure;
????????upcmd.CommandText?
=
?
"
UPCompany
"
;
????????upcmd.Parameters.Add(
"
@CompanyName
"
,?SqlDbType.VarChar,?
50
);
????????upcmd.Parameters[
"
@CompanyName
"
].Value?
=
?text1.Text.Trim();
????????upcmd.Parameters.Add(
"
@Phone
"
,?SqlDbType.VarChar,?
50
);
????????upcmd.Parameters[
"
@Phone
"
].Value?
=
?text2.Text.Trim();
????????upcmd.Parameters.Add(
"
@Fax
"
,?SqlDbType.VarChar,?
50
);
????????upcmd.Parameters[
"
@Fax
"
].Value?
=
?text3.Text.Trim();
????????upcmd.Parameters.Add(
"
@WebSite
"
,?SqlDbType.VarChar,?
50
);
????????upcmd.Parameters[
"
@WebSite
"
].Value?
=
?hlk.Text.Trim();
????????upcmd.Parameters.Add(
"
@CompanyId
"
,?SqlDbType.Int,?
4
);
????????upcmd.Parameters[
"
@CompanyId
"
].Value?
=
?companyId;
????????SqlConnection?con?
=
?
new
?SqlConnection(connectionstring);
????????upcmd.Connection?
=
?con;
????????con.Open();
????????upcmd.ExecuteNonQuery();
????????con.Close();
????????
this
.GridView1.EditIndex?
=
?
-
1
;
????????GetAllCompanies();
????}
????
/**/
///
?
<summary>
????
///
?刪除公司
????
///
?
</summary>
????
///
?
<param?name="sender"></param>
????
///
?
<param?name="e"></param>
????
protected
?
void
?GridView1_RowDeleting(
object
?sender,?GridViewDeleteEventArgs?e)
????
...
{
????????
int
?companyId?
=
?Convert.ToInt32(
this
.GridView1.DataKeys[e.RowIndex].Value);
????????
string
?connectionstring?
=
?ConfigurationManager.ConnectionStrings[
"
TESTDB_Database_Connection
"
].ConnectionString;
????????SqlCommand?delcmd?
=
?
new
?SqlCommand();
????????delcmd.CommandType?
=
?CommandType.StoredProcedure;
????????delcmd.CommandText?
=
?
"
HR_DeleteCompanyByCompanyId
"
;
????????delcmd.Parameters.Add(
"
@CompanyId
"
,?SqlDbType.Int,?
4
);
????????delcmd.Parameters[
"
@CompanyId
"
].Value?
=
?companyId;
????????SqlConnection?_Con?
=
?
new
?SqlConnection(connectionstring);
????????delcmd.Connection?
=
?_Con;
????????_Con.Open();
????????delcmd.ExecuteNonQuery();
????????_Con.Close();
????????GetAllCompanies();
????}
????
/**/
///
?
<summary>
????
///
?允許分頁
????
///
?
</summary>
????
///
?
<param?name="sender"></param>
????
///
?
<param?name="e"></param>
????
protected
?
void
?GridView1_PageIndexChanging(
object
?sender,?GridViewPageEventArgs?e)
????
...
{
????????
this
.GridView1.PageIndex?
=
?e.NewPageIndex;
????????GetAllCompanies();
????}
????
/**/
///
?
<summary>
????
///
?焦點(diǎn)行顏色變化
????
///
?
</summary>
????
///
?
<param?name="sender"></param>
????
///
?
<param?name="e"></param>
????
protected
?
void
?GridView1_RowDataBound(
object
?sender,?GridViewRowEventArgs?e)
????
...
{
????????
if
?(e.Row.RowType?
==
?DataControlRowType.DataRow)
????????
...
{
????????????
//
當(dāng)鼠標(biāo)放上去的時(shí)候?先保存當(dāng)前行的背景顏色?并給附一顏色?
????????????e.Row.Attributes.Add(
"
onmouseover
"
,?
"
currentcolor=this.style.backgroundColor;this.style.backgroundColor='yellow',this.style.fontWeight='';
"
);
????????????
//
當(dāng)鼠標(biāo)離開的時(shí)候?將背景顏色還原的以前的顏色?
????????????e.Row.Attributes.Add(
"
onmouseout
"
,?
"
this.style.backgroundColor=currentcolor,this.style.fontWeight='';
"
);
????????}
????????
//
單擊行改變行背景顏色?
????????
if
?(e.Row.RowType?
==
?DataControlRowType.DataRow)
????????
...
{
????????????e.Row.Attributes.Add(
"
onclick
"
,?
"
this.style.backgroundColor='#99cc00';?this.style.color='buttontext';this.style.cursor='default';
"
);
????????}
????}
????
/**/
///
?
<summary>
????
///
?根據(jù)ID獲取公司詳細(xì)信息
????
///
?
</summary>
????
///
?
<param?name="sender"></param>
????
///
?
<param?name="e"></param>
????
protected
?
void
?Button1_Click(
object
?sender,?EventArgs?e)
????
...
{
????????Response.Redirect(
"
~/CompanyDetails.aspx
"
);
????}
?
}
posted on 2006-10-30 14:44
圣域飛俠 閱讀(538)
評(píng)論(0) 編輯 收藏