protected void rpSettlementList_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
Settlement st = e.Item.DataItem as Settlement;
Repeater rpDelList = e.Item.FindControl("rpDelList") as Repeater;
DeliveryDAL dlDAL = new DeliveryDAL();
var deliverys = dlDAL.GetDeliveryByOrderNo(st.SourceNo);
Utility.BindDataToRepeater(rpDelList, deliverys);
FollowUpTop3UserControl followUp = e.Item.FindControl("followUpTop3UserControl") as FollowUpTop3UserControl;
UIUtility.BindUserControl(followUp, SysConst.SourceTypeSettlement, st.St_No);
Total += st.TotalAmount.GetValueOrDefault();
TotalNeed += st.FirstAmount.GetValueOrDefault();
TotalRec += st.AmountReceived.GetValueOrDefault();
TotalEnd += st.TotalAmount.GetValueOrDefault() - st.AmountReceived.GetValueOrDefault();
}
if (e.Item.ItemType == ListItemType.Footer)
{
var lblTotal = e.Item.FindControl("lblTotal") as Label;
var lblNeed = e.Item.FindControl("lblNeed") as Label;
var lblRec = e.Item.FindControl("lblRec") as Label;
var lblEnd = e.Item.FindControl("lblEnd") as Label;
lblTotal.Text = Total.ToString();
lblNeed.Text = TotalNeed.ToString();
lblRec.Text = TotalRec.ToString();
lblEnd.Text = TotalEnd.ToString();
}
}
public override void BindControl()
{
DeliveryDAL dal = new DeliveryDAL();
var result = dal.GetDeliveryByOrderNo(SourceNo);
Utility.BindDataToRepeater(rpDelivery, result);
}
protected void btnChangeStatus_Click(object sender, EventArgs e)
{
DeliveryDAL dal = new DeliveryDAL();
var delivery = dal.GetDeliveryByNo(DeliveryNo);
AddFollowUp(followUpControl, delivery.Status, Utility.GetSelectedText(ddlDeliveryStatus));
delivery.Status = Utility.GetSelectedText(ddlDeliveryStatus);
dal.Save();
SetFocus(btnChangeStatus);
}
public DataTable[] SearchOrderInformationforDELIVERY_UIto_UpdateBLL(Customer aCustomer)
{
if (aCustomer.ID <= 0)
{
return(new DataTable[] { null });
}
else
{
DeliveryDAL aDeliveryDAL = new DeliveryDAL();
DataTable[] dTables = aDeliveryDAL.SearchOrderInformationforDELIVERY_UIto_UpdateDAL(aCustomer);
return(dTables);
}
}
private List <Delivery> GetDeliveryList()
{
DeliveryDAL dal = new DeliveryDAL();
var result = dal.SearchDelivery(txtDeliveryNo.Text,
Utility.GetSelectedText(ddlCompany),
Utility.GetSelectedText(ddlContact),
txtPhone.Text,
!string.IsNullOrEmpty(txtBeginDate.Text) ? DateTime.Parse(txtBeginDate.Text) : DateTime.MinValue,
!string.IsNullOrEmpty(txtEndDate.Text) ? DateTime.Parse(txtEndDate.Text) : DateTime.MaxValue,
Utility.GetSelectedText(ddlDeliveryDriverMan),
Utility.GetSelectedText(ddlInstallMan),
Utility.GetSelectedText(ddlDeliveryStatus),
txtOrderNo.Text);
return(result);
}
public bool CancelDeliveryBLL(Payment aPayment, OrderDetails aOrderDetails)
{
if (aOrderDetails.OrderStatus == "" || aPayment.TotalBill <= 0 || aPayment.Due < 0 || aPayment.LastPayment < 0 || aPayment.PaymentStatus == "" || aPayment.Discount < 0 || aPayment.PaymentStatus == "" || aPayment.ProductCharge <= 0)
{
return(false);
}
else
{
DeliveryDAL aDeliveryDAL = new DeliveryDAL();
bool res = aDeliveryDAL.CancelDeliveryDAL(aPayment, aOrderDetails);
if (res)
{
return(res);
}
else
{
return(false);
}
}
}
public bool SaveDeliveryInformationBLL(OrderDetails aOrderDetails, Payment aPayment)
{
if (aOrderDetails.FinalWeight <= 0 || aOrderDetails.OrderStatus == "" || aPayment.ProductCharge <= 0 || aPayment.TotalBill <= 0 || aPayment.Due <= 0 || aPayment.LastPayment < 0 || aPayment.PaymentStatus == "")
{
return(false);
}
else
{
DeliveryDAL aDeliveryDAL = new DeliveryDAL();
bool res = aDeliveryDAL.SaveDeliveryInformationDAL(aOrderDetails, aPayment);
if (res)
{
return(res);
}
else
{
return(false);
}
}
}
protected void btnSaveAmount_OnClick(object sender, EventArgs e)
{
DeliveryDAL dal = new DeliveryDAL();
var delivery = dal.GetDeliveryByNo(DeliveryNo);
if (!string.IsNullOrEmpty(txtTotalAmount.Text))
{
delivery.TotalAmount = double.Parse(txtTotalAmount.Text);
}
if (!string.IsNullOrEmpty(txtReceivedFirst.Text))
{
delivery.FirstAmount = double.Parse(txtReceivedFirst.Text);
}
if (!string.IsNullOrEmpty(txtReceived.Text))
{
delivery.ReceivedAmount = double.Parse(txtReceived.Text);
}
delivery.ReceivableIntro = txtBalanceIntro.Text;
lblEndBalance.Text = ((delivery.TotalAmount.HasValue ? delivery.TotalAmount.Value : 0) - (delivery.ReceivedAmount.HasValue ? delivery.ReceivedAmount.Value : 0)).ToString();
dal.Save();
SetFocus(btnSaveAmount);
}
protected void btnCreateDelivery_Click(object sender, EventArgs e)
{
//get no
SeedDAL sdal = new SeedDAL();
string no = sdal.GetNoByTableName(SysConst.TableDelivery, SysConst.SuffixDelivery);
//customer
string companyName = string.Empty;
string contact = string.Empty;
string address = string.Empty;
string email = string.Empty;
string qq = string.Empty;
string phone1 = string.Empty;
string phone2 = string.Empty;
string other = string.Empty;
OrderDAL soDAL = new OrderDAL();
var so = soDAL.GetOrderByNo(SourceNo);
so.Status = "申请送货安装";
soDAL.Save();
string orderNo = so.Order_No;
companyName = so.CustomerCompanyName;
contact = so.CustomerContactName;
address = so.CustomerAddress;
email = so.CustomerEmail;
qq = so.CustomerQQ;
phone1 = so.CustomerPhone1;
phone2 = so.CustomerPhone2;
other = so.CustomerOthers;
//new delivery
DeliveryDAL dal = new DeliveryDAL();
Delivery delivery = new Delivery()
{
Order_No = orderNo,
Delivery_No = no,
Status = FirstStatusConsts.Delivery,
CreatedDate = DateTime.Now,
CreatedAt = DateTime.Now,
CreatedBy = SMSContext.Current.User.UserName,
CustomerCompanyName = companyName,
CustomerContactName = contact,
CustomerAddress = address,
CustomerEmail = email,
CustomerQQ = qq,
CustomerPhone1 = phone1,
CustomerPhone2 = phone2,
CustomerOthers = other
};
dal.AddDelivery(delivery);
dal.Save();
int dlid = delivery.Delivery_Id;
string dlno = delivery.Delivery_No;
Utility.AddDefault(dlno, SysConst.SourceTypeDelivery, FooterConsts.Delivery);
string url = Page.ResolveUrl(string.Format("~/DeliveryForm.aspx?dlid={0}&dlno={1}&sourcetype={2}&sourceno={3}", dlid, dlno, SourceType, SourceNo));
string script = string.Format("<script>window.open('{0}')</script>", url);
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "createdelivery", script);
BindControl();
SetFocus(btnCreateDelivery);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Utility.BindDataToDropdown(ddlSettlementStatus, Utility.GetSettlementStatusList());
Utility.BindDataToDropdown(ddlSettlementMan, Utility.GetUserList2(true));
DeliveryDAL dlDAL = new DeliveryDAL();
var deliverys = dlDAL.GetDeliveryByOrderNo(SourceNo);
if (deliverys != null)
{
foreach (var item in deliverys)
{
cblDeliveryList.Items.Add(new ListItem()
{
Text = item.Delivery_No, Value = item.Delivery_Id.ToString()
});
}
}
//link
OrderDAL sDAL = new OrderDAL();
var order = sDAL.GetOrderByNo(SourceNo);
lnkOrderId.Text = order.Order_No;
lnkOrderId.NavigateUrl = string.Format("orderform.aspx?ordid={0}&ordno={1}&sourcetype={2}&sourceno={3}", order.Order_Id, order.Order_No, order.SourceType, order.SourceNo);
SettlementDAL dal = new SettlementDAL();
var st = dal.GetSettlementByNo(StNo);
txtCreatedDate.Text = st.CreatedDate.ToString("yyyy-MM-dd");
txtDeliveryDate.Text = st.DeliveryDate.HasValue ? st.DeliveryDate.Value.ToString("yyyy-MM-dd") : string.Empty;
ddlSettlementMan.SelectedValue = st.StMan;
if (!string.IsNullOrEmpty(st.DeliveryList))
{
foreach (ListItem item in cblDeliveryList.Items)
{
if (st.DeliveryList.Contains(item.Text))
{
item.Selected = true;
}
}
}
//customer
this.customerInfoControl.SetValue(st.CustomerCompanyName,
st.CustomerContactName,
st.CustomerAddress,
st.CustomerEmail,
st.CustomerQQ,
st.CustomerPhone1,
st.CustomerPhone2,
st.CustomerOthers);
//lineitem
LineItemsControl1.IsPriceColumnVisible = true;
LineItemsControl1.IsSpecColumnVisible = false;
LineItemsControl1.IsFooterVisible = false;
LineItemsControl1.SourceId = st.St_Id;
UIUtility.BindUserControl(LineItemsControl1, SysConst.SourceTypeSettlement, st.St_No);
//amount
SetAmount(SysConst.SourceTypeSettlement, st.St_Id);
txtTotalAmount.Text = st.TotalAmount.ToString();
txtReceivedFirst.Text = st.FirstAmount.ToString();
txtReceived.Text = st.AmountReceived.ToString();
txtBalanceIntro.Text = st.ReceivableIntro;
lblEndBalance.Text = ((st.TotalAmount.HasValue ? st.TotalAmount.Value : 0) - (st.AmountReceived.HasValue ? st.AmountReceived.Value:0)).ToString();
var accumulateAmount = dal.GetSettlementByOrderNo(SourceNo).Where(s => s.CreatedDate <= st.CreatedDate).Sum(settle => settle.TotalAmount);
var receivableTotal = new ReceiptDAL().GetReceiptBySource(SysConst.SourceTypeOrder, st.SourceNo).Where(r => r.ReceivedDate <= st.CreatedDate).Sum(re => re.ReceivedAmount);
lblAccumulateAmount.Text = accumulateAmount.ToString();
lblReceivableTotal.Text = receivableTotal.ToString();
//status
ddlSettlementStatus.SelectedValue = st.Status;
//followup
UIUtility.BindUserControl(followUpControl, SysConst.SourceTypeSettlement, st.SourceNo);
}
}
protected void cblDeliveryList_SelectedIndexChanged(object sender, EventArgs e)
{
List <LineItem> items = new List <LineItem>();
LineItemDAL dal = new LineItemDAL();
foreach (ListItem listItem in cblDeliveryList.Items)
{
if (listItem.Selected)
{
var del = new DeliveryDAL().GetDeliveryByNo(listItem.Text);
var delItems = dal.GetLineItemsBySource(del.Delivery_Id, SysConst.SourceTypeDelivery);
foreach (var delItem in delItems)
{
items.Add(new LineItem()
{
Intro = delItem.Intro,
Name = delItem.Name,
OriginNo = listItem.Text,
Project = delItem.Project,
Quantity = delItem.Quantity,
Remark = delItem.Remark,
SourceId = StId,
SourceType = SysConst.SourceTypeSettlement,
Spec = delItem.Spec,
Unit = delItem.Unit,
UnitPrice = delItem.UnitPrice
});
}
}
else
{
var lineItemsOfSt = dal.GetLineItemsBySource(StId, SysConst.SourceTypeSettlement);
foreach (var item in lineItemsOfSt)
{
if (item.OriginNo == listItem.Text)
{
dal.DeleteItem(item.LineItem_Id);
}
}
}
}
foreach (var item in items)
{
dal.AddLineItem(item);
}
dal.Save();
//save list
StringBuilder sb = new StringBuilder();
for (int i = 0; i < cblDeliveryList.Items.Count; i++)
{
if (cblDeliveryList.Items[i].Selected)
{
sb.Append(cblDeliveryList.Items[i].Text).Append("|");
}
}
var stDAL = new SettlementDAL();
var st = stDAL.GetSettlementByNo(StNo);
st.DeliveryList = sb.ToString();
stDAL.Save();
UIUtility.BindUserControl(LineItemsControl1, SysConst.SourceTypeSettlement, StId);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Utility.BindDataToDropdown(ddlDeliveryStatus, Utility.GetDeliveryStatusList());
Utility.BindDataToDropdown(ddlDeliveryMethod, Utility.GetLookupList(SysConst.DeliveryCatelog));
Utility.BindDataToDropdown(ddlInstallType, Utility.GetLookupList(SysConst.InstallCatelog));
Utility.BindDataToDropdown(ddlDelCreateMan, Utility.GetUserList2(true));
Utility.BindDataToDropdown(ddlSalesMan, Utility.GetUserList2(true));
if (!string.IsNullOrEmpty(DeliveryNo))
{
DeliveryDAL dDAL = new DeliveryDAL();
var del = dDAL.GetDeliveryByNo(DeliveryNo);
OrderDAL soDAL = new OrderDAL();
var ord = soDAL.GetOrderByNo(SourceNo);
MachiningDAL mDAL = new MachiningDAL();
var machList = mDAL.GetMachBySource(SysConst.SourceTypeOrder, SourceNo);
foreach (var item in machList)
{
cblMach.Items.Add(new ListItem()
{
Text = item.Mach_No, Value = item.Mach_Id.ToString()
});
}
//basic
txtCreatedDate.Text = del.CreatedDate.ToString("yyyy-MM-dd");
ddlSalesMan.SelectedValue = del.OrderMan;
ddlDelCreateMan.SelectedValue = del.DeliveryCreateMan;
lnkOrder.Text = SourceNo;
lnkOrder.NavigateUrl = Page.ResolveUrl(string.Format("~/OrderForm.aspx?ordid={0}&ordno={1}&sourcetype={2}&sourceno={3}",
ord.Order_Id,
ord.Order_No,
ord.SourceType,
ord.SourceNo));
if (!string.IsNullOrEmpty(del.MachList))
{
foreach (ListItem item in cblMach.Items)
{
if (del.MachList.Contains(item.Text))
{
item.Selected = true;
}
}
}
//customer
this.customerInfoControl.SetValue(
del.CustomerCompanyName,
del.CustomerContactName,
del.CustomerAddress,
del.CustomerEmail,
del.CustomerQQ,
del.CustomerPhone1,
del.CustomerPhone2,
del.CustomerOthers);
//delivery type
this.ddlDeliveryMethod.SelectedValue = del.DeliveryType;
this.txtDelIntro.Text = del.DeliveryIntro;
this.txtDeliveryDriverMan.Text = del.DeliveryDriverMan;
this.txtDelPhone.Text = del.DriverPhone;
this.txtCarType.Text = del.CarType;
this.txtDeliveryToAddress.Text = del.DeliveryToAddress;
this.txtExpectDeliveryDate.Text = del.ExpectedDeliveryDate.HasValue ? del.ExpectedDeliveryDate.Value.ToString("yyyy-MM-dd") : string.Empty;
this.txtRealDelDate.Text = del.RealDeliveryDate.HasValue ? del.RealDeliveryDate.Value.ToString("yyyy-MM-dd") : string.Empty;
//install
this.chkProvideInstall.Checked = del.IsInstallProvided;
this.ddlInstallType.SelectedValue = del.InstallType;
this.txtInstallIntro.Text = del.InstallIntro;
this.txtInstallMan.Text = del.InstallMan;
this.txtInstallPhone.Text = del.InstallPhone;
this.txtInstallDate.Text = del.InstallDate.HasValue ? del.InstallDate.Value.ToString("yyyy-MM-dd"):string.Empty;
this.chkInsteadSettlement.Checked = del.InsteadOfSettlement;
//delivery content
lineItemControl.SourceId = del.Delivery_Id;
UIUtility.BindUserControl(lineItemControl, SysConst.SourceTypeDelivery, del.Delivery_No);
//settlement info
if (chkInsteadSettlement.Checked)
{
SettlementDAL dal = new SettlementDAL();
SetAmount(SysConst.SourceTypeDelivery, del.Delivery_Id);
txtTotalAmount.Text = del.TotalAmount.ToString();
txtReceivedFirst.Text = del.FirstAmount.ToString();
txtReceived.Text = del.ReceivedAmount.ToString();
txtBalanceIntro.Text = del.ReceivableIntro;
lblEndBalance.Text = ((del.TotalAmount.HasValue ? del.TotalAmount.Value : 0) - (del.ReceivedAmount.HasValue ? del.ReceivedAmount.Value : 0)).ToString();
var accumulateAmount = dal.GetSettlementByOrderNo(SourceNo).Where(s => s.CreatedDate <= del.CreatedDate).Sum(settle => settle.TotalAmount);
var receivableTotal = new ReceiptDAL().GetReceiptBySource(SysConst.SourceTypeOrder, del.Order_No).Where(r => r.ReceivedDate <= del.CreatedDate).Sum(re => re.ReceivedAmount);
lblAccumulateAmount.Text = accumulateAmount.ToString();
lblReceivableTotal.Text = receivableTotal.ToString();
}
//intro
UIUtility.BindUserControl(FooterIntroControl1, SysConst.SourceTypeDelivery, del.Delivery_No);
this.ddlDeliveryStatus.SelectedValue = del.Status;
//followup
UIUtility.BindUserControl(followUpControl, SysConst.SourceTypeDelivery, del.Delivery_No);
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
DeliveryDAL dal = new DeliveryDAL();
var delivery = dal.GetDeliveryByNo(DeliveryNo);
//update delivery
delivery.OrderMan = Utility.GetSelectedText(ddlSalesMan);
delivery.DeliveryCreateMan = Utility.GetSelectedText(ddlDelCreateMan);
StringBuilder sb = new StringBuilder(256);
//save
delivery.CustomerCompanyName = customerInfoControl.CompanyName;
delivery.CustomerContactName = customerInfoControl.ContactName;
delivery.CustomerAddress = customerInfoControl.Address;
delivery.CustomerEmail = customerInfoControl.Email;
delivery.CustomerQQ = customerInfoControl.QQ;
delivery.CustomerPhone1 = customerInfoControl.Phone1;
delivery.CustomerPhone2 = customerInfoControl.Phone2;
delivery.CustomerOthers = customerInfoControl.Other;
//delivery
delivery.DeliveryType = Utility.GetSelectedText(ddlDeliveryMethod);
delivery.DeliveryIntro = txtDelIntro.Text;
delivery.DeliveryDriverMan = txtDeliveryDriverMan.Text;
delivery.DriverPhone = txtDelPhone.Text;
delivery.CarType = txtCarType.Text;
delivery.DeliveryToAddress = txtDeliveryToAddress.Text;
if (!string.IsNullOrEmpty(txtExpectDeliveryDate.Text))
{
delivery.ExpectedDeliveryDate = DateTime.Parse(txtExpectDeliveryDate.Text);
}
if (!string.IsNullOrEmpty(txtRealDelDate.Text))
{
delivery.RealDeliveryDate = DateTime.Parse(txtRealDelDate.Text);
}
//settlement info
if (chkInsteadSettlement.Checked)
{
delivery.TotalAmount = double.Parse(txtTotalAmount.Text);
delivery.FirstAmount = double.Parse(txtReceivedFirst.Text);
delivery.ReceivedAmount = double.Parse(txtReceived.Text);
delivery.ReceivableIntro = txtBalanceIntro.Text;
}
//install
delivery.IsInstallProvided = chkProvideInstall.Checked;
delivery.InstallType = Utility.GetSelectedText(ddlInstallType);
delivery.InstallIntro = txtInstallIntro.Text;
delivery.InstallMan = txtInstallMan.Text;
delivery.InstallPhone = txtInstallPhone.Text;
if (!string.IsNullOrEmpty(txtInstallDate.Text))
{
delivery.InstallDate = DateTime.Parse(txtInstallDate.Text);
}
delivery.InsteadOfSettlement = chkInsteadSettlement.Checked;
AddFollowUp(followUpControl, delivery.Status, Utility.GetSelectedText(ddlDeliveryStatus));
delivery.Status = Utility.GetSelectedText(ddlDeliveryStatus);
dal.Save();
//save new customer
customerInfoControl.Save();
this.SetFocus(sender);
}
protected void btnImport_Click(object sender, EventArgs e)
{
DeliveryDAL dal = new DeliveryDAL();
LineItemDAL lDal = new LineItemDAL();
MachSummaryDAL mDAL = new MachSummaryDAL();
MachLookupDAL mlDAL = new MachLookupDAL();
var delivery = dal.GetDeliveryByNo(DeliveryNo);
StringBuilder sb = new StringBuilder(256);
List <MachSummary> machSummaryList = new List <MachSummary>();
foreach (ListItem item in cblMach.Items)
{
if (item.Selected)
{
sb.Append(item.Text).Append("|");
machSummaryList.AddRange(mDAL.GetSummaryByMachId(int.Parse(item.Value)));
}
}
delivery.MachList = sb.ToString();
dal.Save();
var lineItems = lDal.GetLineItemsBySource(this.DeliveryId, SysConst.SourceTypeDelivery);
foreach (var item in lineItems)
{
lDal.DeleteItem(item.LineItem_Id);
}
foreach (var item in machSummaryList)
{
var machLook = mlDAL.GetMachLookupByName(item.MachName);
var lineItem = new LineItem();
lineItem.Intro = item.MachIntro;
lineItem.Name = "加工";
lineItem.Project = item.MachName;
lineItem.Quantity = item.Qty;
lineItem.Remark = item.Remark;
lineItem.SourceId = DeliveryId;
lineItem.SourceType = SysConst.SourceTypeDelivery;
lineItem.Spec = string.Empty;
lineItem.Unit = item.Unit;
if (string.Equals(item.Unit, "米"))
{
lineItem.UnitPrice = machLook.PriceM;
}
else if (string.Equals(item.Unit, "平方米"))
{
lineItem.UnitPrice = machLook.PriceM2;
}
else
{
lineItem.UnitPrice = machLook.PriceOther;
}
lDal.AddLineItem(lineItem);
}
lDal.Save();
UIUtility.BindUserControl(lineItemControl, SysConst.SourceTypeDelivery, DeliveryId);
}
