protected void Button1_Click(object sender, EventArgs e)
{
SalesDispatchDAL sdal = new SalesDispatchDAL();
sdal.sentUpdate(int.Parse(OrderID.Text.ToString()), DateTime.Now.ToString("yyyy-MM-dd"), 3, " 问题描述：" + issueInfo.Text.ToString(), float.Parse("0.00"));
VSalesDispatch vs = Leyp.SQLServerDAL.Sales.Factory.getSalesDispatchDAL().getByID(int.Parse(OrderID.Text.ToString()));
//在接着得到销售订单
VSalesOrder vso = Leyp.SQLServerDAL.Sales.Factory.getSalesOrderDAL().getByID(vs.SalesOrderID);
//得到下单用户
string username = vso.UserName;
ServiceInfo s = new ServiceInfo();
s.CreateDate = DateTime.Now.ToString("yyyy-MM-dd");
s.Content = "订单号：" + vs.SalesOrderID + "配送错误，请您查询。原因是：" + issueInfo.Text;
s.ServiceTitle = "配送问题--" + DateTime.Now.ToString("yyyy-MM-dd");
s.UserName = username;
s.TypeID = 2;
if (Leyp.SQLServerDAL.Factory.getServiceInfoDAL().insertNewEntity(s))
{
Jscript.RefreshParent("MySalesDispatch.aspx");
Jscript.CloseWindow();
}
}
public List <VSalesDispatch> getByDeliveryType(int DeliveryID, int sideState, int PrintFlag)
{
List <VSalesDispatch> list = new List <VSalesDispatch>();
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@DeliveryID", SqlDbType.Int), new SqlParameter("@sideState", SqlDbType.Int), new SqlParameter("@PrintFlag", SqlDbType.Int) };
parameters[0].Value = DeliveryID;
parameters[1].Value = sideState;
parameters[2].Value = PrintFlag;
SqlDataReader reader = SQLHelper.RunProcedure("p_SalesDispatch_getByDeliveryType", parameters);
while (reader.Read())
{
VSalesDispatch item = new VSalesDispatch();
item.Consignor = reader.GetString(reader.GetOrdinal("Consignor"));
item.CreateDate = reader.GetString(reader.GetOrdinal("CreateDate"));
item.DeliveryDate = reader.GetString(reader.GetOrdinal("DeliveryDate"));
item.DeliveryType = reader.GetString(reader.GetOrdinal("DeliveryType"));
item.Description = reader.GetString(reader.GetOrdinal("Description"));
item.DispatchID = reader.GetInt32(reader.GetOrdinal("DispatchID"));
item.RealName = reader.GetString(reader.GetOrdinal("RealName"));
item.SalesOrderID = reader.GetString(reader.GetOrdinal("SalesOrderID"));
item.SalesOutID = reader.GetString(reader.GetOrdinal("SalesOutID"));
item.SentDate = reader.GetString(reader.GetOrdinal("SentDate"));
item.State = reader.GetInt32(reader.GetOrdinal("State"));
item.UserName = reader.GetString(reader.GetOrdinal("UserName"));
item.DeliveryName = reader.GetString(reader.GetOrdinal("DeliveryName"));
list.Add(item);
}
reader.Close();
return(list);
}
public VSalesDispatch getBySalesOutID(string SalesOutID)
{
bool flag = false;
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@SalesOutID", SqlDbType.NVarChar) };
parameters[0].Value = SalesOutID;
VSalesDispatch dispatch = new VSalesDispatch();
SqlDataReader reader = SQLHelper.RunProcedure("p_SalesDispatch_getBySalesOutID", parameters);
if (reader.Read())
{
dispatch.Consignor = reader.GetString(reader.GetOrdinal("Consignor"));
dispatch.CreateDate = reader.GetString(reader.GetOrdinal("CreateDate"));
dispatch.DeliveryDate = reader.GetString(reader.GetOrdinal("DeliveryDate"));
dispatch.DeliveryType = reader.GetString(reader.GetOrdinal("DeliveryType"));
dispatch.Description = reader.GetString(reader.GetOrdinal("Description"));
dispatch.DispatchID = reader.GetInt32(reader.GetOrdinal("DispatchID"));
dispatch.RealName = reader.GetString(reader.GetOrdinal("RealName"));
dispatch.SalesOrderID = reader.GetString(reader.GetOrdinal("SalesOrderID"));
dispatch.SalesOutID = reader.GetString(reader.GetOrdinal("SalesOutID"));
dispatch.SentDate = reader.GetString(reader.GetOrdinal("SentDate"));
dispatch.State = reader.GetInt32(reader.GetOrdinal("State"));
dispatch.UserName = reader.GetString(reader.GetOrdinal("UserName"));
dispatch.DeliveryName = reader.GetString(reader.GetOrdinal("DeliveryName"));
flag = true;
}
reader.Close();
return(flag ? dispatch : null);
}
protected void init()
{
string DispatchID = Request.QueryString["DispatchID"].ToString();
string fromUrl = Request.QueryString["fromUrl"].ToString();
Label4.Text = fromUrl;
VSalesDispatch vs = Leyp.SQLServerDAL.Sales.Factory.getSalesDispatchDAL().getByID(int.Parse(DispatchID));
if (vs == null)
{
Response.Write("没有数据");
Response.End();
}
if (vs.State != 0)
{
Response.Write("已经处理过单号！不能再操作! ");
Response.End();
}
if (!vs.Consignor.Equals(getUserName()))
{
Response.Write("单据已经交给帐号：" + vs.Consignor + "用户处理，不能再操作！<br>若要操作请先编辑修改");
Response.End();
}
Label2.Text = vs.SalesOutID;
Label3.Text = vs.DispatchID.ToString();
SentDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
HyperLink1.NavigateUrl = "Issue_SalesDispatch.aspx?DispatchID=" + DispatchID;
}
protected void init()
{
string id = Request.QueryString["DispatchID"].ToString();
VSalesDispatch sd = Leyp.SQLServerDAL.Sales.Factory.getSalesDispatchDAL().getByID(int.Parse(id));
if (sd.State != 0)
{
Response.Write("已经完成发货！不能修改");
Response.End();
return;
}
SalesOutID.Text = sd.SalesOutID;
CreateDate.Text = sd.CreateDate;
DeliveryID.Text = sd.DeliveryType;
DeliveryDate.Text = sd.DeliveryDate;
SentDate.Text = sd.SentDate;
Consignor.Text = sd.Consignor;
Description.Text = sd.Description;
StateDropDownList.Items.FindByValue(sd.State.ToString()).Selected = true;
DispatchID.Value = sd.DispatchID.ToString();
}
protected void init()
{
object action = Request.QueryString["action"];
List <VSalesDispatch> list = new List <VSalesDispatch>();
Leyp.SQLServerDAL.Sales.SalesDispatchDAL dl = new Leyp.SQLServerDAL.Sales.SalesDispatchDAL();
if (action == null)
{
}
else if (action.ToString().Equals("MyOrder"))
{
List <VSalesOrder> listOrder = Leyp.SQLServerDAL.Sales.Factory.getSalesOrderDAL().getSearchListByUserName("1000", "3000", 2, getUserName());
for (int i = 0; i < listOrder.Count; i++) //通过已经审核的销售订单查找用户的单据发货情况
{
VSalesOrder vo = listOrder[i];
VSalesDispatch vd = dl.getBySalesOrderID(vo.SalesOrderID);
if (vd != null)
{
list.Add(vd);
}
}
}
else if (action.ToString().Equals("OrderID"))
{
string OrderID = Request.QueryString["SalesOrderID"].ToString();
VSalesDispatch ds = dl.getBySalesOrderID(OrderID);
if (ds != null)
{
list.Add(ds);
}
}
CollectionPager1.DataSource = list;
CollectionPager1.BindToControl = OrderList;
OrderList.DataSource = CollectionPager1.DataSourcePaged;
}
public void init()
{
string str0 = Request.QueryString["SalesOutID"].ToString();
VSalesOut vb = Leyp.SQLServerDAL.Sales.Factory.getSalesOutDAL().getByID(str0);
if (vb == null)
{
Response.Write("没有你要的数据");
Response.End();
}
SalesOutID.Text = vb.SalesOutID;
SalesOrderID.Text = vb.SalesOrderID;
Consignee.Text = vb.Consignee;
RealName.Text = vb.RealName;
TradeDate.Text = vb.TradeDate;
//TradePlace.Text = vb.TradePlace;
CreateDate.Text = vb.CreateDate;
Description.Text = vb.Description;
State.Text = changString(vb.State.ToString());
DeliveryName0.Text = vb.DeliveryName;
Accounts ac = Leyp.SQLServerDAL.Factory.getAccountsDAL().getByID(vb.AccountsID);
AccountsName.Text = ac.AccountsName;//财务帐号
VSalesOrder vo = Leyp.SQLServerDAL.Sales.Factory.getSalesOrderDAL().getByID(vb.SalesOrderID);
ProductsPrice.Text = vb.TotalPrice.ToString();
float p = float.Parse("0.00");
p = vb.TotalPrice + vo.AttachPay - vo.Discount;
TotalPrice.Text = p.ToString();
CustomerID.Text = vo.CustomerID;
CustomerTel.Text = vo.CustomerTel;
CustomerPost.Text = vo.CustomerPost;
CustomerArea.Text = vo.CustomerArea;
TradePlace.Text = vo.DeliveryPlace;
AttachPay.Text = vo.AttachPay.ToString();
Discount.Text = vo.Discount.ToString();
if (vb.State == 3) //表示已经发货
{
Panel1.Visible = true;
VSalesDispatch vs = Leyp.SQLServerDAL.Sales.Factory.getSalesDispatchDAL().getBySalesOutID(str0);
DeliveryDate.Text = vs.DeliveryDate;
SentDate.Text = vs.SentDate;
ConsignorName.Text = vs.RealName;
DeliveryName.Text = vs.DeliveryType;
Description1.Text = vs.Description;
}
}
