DataGrid 上修改數據-白红宇

DataGrid 上修改數據

阅读量：5068 次

发布时间：2019-06-12

本文共 29195 字，大约阅读时间需要 97 分钟。

<%@ Page language="c#" Codebehind="pubScoreArea_View.aspx.cs" AutoEventWireup="false" Inherits="KPIS.Scoring.pubScoreArea_View" %>

<%@ Register TagPrefix="iewc" Namespace="Microsoft.Web.UI.WebControls" Assembly="Microsoft.Web.UI.WebControls" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >

<HTML>

<HEAD>

<title>pubScoreArea_View</title>

var bgColorNotSelect = "#ffffff";

var bgColorSelected = "#fceade";

var selectedLine = null;

function SelectLine(trID){

if (document.getElementById(trID) !=null){

if (selectedLine==trID){

document.getElementById(trID).style.backgroundColor = bgColorNotSelect;

} else {

if (selectedLine !=null){

document.getElementById(selectedLine).style.background = bgColorNotSelect;

}

document.getElementById(trID).style.backgroundColor = bgColorSelected;

}

selectedLine=trID;

}

</script>

</HEAD>

<tr>

<td>

<TR>

</TR>

</TABLE>

</td>

</tr>

<tr>

<iewc:ToolbarButton Text="Add" ID="ibtnAdd" ImageUrl="../images/NewP.gif" DefaultStyle="border:0px; padding: 2px 0px 2px 20px;"

HoverStyle="cursor:hand; padding: 2px 0px 2px 20px;" SelectedStyle="border: 0px; padding: 2px 0px 2px 18px;"></iewc:ToolbarButton>

<iewc:ToolbarButton Text="Refresh" ID="ibtnRefresh" ImageUrl="../images/Refresh.gif" DefaultStyle="border:0px; padding: 2px 0px 2px 20px;"

HoverStyle="cursor:hand; padding: 2px 0px 2px 20px;" SelectedStyle="border: 0px; padding: 2px 0px 2px 18px;"></iewc:ToolbarButton>

<iewc:ToolbarButton Text="Back" ID="ibtnBack" ImageUrl="../images/back.gif" DefaultStyle="border:0px; padding: 2px 0px 2px 20px;"

HoverStyle="cursor:hand; padding: 2px 0px 2px 20px;" SelectedStyle="border: 0px; padding: 2px 0px 2px 18px;"></iewc:ToolbarButton>

</iewc:toolbar></td>

</tr>

<tr>

<tr>

<td style="WIDTH: 76px; HEIGHT: 3px"><font color="red">Indicator*:</font></td>

<td style="WIDTH: 69px; HEIGHT: 3px"><font color="red">Weight(%)*:</font></td>

<td style="WIDTH: 65px; HEIGHT: 3px">Level:</td>

</tr>

<tr>

<td style="WIDTH: 76px"><font color="red">Scoring By*:</font></td>

<td>Remark</td>

</tr>

<tr>

<td>Valid date<font class="Fred2">*</font>:</td>

<td>Invalid date<font class="Fred2">*</font>:</td>

</tr>

<tr>

<asp:button id="btnCancel" CssClass="btn70" Runat="server" Text="Cancel"></asp:button></td>

</tr>

</table>

</span>

</td>

</tr>

<TR>

<asp:ListItem Value="(all*)" Selected="True">(all*)</asp:ListItem>

<asp:ListItem Value="irName">Indicator</asp:ListItem>

<asp:ListItem Value="Level">Level</asp:ListItem>

</asp:dropdownlist><asp:textbox id="tbQuery" runat="server" Width="136px"></asp:textbox><asp:button id="btnQuery" CssClass="search2" Runat="server" Text="Query"></asp:button></td>

</TR>

<TR>

<TD>

<tr>

<td>

<div>Record Total:

<asp:label id="LRecords" runat="server" CssClass="fred" Width="20px"></asp:label>Page

Current:

<asp:label id="LPage" runat="server" CssClass="fred" Width="10px"></asp:label>/

<asp:label id="LPages" runat="server" CssClass="fred" Width="10px"></asp:label>Page

</div>

</td>

</tr>

</table>

<asp:datagrid id="dgScoreArea" runat="server" ItemStyle-Font-Name="Arial" ItemStyle-Font-Size="9pt"

HeaderStyle-Font-Name="Arial" HeaderStyle-Font-Size="10pt" width="100%" DataKeyField="saID"

AutoGenerateColumns="False" BorderWidth="1px" BorderColor="#6F9CC3" AllowPaging="True" PageSize="25"

AllowSorting="True">

<asp:BoundColumn Visible="False" DataField="saID"></asp:BoundColumn>

<asp:BoundColumn DataField="irMName" SortExpression="irMName" ReadOnly="True" HeaderText="Indicator"></asp:BoundColumn>

<asp:TemplateColumn SortExpression="Weight" HeaderText="Weight(%)">

<asp:Label Runat="server" text='<%# Convert.ToString(Convert.ToDouble(DataBinder.Eval(Container.DataItem, "Weight").ToString())*100)+"%" %>' ID=Label2>

</asp:Label>

</ItemTemplate>

<asp:TextBox Runat="server" ID="DGtbWeight" Text='<%# Convert.ToDouble(DataBinder.Eval(Container.DataItem, "Weight").ToString())*100 %>'>

</asp:TextBox>

</EditItemTemplate>

</asp:TemplateColumn>

<asp:TemplateColumn SortExpression="Level" HeaderText="Level">

<asp:Label Runat=server text='<%# DataBinder.Eval(Container.DataItem, "Level").ToString() %>' ID="Label3">

</asp:Label>

</ItemTemplate>

<asp:DropDownList Runat="server" ID="DGddlLevel" DataSource='<%# GetData(2) %>' SelectedIndex='<%# GetIndex(2,DataBinder.Eval(Container.DataItem, "Level").ToString()) %>'>

</asp:DropDownList>

</EditItemTemplate>

</asp:TemplateColumn>

<asp:TemplateColumn SortExpression="ScoringBy" HeaderText="Scoring By">

<asp:Label Runat=server text='<%# DataBinder.Eval(Container.DataItem, "mScroingBy").ToString() %>' ID="Label4">

</asp:Label>

</ItemTemplate>

<asp:DropDownList Runat="server" ID="DGddlScoringBy" DataSource='<%# GetData(3) %>' SelectedIndex='<%# GetIndex(3,DataBinder.Eval(Container.DataItem, "ScoringBy").ToString()) %>'>

</asp:DropDownList>

</EditItemTemplate>

</asp:TemplateColumn>

<asp:TemplateColumn SortExpression="showSort" HeaderText="Show Sort">

<asp:Label Runat="server" text='<%# DataBinder.Eval(Container.DataItem, "showSort").ToString() %>' ID="Label1">

</asp:Label>

</ItemTemplate>

<asp:TextBox Runat="server" ID="DGtbshowSort" Text='<%# DataBinder.Eval(Container.DataItem, "showSort").ToString() %>'>

</asp:TextBox>

</EditItemTemplate>

</asp:TemplateColumn>

<asp:TemplateColumn SortExpression="ValidDate" HeaderText="ValidDate">

<asp:Label id=Label6 Runat="server" text='<%# String.Format("{0:yyyy-MM-dd}",DataBinder.Eval(Container.DataItem, "ValidDate")) %>'>

</asp:Label>

</ItemTemplate>

<asp:TextBox id=tbValidDate Runat="server" οnfοcus="setdate(this);" Text='<%# String.Format("{0:yyyy-MM-dd}",DataBinder.Eval(Container.DataItem, "ValidDate")) %>'>

</asp:TextBox>

</EditItemTemplate>

</asp:TemplateColumn>

<asp:TemplateColumn SortExpression="InvalidDate" HeaderText="InvalidDate">

<asp:Label Runat="server" text='<%# String.Format("{0:yyyy-MM-dd}",DataBinder.Eval(Container.DataItem, "InvalidDate")) %>' ID="Label7">

</asp:Label>

</ItemTemplate>

<asp:TextBox Runat="server" ID="tbInvalidDate" οnfοcus="setdate(this);" Text='<%# String.Format("{0:yyyy-MM-dd}",DataBinder.Eval(Container.DataItem, "InvalidDate")) %>'>

</asp:TextBox>

</EditItemTemplate>

</asp:TemplateColumn>

<asp:BoundColumn Visible="False" DataField="ValidDate" SortExpression="ValidDate" HeaderText="ValidDate"

DataFormatString="{0:yyyy-MM-dd}"></asp:BoundColumn>

<asp:BoundColumn Visible="False" DataField="InvalidDate" SortExpression="InvalidDate" HeaderText="InvalidDate"

DataFormatString="{0:yyyy-MM-dd}"></asp:BoundColumn>

<asp:TemplateColumn SortExpression="Remark" HeaderText="Remark">

<asp:Label Runat="server" text='<%# DataBinder.Eval(Container.DataItem, "Remark").ToString() %>' ID="Label5">

</asp:Label>

</ItemTemplate>

<asp:TextBox Runat="server" ID="DGtbRemark" Text='<%# DataBinder.Eval(Container.DataItem, "Remark").ToString() %>'>

</asp:TextBox>

</EditItemTemplate>

</asp:TemplateColumn>

<asp:TemplateColumn>

<asp:HyperLink id=Select runat="server" Text="Show Detail" NavigateUrl='<%# "pubScoreArea_View.aspx?F_SysCode=" + Request["F_SysCode"] + "&saID=" + DataBinder.Eval(Container.DataItem, "saID") + "&irMID=" + DataBinder.Eval(Container.DataItem, "irMID") + "&pageNO=" + dgScoreArea.CurrentPageIndex %>'>Show Detail</asp:HyperLink>

</ItemTemplate>

</asp:TemplateColumn>

<asp:TemplateColumn>

<asp:LinkButton id="lkSetDetail" Runat="server" Text="Set Detail" CommandName="Detail"></asp:LinkButton>

</ItemTemplate>

</asp:TemplateColumn>

<asp:EditCommandColumn ButtonType="LinkButton" UpdateText="Update" CancelText="Cancel" EditText="Edit">

</asp:EditCommandColumn>

<asp:TemplateColumn>

<asp:LinkButton id="lkDelete" runat="server" Text="Delete" CommandName="Delete"></asp:LinkButton>

</ItemTemplate>

</asp:TemplateColumn>

</Columns>

<PagerStyle NextPageText="Next" Font-Size="10pt" Font-Names="Arial" PrevPageText="Previous"

Position="TopAndBottom"></PagerStyle>

</asp:datagrid></TD>

</TR>

<TR>

<TD>

<asp:label id="lbDetail" runat="server" CssClass="fred2"></asp:label>

</TD>

</TR>

</table>

</form>

</body>

</HTML>

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;

namespace KPIS.Scoring

{

/// <summary>

/// pubScoreArea_View 的摘要描述。

/// </summary>

public class pubScoreArea_View : System.Web.UI.Page {

protected System.Web.UI.WebControls.Label lbUseInfo;

protected Microsoft.Web.UI.WebControls.Toolbar Toolbar1;

protected System.Web.UI.WebControls.DropDownList ddlQuery;

protected System.Web.UI.WebControls.TextBox tbQuery;

protected System.Web.UI.WebControls.Button btnQuery;

protected System.Web.UI.WebControls.Label LRecords;

protected System.Web.UI.WebControls.Label LPage;

protected System.Web.UI.WebControls.Label LPages;

protected System.Web.UI.WebControls.DataGrid dgScoreArea;

protected System.Web.UI.HtmlControls.HtmlGenericControl span_Header;

protected System.Web.UI.WebControls.DropDownList ddlIndicator;

protected System.Web.UI.WebControls.TextBox tbWeight;

protected System.Web.UI.WebControls.DropDownList ddlLevel;

protected System.Web.UI.WebControls.DropDownList ddlScoringBy;

protected System.Web.UI.WebControls.TextBox tbshowSort;

protected System.Web.UI.WebControls.Button btnSave;

protected System.Web.UI.WebControls.Button btnCancel;

protected System.Web.UI.WebControls.TextBox tbRemark;

protected System.Web.UI.WebControls.TextBox tbvalid;

protected System.Web.UI.WebControls.TextBox tbinvalid;

protected System.Web.UI.WebControls.Label lbDetail;

#region Web Form 設計工具產生的程式碼

override protected void OnInit(EventArgs e) {

// CODEGEN: 此為 ASP.NET Web Form 設計工具所需的呼叫。

InitializeComponent();

base.OnInit(e);

}

/// <summary>

/// 此為設計工具支援所必須的方法 - 請勿使用程式碼編輯器修改

/// 這個方法的內容。

/// </summary>

private void InitializeComponent() {

this.Toolbar1.ButtonClick += new System.EventHandler(this.Toolbar1_ButtonClick);

this.btnSave.Click += new System.EventHandler(this.btnSave_Click);

this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);

this.btnQuery.Click += new System.EventHandler(this.btnQuery_Click);

this.dgScoreArea.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgScoreArea_ItemCommand);

this.dgScoreArea.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.dgScoreArea_PageIndexChanged);

this.dgScoreArea.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgScoreArea_CancelCommand);

this.dgScoreArea.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgScoreArea_EditCommand);

this.dgScoreArea.SortCommand += new System.Web.UI.WebControls.DataGridSortCommandEventHandler(this.dgScoreArea_SortCommand);

this.dgScoreArea.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgScoreArea_UpdateCommand);

this.dgScoreArea.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgScoreArea_DeleteCommand);

this.dgScoreArea.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.dgScoreArea_ItemDataBound);

this.Load += new System.EventHandler(this.Page_Load);

}

#endregion

CommClass.PubFunction func = new CommClass.PubFunction();

public int GetIndex(int Index, string category) {

ArrayList arr = new ArrayList();

int i = 0;

DataSet mydataset = new DataSet();

DataTable mydatatable = new DataTable();

switch (Index){

case 1: // Indicator

mydataset=func.GetDataTable("Select irMID, case when '"+ Session["Language"] +"' = 'Chinese' then irNameCH else irNameEN end as irName from pubIndicatorBase order by showSort");

break;

case 2: // Level

mydataset=func.GetDataTable("select Item, Remark from pubParameter where Category='productLevel' order by Remark ");

arr.Add("ALL");

break;

case 3: // ScroingBY

mydataset=func.GetDataTable("select Item, Remark from pubParameter where Category='ScoringBy' order by Remark");

break;

}

mydatatable=mydataset.Tables[0];

Hashtable statusindex = new Hashtable();

while (i < mydatatable.Rows.Count) {

statusindex[mydatatable.Rows[i][0].ToString()] = i;

i += 1;

}

if (!((statusindex[category] == null))) {

return ((int)(statusindex[category]));

} else {

return 0;

}

public ArrayList GetData(int Index) {

ArrayList arr = new ArrayList();

int i = 0;

DataSet mydataset = new DataSet();

DataTable mydatatable = new DataTable();

switch (Index){

case 1: // Indicator

mydataset=func.GetDataTable("Select irMID, case when '"+ Session["Language"] +"' = 'Chinese' then irNameCH else irNameEN end as irName from pubIndicatorBase order by showSort");

break;

case 2: // Level

mydataset=func.GetDataTable("select Item, Remark from pubParameter where Category='productLevel' order by Remark ");

arr.Add("ALL");

break;

case 3: // ScroingBY

mydataset=func.GetDataTable("select Item, Remark from pubParameter where Category='ScoringBy' order by Remark");

break;

}

mydatatable=mydataset.Tables[0];

while (i < mydatatable.Rows.Count) {

arr.Add(mydatatable.Rows[i][0].ToString());

i += 1;

}

return arr;

}

void dgbind()

{

DataSet ds;

//綁定數據, 并且按照指定條件顯示出來

if ((IsPostBack==true) && (tbQuery.Text!=""))

{

ds=func.GetDataTable("Select *, case when ScoringBy='A' then 'Area' when ScoringBy='R' then 'Ranking' else 'Other' end as mScroingBy, "+

" case when '"+ Session["Language"] +"' = 'Chinese' then b.irMNameCH else b.irMNameEN end as irMName "+

" from pubScoreAreaM as a left join pubIndicatorMain as b on a.irMID =b.irMID where b.irMID in (select irMID from pubIndicatorbase where irID in (" +func.GetIndicatorID(Convert.ToInt32(Session["uID"]),"All")+")) and ("+getcond()+") ");

}

else

{

ds=func.GetDataTable("Select *, case when ScoringBy='A' then 'Area' when ScoringBy='R' then 'Ranking' else 'Other' end as mScroingBy, "+

" case when '"+ Session["Language"] +"' = 'Chinese' then b.irMNameCH else b.irMNameEN end as irMName "+

" from pubScoreAreaM as a left join pubIndicatorMain as b on a.irMID =b.irMID where datediff(day,getdate(),a.invaliddate)>=0 and datediff(day,getdate(),a.validdate)<=0 and b.irMID in (select irMID from pubIndicatorbase where irID in (" +func.GetIndicatorID(Convert.ToInt32(Session["uID"]),"All")+")) and ("+getcond()+") ");

}

DataView dv;

dv=ds.Tables[0].DefaultView;

dv.Sort=ViewState["sortitem"]+" "+ViewState["sortdir"];

dgScoreArea.DataSource=dv;

if (dgScoreArea.CurrentPageIndex>=func.GetDGPageCount(ds.Tables[0],dgScoreArea))

{

dgScoreArea.CurrentPageIndex=0;

}

dgScoreArea.DataBind();

LRecords.Text = ds.Tables[0].Rows.Count.ToString();

LPages.Text = dgScoreArea.PageCount.ToString();

LPage.Text = (dgScoreArea.CurrentPageIndex + 1).ToString();

if(ds.Tables[0].Rows.Count==0)

{

if (IsPostBack)

{

Response.Write("<script language=javascript>alert('There is no relational data!');</script>");

return;

}

//獲得查詢條件

string getcond() {

string tbstr;

tbstr="";

switch(ddlQuery.SelectedIndex) {

case 0 :

tbstr = "1=1";

break;

case 1:

if (tbQuery.Text.Trim() =="")

tbstr = "1=1";

else

tbstr =" (b.irMNameCH like '%"+ tbQuery.Text.Trim() +"%') or (b.irMNameEN like '%" + tbQuery.Text.Trim() +"%')" ;

break;

case 2:

if (tbQuery.Text.Trim() =="")

tbstr = "1=1";

else

tbstr ="Level ='"+ tbQuery.Text.Trim() +"' " ;

break;

}

return tbstr;

}

private void Page_Load(object sender, System.EventArgs e) {

if (Session["uID"] == null)

{

func.Login_Again();//Session 丟失後重新Login

}

else

{

if (Session["uID"].ToString() =="")

{

this.Response.Redirect("../Login.aspx");

}

if (!IsPostBack) {

//獲取幫助信息

lbUseInfo.Text=func.GetUseInfo("pubScoreArea_View",Session["Language"].ToString());

this.tbvalid.Attributes.Add("onfocus","setdate(this);");

this.tbinvalid.Attributes.Add("onfocus","setdate(this);");

string s= Page.Request.Url.ToString();

//設定權限,新增/修改/刪除

if (Session["LoginRole"].ToString() !="A") {

int uID =Convert.ToInt32(Session["uID"]);

string F_SysCode =Request["F_SysCode"].ToString();

this.Toolbar1.Items.FlatIndexItem(0).Enabled =func.GetMenu(uID,F_SysCode,"Add");

if (func.GetMenu(uID,F_SysCode,"Delete") ==false) {

dgScoreArea.Columns[dgScoreArea.Columns.Count-1].Visible =false;

}

if (func.GetMenu(uID,F_SysCode,"Edit") ==false) {

dgScoreArea.Columns[dgScoreArea.Columns.Count-2].Visible =false;

dgScoreArea.Columns[dgScoreArea.Columns.Count-3].Visible =false;

}

tbWeight.Attributes.Add("onKeypress", "var isNS4 = (navigator.appName=='Netscape')?1:0; if(!isNS4){if(event.keyCode < 46 || event.keyCode > 57) event.returnValue = false;}else{if(event.which < 46 || event.which > 57) returnfalse;}");

tbshowSort.Attributes.Add("onKeypress", "var isNS4 = (navigator.appName=='Netscape')?1:0; if(!isNS4){if(event.keyCode < 48 || event.keyCode > 57) event.returnValue = false;}else{if(event.which < 48 || event.which > 57) returnfalse;}");

//設定 DataGrid 的當前顯示頁碼

if (!(Request["pageNO"]==null)){

dgScoreArea.CurrentPageIndex=Convert.ToInt32(Request["pageNO"].ToString());

}

ViewState["sortitem"]="showSort";

ViewState["sortdir"]="asc";

dgbind();

if (!(Request["irMID"]==null)) {

DataSet ds;

//顯示對應指標分值區間的明細設定資料

ds=func.GetDataTable("Select *, case when ScoringBy='A' then 'Area' when ScoringBy='R' then 'Ranking' else 'Other' end as mScroingBy, "+

" case when '"+ Session["Language"] +"' = 'Chinese' then b.irMNameCH else b.irMNameEN end as irMName "+

" from pubScoreAreaM as a left join pubIndicatorMain as b on a.irMID =b.irMID where a.irMID=" + Request["irMID"] +" ");

if (ds.Tables[0].Rows.Count>0) {

lbDetail.Text=ds.Tables[0].Rows[0]["irMName"].ToString() + " : ";

}

ds=func.GetDataTable("select dbo.GetScoreAreaString( " + Request["saID"] + ") as AreaString ");

if (ds.Tables[0].Rows.Count>0) {

lbDetail.Text += ds.Tables[0].Rows[0]["AreaString"];

}

span_Header.Visible=false;

}

private void dgScoreArea_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e) {

LinkButton DelButton= new LinkButton();

if ((e.Item.ItemType == ListItemType.AlternatingItem) || (e.Item.ItemType == ListItemType.Item)) {

e.Item.Attributes.Add("onMouseover", "this.bgColor='#eeeeee'");

e.Item.Attributes.Add("onmouseout", "this.bgColor='white'");

e.Item.Attributes.Add("ID","dg_"+e.Item.Cells[0].Text);

e.Item.Attributes.Add("onclick","SelectLine('dg_"+e.Item.Cells[0].Text+"')");

e.Item.Attributes.Add("style","cursor:hand");

}

private void Toolbar1_ButtonClick(object sender, System.EventArgs e) {

Microsoft.Web.UI.WebControls.ToolbarItem item = (Microsoft.Web.UI.WebControls.ToolbarItem)sender;

switch(item.ID) {

case "ibtnAdd":

func.FillDDL(ddlIndicator,"Select irMID, case when '"+ Session["Language"] +"' = 'Chinese' then irMNameCH else irMNameEN end as irMName from pubIndicatorMain where datediff(day,getdate(),invaliddate)>=0 and datediff(day,getdate(),validdate)<=0 and ScoringShow =1 order by irBigType desc, showsort","irMName","irMID");

func.FillDDL(ddlLevel,"select Item,Remark from pubParameter where Category='productLevel' order by Remark","Remark","Item");

func.FillDDL2(ddlLevel,"ALL","ALL","T");

func.FillDDL(ddlScoringBy,"select Item,Remark from pubParameter where Category='ScoringBy' order by Remark", "Remark", "Item");

tbRemark.Text="";

span_Header.Visible=true;

break;

case "ibtnRefresh":

dgbind();

break;

}

private void dgScoreArea_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) {

int ID;

ID = (int)dgScoreArea.DataKeys[e.Item.ItemIndex];

if (func.ExecuteSQL("Delete pubScoreAreaM where saID=" + ID)==false) {

Response.Write("<script language=javascript>alert('Delete formula fail!');</script>");

return;

}

else {

Response.Write("<script language=javascript>alert('Delete OK!');</script>");

dgbind();

return;

}

private void dgScoreArea_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e) {

func.DGPageChange(dgScoreArea, e);

dgbind();

}

private void dgScoreArea_SortCommand(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e) {

string sortitem=e.SortExpression;

if (ViewState["sortitem"].ToString()==sortitem) {

if (ViewState["sortdir"].ToString()=="asc") {

ViewState["sortdir"]="desc";

}

else {

ViewState["sortdir"]="asc";

}

else

ViewState["sortitem"]=sortitem;

dgbind();

}

private void btnQuery_Click(object sender, System.EventArgs e) {

dgbind();

}

private void btnCancel_Click(object sender, System.EventArgs e) {

span_Header.Visible=false;

}

private void btnSave_Click(object sender, System.EventArgs e) {

DataSet ds = new DataSet();

if (func.IsNumeric(tbWeight.Text)==false || func.IsNumeric(tbshowSort.Text)==false){

Response.Write("<script language=javascript>alert('Error data type or enter null value of Weight and showSort!');</script>");

return;

}

if (Convert.ToDecimal(tbWeight.Text) <=0 || Convert.ToDecimal(tbWeight.Text)>100){

Response.Write("<script language=javascript>alert('Weight must be above 0 and less than 100!');</script>");

return;

}

//先判斷資料庫中是否已經存在此資料, 若有則不保存, 否則保存

if (ddlLevel.SelectedValue=="ALL"){

ds= func.GetDataTable("Select count(*) as cs from pubScoreAreaM where irMID=" + ddlIndicator.SelectedValue +" and Level is NULL and ScoringBy='" + ddlScoringBy.SelectedValue +"' and ValidDate ='"+this.tbvalid.Text+"' and InvalidDate ='"+this.tbinvalid.Text+"' ");

}else{

ds= func.GetDataTable("Select count(*) as cs from pubScoreAreaM where irMID=" + ddlIndicator.SelectedValue +" and Level= '"+ ddlLevel.SelectedValue +"' and ScoringBy='" + ddlScoringBy.SelectedValue +"' and ValidDate ='"+this.tbvalid.Text+"' and InvalidDate ='"+this.tbinvalid.Text+"'");

}

if ((int)ds.Tables[0].Rows[0]["cs"]==0){

if (func.ExecuteSQL("Insert into pubScoreAreaM (irMID, Weight, Level, ScoringBy, showSort, Remark, CreateBy,ValidDate) values (" + ddlIndicator.SelectedValue +","+ tbWeight.Text +"/100.0,case when '"+ ddlLevel.SelectedValue +"'='ALL' then NULL else '"+ ddlLevel.SelectedValue +"' end, '"+ ddlScoringBy.SelectedValue +"',"+tbshowSort.Text+",'"+ tbRemark.Text +"', '"+ Session["LoginID"].ToString() +"','"+this.tbvalid.Text+"')")==false){

Response.Write("<script language=javascript>alert('Save data error!');</script>");

}else{

Response.Write("<script language=javascript>alert('Save OK!');</script>");

tbWeight.Text="0";

tbshowSort.Text="0";

dgbind();

return;

}

}else{

Response.Write("<script language=javascript>alert('Already exist this data!');</script>");

return;

}

private void dgScoreArea_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) {

//找到要更新資料行的ID

int saID=(int)dgScoreArea.DataKeys[e.Item.ItemIndex];

int irMID=func.GetID("saID=" + saID, "pubScoreAreaM", "irMID");

//找出更新之後的值

DropDownList level=(DropDownList)(dgScoreArea.Items[e.Item.ItemIndex].FindControl("DGddlLevel"));

DropDownList scoringby=(DropDownList)(dgScoreArea.Items[e.Item.ItemIndex].FindControl("DGddlScoringBy"));

TextBox weight=(TextBox)(dgScoreArea.Items[e.Item.ItemIndex].FindControl("DGtbWeight"));

TextBox showsort=(TextBox)(dgScoreArea.Items[e.Item.ItemIndex].FindControl("DGtbshowSort"));

TextBox ValidDate =(TextBox)(dgScoreArea.Items[e.Item.ItemIndex].FindControl("tbValidDate"));

TextBox InvalidDate =(TextBox)(dgScoreArea.Items[e.Item.ItemIndex].FindControl("tbInvalidDate"));

TextBox remark=(TextBox)(dgScoreArea.Items[e.Item.ItemIndex].FindControl("DGtbRemark"));

//資料校驗, Weight 和 ShowSort 不能為空

if ((func.IsNumeric(weight.Text)==false) || (func.IsNumeric(showsort.Text)==false)){

Response.Write("<script language=javascript>alert('Weight and showSort can not allow NULL!');</script>");

return;

}else{

DataSet ds = new DataSet();

//先判斷資料庫中是否已經存在此資料, 若有則不保存, 否則保存

if (level.SelectedValue=="ALL"){

ds= func.GetDataTable("Select count(*) as cs from pubScoreAreaM where irMID=" + irMID +" and Level is NULL and ScoringBy='" + scoringby.SelectedValue +"' and ValidDate ='"+ValidDate.Text+"' and InvalidDate ='"+InvalidDate.Text+"' ");

}else{

ds= func.GetDataTable("Select count(*) as cs from pubScoreAreaM where irMID=" + irMID +" and Level= '"+ level.SelectedValue +"' and ScoringBy='" + scoringby.SelectedValue +"' and ValidDate ='"+ValidDate.Text+"' and InvalidDate ='"+InvalidDate.Text+"' ");

}

if (((int)ds.Tables[0].Rows[0]["cs"]==1) || ((int)ds.Tables[0].Rows[0]["cs"]==0) ) {

//更新資料

if (func.ExecuteSQL("update pubScoreAreaM set Weight="+ weight.Text +"/100.0,showSort="+ showsort.Text +", Level=case when '"+ level.SelectedValue +"'='ALL' then NULL else '"+ level.SelectedValue +"' end, ScoringBy='" + scoringby.SelectedValue +"',Remark='"+ remark.Text +"', ModifyBy='" + Session["LoginID"].ToString() +"', ModifyTime=getdate() where saID="+ saID)==false){

Response.Write("<script language=javascript>alert('update data error!');</script>");

return;

}else {

Response.Write("<script language=javascript>alert('update OK!');</script>");

}

}else{

Response.Write("<script language=javascript>alert('Already exist this data!');</script>");

return;

}

dgScoreArea.EditItemIndex = -1;

dgbind();

dgScoreArea.Columns[dgScoreArea.Columns.Count-1].Visible =true;

dgScoreArea.Columns[dgScoreArea.Columns.Count-3].Visible =true;

dgScoreArea.Columns[dgScoreArea.Columns.Count-4].Visible=true;

}

private void dgScoreArea_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) {

dgScoreArea.EditItemIndex=e.Item.ItemIndex;

dgbind();

dgScoreArea.Columns[dgScoreArea.Columns.Count-1].Visible =false;

dgScoreArea.Columns[dgScoreArea.Columns.Count-3].Visible =false;

dgScoreArea.Columns[dgScoreArea.Columns.Count-4].Visible=false;

}

private void dgScoreArea_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) {

dgScoreArea.EditItemIndex=-1;

dgbind();

dgScoreArea.Columns[dgScoreArea.Columns.Count-1].Visible =true;

dgScoreArea.Columns[dgScoreArea.Columns.Count-3].Visible =true;

dgScoreArea.Columns[dgScoreArea.Columns.Count-4].Visible=true;

}

private void dgScoreArea_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) {

if (e.CommandName=="Detail"){

int ID;

ID = (int)this.dgScoreArea.DataKeys[e.Item.ItemIndex];

Response.Write("<script language=javascript>var openWnd; openWnd=window.open('pubScoreArea_Set.aspx?saID=" + ID + "&state=Edit','ScoreSet','height=500,width=700,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes',null);" +

" openWnd.moveTo((parseInt(screen.width)-700)/2,(parseInt(screen.height)-500)/2);</script>");

}

转载于:https://www.cnblogs.com/Bluer/articles/610082.html

你可能感兴趣的文章