1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Collections;
  5using System.Web;
  6using System.Web.Security;
  7using System.Web.UI;
  8using System.Web.UI.WebControls;
  9using System.Web.UI.WebControls.WebParts;
 10using System.Web.UI.HtmlControls;
 11using System.Data.SqlClient;
 12
 13public partial class Manger_OrderList : System.Web.UI.Page
 14...{
 15    MangerClass mcObj = new MangerClass();
 16    UserInfoClass uiObj = new UserInfoClass();
 17    public static int P_Int_IsSearch=0;
 18    public static int P_Int_List=0;
 19    protected void Page_Load(object sender, EventArgs e)
 20    ...{
 21        if (!IsPostBack)
 22        ...{
 23            pageBind();
 24        }
 25    }
 26    //绑定货品总额
 27    public string GetVarGF(string P_Str_GoodsFee)
 28    ...{
 29
 30        return mcObj.VarStr(P_Str_GoodsFee,2);
 31    }
 32    //绑定运费
 33    public string GetVarSF(string P_Str_ShipFee)
 34    ...{
 35        return mcObj.VarStr(P_Str_ShipFee, 2);
 36    }
 37    //绑定总金额
 38    public string GetVarTP(string P_Str_TotalPrice)
 39    ...{
 40        return mcObj.VarStr(P_Str_TotalPrice, 2);
 41    }
 42    /**//// <summary>
 43    /// 获取指定订单的信息
 44    /// </summary>
 45    public void pageBind()
 46    ...{
 47        if (this.Request.QueryString["OrderList"].ToString() != String.Empty.Trim())
 48        ...{
 49            if (this.Request.QueryString["OrderList"].ToString() == "00" || this.Request.QueryString["OrderList"].ToString() == "01")
 50            ...{
 51                if (this.Request.QueryString["OrderList"].ToString() == "00")
 52                ...{
 53                    P_Int_List = 0;
 54                }
 55                else
 56                ...{
 57                    P_Int_List = 1;
 58                }
 59                gvConfirmBind(1);
 60            }
 61            else if (this.Request.QueryString["OrderList"].ToString() == "10" || this.Request.QueryString["OrderList"].ToString() == "11")
 62            ...{
 63               
 64                if (this.Request.QueryString["OrderList"].ToString() == "10")
 65                ...{
 66                    P_Int_List = 0;
 67                }
 68                else
 69                ...{
 70                    P_Int_List = 1;
 71                }
 72                gvPayedBind(2);
 73            }
 74            else if (this.Request.QueryString["OrderList"].ToString() == "20" || this.Request.QueryString["OrderList"].ToString() == "21")
 75            ...{
 76              
 77                if (this.Request.QueryString["OrderList"].ToString() == "20")
 78                ...{
 79                    P_Int_List = 0;
 80                }
 81                else
 82                ...{
 83                    P_Int_List = 1;
 84                }
 85                gvShippedBind(3);
 86            }
 87            else if (this.Request.QueryString["OrderList"].ToString() == "30" || this.Request.QueryString["OrderList"].ToString() == "31")
 88            ...{
 89              
 90                if (this.Request.QueryString["OrderList"].ToString() == "30")
 91                ...{
 92                    P_Int_List = 0;
 93                }
 94                else
 95                ...{
 96                    P_Int_List = 1;
 97                }
 98                gvFinishedBind(4);
 99            }
100
101        }
102    
103    }
104    /**//// <summary>
105    /// 获取符合条件的订单信息
106    /// </summary>
107    /// <param name="P_Int_Flag">搜索信息的标志(1代表是否确认2代表是否付款3代表是否发货4代表是否已归档)</param>
108    public void gvConfirmBind(int P_Int_Flag)
109    ...{
110
111        SqlCommand myCmd = mcObj.GetOrderInfo(P_Int_Flag, 0, 0, 0, 0, 0, 0, 0, P_Int_List, 0, 0, 0);
112       mcObj.gvBind(gvOrderList, myCmd, "OrderInfo");
113    }
114    public void gvPayedBind(int P_Int_Flag)
115    ...{
116        SqlCommand myCmd = mcObj.GetOrderInfo(P_Int_Flag, 0, 0, 0, 0, 0, 0, 0, 0, P_Int_List, 0, 0);
117        mcObj.gvBind(gvOrderList, myCmd, "OrderInfo");
118    }
119    public void gvShippedBind(int P_Int_Flag)
120    ...{
121        SqlCommand myCmd = mcObj.GetOrderInfo(P_Int_Flag, 0, 0, 0, 0, 0, 0, 0, 0, 0, P_Int_List, 0);
122        mcObj.gvBind(gvOrderList, myCmd, "OrderInfo");
123    }
124    public void gvFinishedBind(int P_Int_Flag)
125    ...{
126        SqlCommand myCmd = mcObj.GetOrderInfo(P_Int_Flag, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, P_Int_List);
127        mcObj.gvBind(gvOrderList, myCmd, "OrderInfo");
128    }
129    /**//// <summary>
130    /// 获取符合条件的订单信息
131    /// </summary>
132    public void gvSearchBind()
133    ...{
134        int P_Int_Confirmed;
135        int P_Int_Payed;
136        int P_Int_Shipped;
137        int P_Int_Finished;
138        if(ddlConfirmed.SelectedIndex ==1)
139          ...{
140             P_Int_Confirmed =1;
141          }
142        else
143          ...{
144             P_Int_Confirmed =0;
145          }
146       if(ddlPayed.SelectedIndex ==1)
147          ...{
148              P_Int_Payed =1;
149          }
150       else
151          ...{
152              P_Int_Payed =0;
153          }
154       if(ddlShipped.SelectedIndex ==1)
155          ...{
156              P_Int_Shipped =1;
157          }
158       else
159          ...{
160              P_Int_Shipped =0;
161          }
162       if(ddlFinished.SelectedIndex ==1)
163          ...{
164              P_Int_Finished =1;
165          }
166       else 
167          ...{
168             P_Int_Finished =0;
169          }
170              if (ddlKeyType.SelectedIndex == 0)
171                ...{
172                    SqlCommand myCmd = mcObj.GetOrderInfo(0, 0, 0, Convert.ToInt32(txtKeyword.Text.Trim()), ddlConfirmed.SelectedIndex, ddlPayed.SelectedIndex, ddlShipped.SelectedIndex, ddlFinished.SelectedIndex, P_Int_Confirmed, P_Int_Payed, P_Int_Shipped, P_Int_Finished);
173                    mcObj.gvBind(gvOrderList, myCmd, "OrderInfo");
174                }
175              else
176                ...{
177                    SqlCommand myCmd = mcObj.GetOrderInfo(0, 1, Convert.ToInt32(txtKeyword.Text.Trim()), 0, ddlConfirmed.SelectedIndex, ddlPayed.SelectedIndex, ddlShipped.SelectedIndex, ddlFinished.SelectedIndex, P_Int_Confirmed, P_Int_Payed, P_Int_Shipped, P_Int_Finished);
178                    mcObj.gvBind(gvOrderList, myCmd, "OrderInfo");
179                }
180     
181    }
182
183    protected void gvOrderList_PageIndexChanging(object sender, GridViewPageEventArgs e)
184    ...{
185        gvOrderList.PageIndex = e.NewPageIndex;
186        //if (P_Int_IsSearch == 1)
187        //{
188        //    gvSearchBind();
189        //}
190        //else
191        //{
192            pageBind();
193        
194        //}
195       
196    }
197    protected void btnSearch_Click(object sender, EventArgs e)
198    ...{
199        if (txtKeyword.Text == "")
200        ...{
201            Response.Write("<script>alert('查询时关键字不能为空！')</script>");
202        }
203        else
204        ...{
205         P_Int_IsSearch = 1;
206         gvSearchBind();
207        }
208       
209    }
210    protected void gvOrderList_RowDeleting(object sender, GridViewDeleteEventArgs e)
211    ...{
212        int P_Int_id = Convert.ToInt32(gvOrderList.DataKeys[e.RowIndex].Value);
213        mcObj.DeleteOrderInfo(P_Int_id);
214        if (P_Int_IsSearch == 1)
215        ...{
216            gvSearchBind();
217        }
218        else
219        ...{
220            pageBind();
221
222        }
223
224    }
225    public string GetShipName(int P_Int_ShipType)
226    ...{
227        return mcObj.GetShipWay(P_Int_ShipType);
228    
229    }
230    public string GetPayName(int P_Int_PayType)
231    ...{
232        return mcObj.GetPayWay(P_Int_PayType);
233    }
234    public string GetMemberName(int P_Int_MemberId)
235    ...{
236        DataSet ds = new DataSet();
237        ds = uiObj.ReturnUIDsByID(P_Int_MemberId, "UserInfo");
238        return (ds.Tables["UserInfo"].Rows[0][1].ToString());  
239    
240    }
241    public string GetStatus(int P_Int_OrderID)
242    ...{
243        DataSet ds = mcObj.GetStatusDS(P_Int_OrderID,"OrderInfo");
244        return (ds.Tables["OrderInfo"].Rows[0][0].ToString() + "|" + ds.Tables["OrderInfo"].Rows[0][1].ToString() + "<Br>" + ds.Tables["OrderInfo"].Rows[0][2].ToString() + "|" + ds.Tables["OrderInfo"].Rows[0][3].ToString());
245    }
246   
247
248}
249