private void buildNode(string SalesOutID, string ConsignorId)
{
SalesOutDAL sdal = Leyp.SQLServerDAL.Sales.Factory.getSalesOutDAL();
VSalesOut vs = sdal.getByID(SalesOutID);
if (vs.State == 1)
{
SalesDispatch d = new SalesDispatch();
d.Consignor = ConsignorId;
d.CreateDate = DateTime.Now.ToString("yyyy-MM-dd");;
d.DeliveryDate = DateTime.Now.ToString("yyyy-MM-dd");;
d.DeliveryType = vs.DeliveryName;
d.Description = "无";
d.SalesOutID = SalesOutID;
d.SentDate = DateTime.Now.ToString("yyyy-MM-dd");;
d.State = 0;
d.UserName = getUserName();
Leyp.SQLServerDAL.Sales.Factory.getSalesDispatchDAL().insertNewEntity(d);
Response.Write("单号：" + SalesOutID + " 成功生成<br>");
}
else
{
Response.Write("单号：" + SalesOutID + " 没有审核 或已经处理了 <br>");
}
}
public List <VSalesOut> getSearchListByID(string SalesOutID)
{
string s = "";
List <VSalesOut> list = new List <VSalesOut>();
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@SalesOutID", SqlDbType.NVarChar) };
parameters[0].Value = SalesOutID;
SqlDataReader reader = SQLHelper.RunProcedure("p_SalesOut_getSearchListByID", parameters);
while (reader.Read())
{
VSalesOut item = new VSalesOut();
s = reader.GetValue(reader.GetOrdinal("TotalPrice")).ToString();
item.TotalPrice = float.Parse(s);
item.AuditingUser = reader.GetString(reader.GetOrdinal("AuditingUser"));
item.Consignee = reader.GetString(reader.GetOrdinal("Consignee"));
item.CreateDate = reader.GetString(reader.GetOrdinal("CreateDate"));
s = reader.GetValue(reader.GetOrdinal("Deposits")).ToString();
item.Deposits = float.Parse(s);
item.Description = reader.GetString(reader.GetOrdinal("Description"));
item.RealName = reader.GetString(reader.GetOrdinal("RealName"));
item.SalesOrderID = reader.GetString(reader.GetOrdinal("SalesOrderID"));
item.SalesOutID = reader.GetString(reader.GetOrdinal("SalesOutID"));
item.State = reader.GetInt32(reader.GetOrdinal("State"));
item.TradeDate = reader.GetString(reader.GetOrdinal("TradeDate"));
item.UserName = reader.GetString(reader.GetOrdinal("UserName"));
item.DeliveryName = reader.GetString(reader.GetOrdinal("DeliveryName"));
item.AccountsID = reader.GetString(reader.GetOrdinal("AccountsID"));
item.DeliveryID = reader.GetInt32(reader.GetOrdinal("DeliveryID"));
item.State = reader.GetInt32(reader.GetOrdinal("State"));
list.Add(item);
}
reader.Close();
return(list);
}
public VSalesOut getByID(string SalesOutID)
{
bool flag = false;
string s = "";
VSalesOut @out = new VSalesOut();
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@SalesOutID", SqlDbType.NVarChar) };
parameters[0].Value = SalesOutID;
SqlDataReader reader = SQLHelper.RunProcedure("p_SalesOut_getByID", parameters);
while (reader.Read())
{
s = reader.GetValue(reader.GetOrdinal("TotalPrice")).ToString();
@out.TotalPrice = float.Parse(s);
@out.AuditingUser = reader.GetString(reader.GetOrdinal("AuditingUser"));
@out.Consignee = reader.GetString(reader.GetOrdinal("Consignee"));
@out.CreateDate = reader.GetString(reader.GetOrdinal("CreateDate"));
s = reader.GetValue(reader.GetOrdinal("Deposits")).ToString();
@out.Deposits = float.Parse(s);
@out.Description = reader.GetString(reader.GetOrdinal("Description"));
@out.RealName = reader.GetString(reader.GetOrdinal("RealName"));
@out.SalesOrderID = reader.GetString(reader.GetOrdinal("SalesOrderID"));
@out.SalesOutID = reader.GetString(reader.GetOrdinal("SalesOutID"));
@out.State = reader.GetInt32(reader.GetOrdinal("State"));
@out.TradeDate = reader.GetString(reader.GetOrdinal("TradeDate"));
@out.UserName = reader.GetString(reader.GetOrdinal("UserName"));
@out.DeliveryName = reader.GetString(reader.GetOrdinal("DeliveryName"));
@out.DeliveryID = reader.GetInt32(reader.GetOrdinal("DeliveryID"));
@out.AccountsID = reader.GetString(reader.GetOrdinal("AccountsID"));
@out.State = reader.GetInt32(reader.GetOrdinal("State"));
flag = true;
}
reader.Close();
return(flag ? @out : null);
}
public void init()
{
string strID = Request.QueryString["SalesOutID"].ToString();
VSalesOut vs = Leyp.SQLServerDAL.Sales.Factory.getSalesOutDAL().getByID(strID);
if (vs == null)
{
Response.Write("没有您要的数据");
Response.End();
}
if (vs.State != 1)//已审核状态有效
{
Response.Write("只能受理已经审核的单据");
Response.End();
}
SalesOutID.Text = vs.SalesOutID;
DeliveryID.Text = vs.DeliveryName;
CreateDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
DeliveryDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
SentDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
}
public void init()
{
List <VSalesOut> list = Leyp.SQLServerDAL.Sales.Factory.getSalesOutDAL().getSearchList("1000", "3000", 1);
int count = list.Count;
if (count == 0)
{
Response.Write("所有数据处理完成！没有需要审核的单据 <a href=\"Manager_SalesOutOrder.aspx\">返回列表</a>");
Response.End();
}
else
{
int index = new Random().Next(count);
VSalesOut vb = list[index];
AuditingCount.Text = count.ToString();
SalesOutID.Text = vb.SalesOutID;
SalesOrderID.Text = vb.SalesOrderID;
//Consignee.Text = vb.Consignee;
RealName.Text = vb.RealName;
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();
TradeDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
}
}
protected void init()
{
string action = Request.Form["action"].ToString();
if (action.Equals("add"))
{
string str0 = Request.Form["SalesOutID"].ToString();
string str1 = Request.Form["SalesOrderID"].ToString();
string str2 = Request.Form["CreateDate"].ToString();
string str3 = Request.Form["Consignee"].ToString();
// string str4=Request.Form["TradePlace"].ToString();
string str5 = Request.Form["DeliveryID"].ToString();
string str6 = Request.Form["AccountsID"].ToString();
string str7 = Request.Form["TradeDate"].ToString();
string str8 = Request.Form["Deposits"].ToString();
string str9 = Request.Form["Description"].ToString();
SalesOut s = new SalesOut();
s.Consignee = str3;
s.CreateDate = str2;
// s.TradePlace = str4;
s.DeliveryID = int.Parse(str5);
s.TradeDate = str7;
s.Deposits = float.Parse(str8);
s.Description = str9;
s.UserName = getUserName();
s.State = 0;
s.SalesOutID = str0;
s.SalesOrderID = str1;
s.AccountsID = str6;
Leyp.SQLServerDAL.Sales.Factory.getSalesOutDAL().insertNewEntity(s);
Response.Write("00");
Response.End();
}
else if (action.Equals("delete"))
{
string str0 = Request.Form["SalesOutID"].ToString();
VSalesOut v = Leyp.SQLServerDAL.Sales.Factory.getSalesOutDAL().getByID(str0);
if (v.UserName.Equals(getUserName()))
{
Leyp.SQLServerDAL.Sales.Factory.getSalesOutDAL().deleteEitity(str0);
Response.Write("00");
Response.End();
}
}
else if (action.Equals("testAdd"))//临时添加详细
{
string str0 = Request.Form["SalesOutID"].ToString();
string str1 = Request.Form["SalesOrderID"].ToString();
Leyp.SQLServerDAL.Sales.Factory.getSalesOutDAL().insertSalesDetailFrist(str1, str0);
Response.Write("00");
Response.End();
}
}
/// <summary>
/// 检查已经审核了吗
/// </summary>
/// <param name="SalesOutID"></param>
/// <returns></returns>
private bool checkSalesOutID(string SalesOutID)
{
bool reslut = false;
SalesOutDAL sdal = Leyp.SQLServerDAL.Sales.Factory.getSalesOutDAL();
VSalesOut vs = sdal.getByID(SalesOutID);
if (vs.State == 1)
{
reslut = true;
}
return(reslut);
}
protected void init()
{
object action = Request.QueryString["action"];
if (action != null)
{
if (action.ToString().Equals("view"))
{
string str0 = Request.QueryString["baginData"].ToString();
string str1 = Request.QueryString["endData"].ToString();
string str2 = Request.QueryString["side"].ToString();
if (str0.Equals(""))
{
str0 = "1000";
}
if (str1.Equals(""))
{
str1 = "3000";
}
List <VSalesOut> list = new List <VSalesOut>();
list = Leyp.SQLServerDAL.Sales.Factory.getSalesOutDAL().getSearchList(str0, str1, int.Parse(str2));
CollectionPager1.DataSource = list;
CollectionPager1.BindToControl = OrderList;
OrderList.DataSource = CollectionPager1.DataSourcePaged;
}
else if (action.ToString().Equals("sel"))
{
string id = Request.QueryString["ID"].ToString();
VSalesOut o = new VSalesOut();
o = Leyp.SQLServerDAL.Sales.Factory.getSalesOutDAL().getByID(id);
VSalesOrder os = Leyp.SQLServerDAL.Sales.Factory.getSalesOrderDAL().getByID(o.SalesOrderID);
Jscript.CloseWindowReturnValues(o.SalesOutID + "$$$" + os.DeliveryType);
return;
}
}
else //初始化页面
{
List <VSalesOut> list = new List <VSalesOut>();
list = Leyp.SQLServerDAL.Sales.Factory.getSalesOutDAL().getSearchList("1000", "2050", 2);
CollectionPager1.DataSource = list;
CollectionPager1.BindToControl = OrderList;
OrderList.DataSource = CollectionPager1.DataSourcePaged;
}
}
public bool AuditingSalesOutOrder(string SalesOutID)
{
bool flag = false;
try
{
VSalesOut @out = new VSalesOut();
List <VSalesOutDetail> list = new List <VSalesOutDetail>();
ProductsStockDAL kdal = new ProductsStockDAL();
@out = new SalesOutDAL().getByID(SalesOutID);
list = new SalesOutDetailDAL().getBySalesOutID(SalesOutID);
for (int i = 0; i < list.Count; i++)
{
ProductsStock stock;
SalesOutDetail detail = list[i];
if (kdal.isHaveEitity(detail.HouseDetailID, detail.ProductsID))
{
stock = new ProductsStock();
stock.HouseDetailID = detail.HouseDetailID;
stock.ProductsID = detail.ProductsID;
stock.Num = detail.Quantity;
kdal.updateCutNum(stock);
}
else
{
stock = new ProductsStock();
stock.HouseDetailID = detail.HouseDetailID;
stock.ProductsID = detail.ProductsID;
stock.Num = -detail.Quantity;
kdal.insertNewEitity(stock);
}
}
flag = true;
}
catch
{
}
return(flag);
}
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;
}
}
private void init()
{
object SalesID = Request.QueryString["SalesOutID"];
if (SalesID == null)
{
Response.Write("没有您要的数据");
Response.End();
return;
}
VSalesOut vs = Leyp.SQLServerDAL.Sales.Factory.getSalesOutDAL().getByID(SalesID.ToString());
if (vs == null)
{
Response.Write("没有您要的数据");
Response.End();
return;
}
if (vs.State > 0)
{
Response.Write("单据已经审核，不能修改");
Response.End();
return;
}
VSalesOrder vo = Leyp.SQLServerDAL.Sales.Factory.getSalesOrderDAL().getByID(vs.SalesOrderID);//
if (vo == null)
{
Response.Write("没有您要的数据");
Response.End();
return;
}
SalesOutID.Text = vs.SalesOutID;
CreateDate.Text = vs.CreateDate;
SalesOrderID.Text = vs.SalesOrderID;
TradeDate.Text = vs.TradeDate;
Consignee.Text = vs.Consignee;
Description.Text = vs.Description;
CustomerName.Text = vo.CustomerName;
CustomerPost.Text = vo.CustomerPost;
CustomerTel.Text = vo.CustomerTel;
CustomerArea.Items.FindByValue(vo.CustomerArea.ToString()).Selected = true;
DeliveryIDh.Value = vs.DeliveryID.ToString();
AccountsIDh.Value = vs.AccountsID;
Platformh.Value = vo.PlatformID.ToString();
string str = vo.CustomerID;
string str0 = str.Substring(0, 2);
CustomerIDTypeh.Value = str0;
CustomerID.Text = str.Substring(2, str.Length - 2);
CustomerIDType.Items.FindByValue(str0).Selected = true;
AttachPay.Text = vo.AttachPay.ToString();
Discount.Text = vo.Discount.ToString();
DeliveryPlace.Text = vo.DeliveryPlace;
}
