Newer
Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using Sqcy.Page;
public partial class AuthOrderDetail : MyPage
{
protected void Page_Load(object sender, EventArgs e)
{
MySession.CheckSession();
CheckPermission(PermissionHelper.PermissionCode.Auth);
DataSet ds = Sdbo.ExecuteDataSetProc("msp_GetOrderInfoAndDetail", Request.QueryString["OrderID"]); //计算非汇总订单总金额
if (ds != null && ds.Tables[0].Rows.Count == 1)
{
hfOrderID.Value = Request.QueryString["OrderID"];
DataRow dr = ds.Tables[0].Rows[0];
GlobalDefine.OrderStatus os = (GlobalDefine.OrderStatus)Convert.ToInt32(dr["OrderStatus"].ToString());
lblTotal.Text = dr["Total"].ToString();
lblCreatInfo.Text = String.Format("（{0} 创建于 {1}）",dr["CreatorName"],((DateTime)dr["PostTime"]).ToString("yyyy-MM-dd HH:mm:ss"));
lblStatus.Text = EnumDescription.GetFieldText(os);
tblGoods.DataSource = ds.Tables[1];
tblGoods.DataBind();
btnAuth.Text = "通过审核";
btnAuth.Attributes.Add("ToStatus", ((int)GlobalDefine.OrderStatus.Authed).ToString());
btnAuth.Enabled = os == GlobalDefine.OrderStatus.NotAuth;
if (os == GlobalDefine.OrderStatus.NotSubmit||os==GlobalDefine.OrderStatus.NotAuth)
{
btnQXSH.Enabled = false;
}
string ConnSql = System.Configuration.ConfigurationManager.ConnectionStrings["Conn"].ConnectionString;
SqlConnection Conn = new SqlConnection(ConnSql);
Conn.Open();
string SelectSql = "select * from MyOrder.Supplier where OrderID='" + Request.QueryString["OrderID"] + "'";
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand(SelectSql, Conn);
ds = new DataSet();
da.Fill(ds);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (Convert.ToInt32(ds.Tables[0].Rows[i]["SupplierOrderStatus"]) > 0)
{
btnQXSH.Enabled = false;
break;
}
}
Conn.Close();
}
else
{
Response.Write("获取数据错误");
Response.End();
}
}
}