<%@ Page Language="C#" Debug="true" %>
<%@ Import Namespace="System" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Configuration" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
//此頁面限制管理員填寫，助理不可填寫。
string conStr = ConfigurationManager.ConnectionStrings["SqlConn"].ConnectionString;
string EmpNo = "";
DataSet ds = new DataSet();
public int id;
public void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string uID = Request["UniqueID"].ToString();
//string uID = "21";
id = int.Parse(uID);
hdID.Value = id.ToString();
using (SqlConnection sqlConn = new SqlConnection(conStr))
{
sqlConn.Open();
SqlCommand comm = new SqlCommand();
comm.Connection = sqlConn;
comm.CommandText = "SELECT DeptCode,Convert(nvarchar(10),Date,120) as Date FROM NFC_REP_N06_DinnerBasic WHERE UniqueID=" + id;
SqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
lblSetDept.Text = dr[0].ToString();
lblDate.Text = dr[1].ToString();
}
sqlConn.Close();
}
SqlDataSource2.SelectCommand = "SELECT RType+RExType AS RChType,Ramount,RCode,RType,RExType from NFC_REP_N06_DinnerDetail WHERE PUniqueID= " + id;
rpEdit.DataBind();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
id = int.Parse(hdID.Value);
using (SqlConnection sqlConn = new SqlConnection(conStr))
{
sqlConn.Open();
SqlCommand comm = new SqlCommand();
comm.Connection = sqlConn;
comm.CommandText = "SELECT CookieClass FROM adm_awprojectconfig WHERE projectid='N06'";
try
{
string cookclass = (string)comm.ExecuteScalar();
EmpNo = Request.Cookies[cookclass]["AutoFlow_AccountID"].ToString();
}
catch
{
EmpNo = "";
}
if (EmpNo == "")
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "errlog", "alert('請先登錄系統!')", true);
}
else
{
comm.CommandText = " UPDATE NFC_REP_N06_DinnerBasic SET AdmUpdateTime=getdate(),AdmID='" + EmpNo + "',Remark='' WHERE UniqueID=" + id;
comm.ExecuteNonQuery();
bool isNot;
foreach (RepeaterItem ri in rpEdit.Items)
{
TextBox tbSum = ri.FindControl("ed1") as TextBox;
TextBox tbCode = ri.FindControl("ed2") as TextBox;
TextBox tbType = ri.FindControl("ed3") as TextBox;
TextBox tbExt = ri.FindControl("ed4") as TextBox;
int sum;
isNot = int.TryParse(tbSum.Text, out sum);
comm.CommandText = "UPDATE NFC_REP_N06_DinnerDetail SET Ramount= " + sum + " WHERE RCode='" + tbCode.Text.Trim() + "' and RExType ='" + tbExt.Text.Trim() + "' AND PUniqueID=" + id; comm.ExecuteNonQuery();
}
Response.Write("alter('更新成功')");
string msg = "window.opener.location.reload();window.close()"; Page.ClientScript.RegisterStartupScript(this.GetType(), "suclog", msg, true);
}
sqlConn.Close();
}
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title></title>
<style type="text/css">
.bt {
font-style: normal;
font-weight: normal;
font-size: 11px;
font-family: Arial;
padding: top 10px right 10px bottom 10px left 10px;
margin: top 10px right 10px bottom 10px left 10px;
}
hr {
width: 100%;
background-color: #bfbfbf;
}
ddd {
height: 12px;
width: 44px;
}
</style>
<script type="text/javascript" src="My97DatePicker/WdatePicker.js"></script>
<script type="text/javascript"> function checkNum(e) { var keynum var keychar var numcheck
if (window.event) { keynum = e.keyCode; } else if (e.which) { keynum = e.which; } keychar = String.fromCharCode(keynum); numcheck = /\d/; return numcheck.test(keychar); } </script>
</head>
<body>
<form id="formSubmit" runat="server" class="bt">
<table class="bt">
<tr>
<td>設置部門：<asp:Label ID="lblSetDept" runat="server" class="bt"> </asp:Label>
</td>
</tr>
<tr>
<td>班別日期：
<asp:Label ID="lblDate" runat="server" Width="80px" class="bt"></asp:Label>
</td>
</tr>
</table>
<div id="divEdit" runat="server">
<asp:SqlDataSource ID="SqlDataSource2" ConnectionString="<%$ ConnectionStrings:SqlConn %>" runat="server"></asp:SqlDataSource>
<asp:Repeater ID="rpEdit" DataSourceID="SqlDataSource2" runat="server">
<HeaderTemplate>
<table class="bt">
</HeaderTemplate>
<ItemTemplate>
<tr>
<td>
<asp:Label ID="lbl0" Text=' <%#Eval("RChType") %>' runat="server" class="tb"></asp:Label>： </td>
<td>
<asp:TextBox ID="ed1" Text='<%#Eval("Ramount") %>' runat="server" class="bt" Width="44px" onkeypress="return checkNum(event);" onpaste="return false;"></asp:TextBox>
<asp:TextBox ID="ed2" Text='<%#Eval("RCode") %>' runat="server" Visible="false"></asp:TextBox>
<asp:TextBox ID="ed3" Text='<%#Eval("rtype") %>' runat="server" Visible="false"></asp:TextBox>
<asp:TextBox ID="ed4" Text='<%#Eval("RexType") %>' runat="server" Visible="false"></asp:TextBox> </td>
</tr>
</ItemTemplate>
<FooterTemplate></table></FooterTemplate>
</asp:Repeater>
<asp:Button ID="btnSave" runat="server" Text="保存" OnClick="btnSave_Click" CssClass="bt" />
<input id="btnCancel" class="bt" onclick="window.close();" type="button" value="取消" />
<asp:HiddenField ID="hdID" runat="server" />
</div>
</form>
</body>
</html>
浙公网安备 33010602011771号