public override void BindControl()
{
SettlementDAL dal = new SettlementDAL();
var sts = dal.GetSettlementByOrderNo(SourceNo);
Utility.BindDataToRepeater(rpItems, sts);
}
public long SaveSettlement(ISettlement settlement)
{
long Settlementid = 0;
Settlementid = SettlementDAL.SaveSettlement(settlement);
return(Settlementid);
}
protected void btnChangeStatus_Click(object sender, EventArgs e)
{
SettlementDAL dal = new SettlementDAL();
var st = dal.GetSettlementByNo(StNo);
AddFollowUp(followUpControl, st.Status, Utility.GetSelectedText(ddlSettlementStatus));
SetFocus(btnChangeStatus);
}
protected void btnSettlement_Click(object sender, EventArgs e)
{
//get no
SeedDAL sdal = new SeedDAL();
string no = sdal.GetNoByTableName(SysConst.TableSettlement, SysConst.SuffixSettlement);
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);
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 refine
SettlementDAL dal = new SettlementDAL();
Settlement st = new Settlement()
{
St_No = no,
Status = FirstStatusConsts.Settlement,
SourceType = SourceType,
SourceNo = SourceNo,
CreatedDate = DateTime.Now,
CustomerCompanyName = companyName,
CustomerContactName = contact,
CustomerAddress = address,
CustomerEmail = email,
CustomerQQ = qq,
CustomerPhone1 = phone1,
CustomerPhone2 = phone2,
CustomerOthers = other
};
dal.AddSettlement(st);
dal.Save();
int stid = st.St_Id;
string stno = st.St_No;
string url = Page.ResolveUrl(string.Format("~/SettlementForm.aspx?stid={0}&stno={1}&sourcetype={2}&sourceno={3}", stid, stno, SysConst.SourceTypeOrder, SourceNo));
string script = string.Format("<script>window.open('{0}')</script>", url);
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "createsettle", script);
BindControl();
SetFocus(btnSettlement);
}
protected void btnSave_Click(object sender, EventArgs e)
{
SettlementDAL dal = new SettlementDAL();
var st = dal.GetSettlementByNo(StNo);
if (!string.IsNullOrEmpty(txtDeliveryDate.Text))
{
st.DeliveryDate = DateTime.Parse(txtDeliveryDate.Text);
}
//update st
st.StMan = Utility.GetSelectedText(ddlSettlementMan);
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("|");
}
}
st.DeliveryList = sb.ToString();
st.StLocation = txtSettleLocation.Text;
st.CustomerCompanyName = customerInfoControl.CompanyName;
st.CustomerContactName = customerInfoControl.ContactName;
st.CustomerAddress = customerInfoControl.Address;
st.CustomerEmail = customerInfoControl.Email;
st.CustomerQQ = customerInfoControl.QQ;
st.CustomerPhone1 = customerInfoControl.Phone1;
st.CustomerPhone2 = customerInfoControl.Phone2;
st.CustomerOthers = customerInfoControl.Other;
//settlement
if (!string.IsNullOrEmpty(txtTotalAmount.Text))
{
st.TotalAmount = double.Parse(txtTotalAmount.Text);
}
if (!string.IsNullOrEmpty(txtReceivedFirst.Text))
{
st.FirstAmount = double.Parse(txtReceivedFirst.Text);
}
if (!string.IsNullOrEmpty(txtReceived.Text))
{
st.AmountReceived = double.Parse(txtReceived.Text);
}
st.ReceivableIntro = txtBalanceIntro.Text;
AddFollowUp(followUpControl, st.Status, Utility.GetSelectedText(ddlSettlementStatus));
st.Status = Utility.GetSelectedText(ddlSettlementStatus);
dal.Save();
//save new customer
customerInfoControl.Save();
this.SetFocus(sender);
}
public List <Settlement> GetSettlementList()
{
SettlementDAL dal = new SettlementDAL();
var result = dal.SearchSettlement(txtSettlementId.Text,
Utility.GetSelectedText(ddlSettlementMan),
!string.IsNullOrEmpty(txtBeginDate.Text) ? DateTime.Parse(txtBeginDate.Text) : DateTime.MinValue,
!string.IsNullOrEmpty(txtEndDate.Text) ? DateTime.Parse(txtEndDate.Text) : DateTime.MaxValue,
txtOrderId.Text,
Utility.GetSelectedText(ddlSettlementStatus));
return(result);
}
protected void btnImport_Click(object sender, EventArgs e)
{
SettlementDAL dal = new SettlementDAL();
LineItemDAL lDal = new LineItemDAL();
var settlement = dal.GetSettlementById(StId);
StringBuilder sb = new StringBuilder(256);
List <LineItem> lineItems = new List <LineItem>();
foreach (ListItem item in cblDeliveryList.Items)
{
if (item.Selected)
{
sb.Append(item.Text).Append("|");
lineItems.AddRange(lDal.GetLineItemsBySource(int.Parse(item.Value), SysConst.SourceTypeDelivery));
}
}
settlement.DeliveryList = sb.ToString();
dal.Save();
var dbItems = lDal.GetLineItemsBySource(this.StId, SysConst.SourceTypeSettlement);
foreach (var item in dbItems)
{
lDal.DeleteItem(item.LineItem_Id);
}
foreach (var item in lineItems)
{
LineItem li = new LineItem()
{
Intro = item.Intro,
Name = item.Name,
OriginNo = item.OriginNo,
Project = item.Project,
Quantity = item.Quantity,
Remark = item.Remark,
SourceId = this.StId,
SourceType = SysConst.SourceTypeSettlement,
Spec = item.Spec,
Unit = item.Unit,
UnitPrice = item.UnitPrice
};
lDal.AddLineItem(li);
}
lDal.Save();
UIUtility.BindUserControl(LineItemsControl1, SysConst.SourceTypeSettlement, StId);
}
protected void rpOrderList_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
Order order = e.Item.DataItem as Order;
FollowUpTop3UserControl followUp = e.Item.FindControl("followUpTop3UserControl") as FollowUpTop3UserControl;
UIUtility.BindUserControl(followUp, SysConst.SourceTypeOrder, order.Order_No);
Label lblContractAmount = e.Item.FindControl("lblContractAmount") as Label;
Label lblSettlementAmount = e.Item.FindControl("lblSettlementAmount") as Label;
Label lblReceivedAmount = e.Item.FindControl("lblReceivedAmount") as Label;
Label lblNeedAmount = e.Item.FindControl("lblNeedAmount") as Label;
LineItemDAL lineDAL = new LineItemDAL();
SettlementDAL stDAL = new SettlementDAL();
ReceiptDAL rDAL = new ReceiptDAL();
var contractAmount = lineDAL.GetLineItemsBySource(order.Order_Id, SysConst.SourceTypeOrder).Sum(l => l.UnitPrice * l.Quantity);
var stAmount = stDAL.GetSettlementByOrderNo(order.Order_No).Sum(s => s.TotalAmount);
var receivedAmount = rDAL.GetReceiptBySource(SysConst.SourceTypeOrder, order.Order_No).Sum(r => r.ReceivedAmount);
lblContractAmount.Text = contractAmount.ToString();
lblSettlementAmount.Text = stAmount.ToString();
lblReceivedAmount.Text = receivedAmount.ToString();
var needAmount = stAmount != 0 ? (stAmount - receivedAmount) : (contractAmount - receivedAmount);
lblNeedAmount.Text = needAmount.ToString();
totalContract += contractAmount.GetValueOrDefault();
totalSt += stAmount.GetValueOrDefault();
totalRec += receivedAmount.GetValueOrDefault();
totalNeed += needAmount.GetValueOrDefault();
}
if (e.Item.ItemType == ListItemType.Footer)
{
var lblTotalContract = e.Item.FindControl("lblTotalContract") as Label;
var lblTotalST = e.Item.FindControl("lblTotalST") as Label;
var lblTotalRec = e.Item.FindControl("lblTotalRec") as Label;
var lblTotalNeed = e.Item.FindControl("lblTotalNeed") as Label;
lblTotalContract.Text = totalContract.ToString();
lblTotalNeed.Text = totalNeed.ToString();
lblTotalRec.Text = totalRec.ToString();
lblTotalST.Text = totalSt.ToString();
}
}
protected void btnSaveAmount_Click(object sender, EventArgs e)
{
SettlementDAL dal = new SettlementDAL();
var st = dal.GetSettlementByNo(StNo);
if (!string.IsNullOrEmpty(txtTotalAmount.Text))
{
st.TotalAmount = double.Parse(txtTotalAmount.Text);
}
if (!string.IsNullOrEmpty(txtReceivedFirst.Text))
{
st.FirstAmount = double.Parse(txtReceivedFirst.Text);
}
if (!string.IsNullOrEmpty(txtReceived.Text))
{
st.AmountReceived = double.Parse(txtReceived.Text);
}
st.ReceivableIntro = txtBalanceIntro.Text;
lblEndBalance.Text = ((st.TotalAmount.HasValue ? st.TotalAmount.Value : 0) - (st.AmountReceived.HasValue ? st.AmountReceived.Value : 0)).ToString();
dal.Save();
}
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);
}
public static int DeleteSettlement(int SettlementId, int UserID)
{
return(SettlementDAL.DeleteSettlement(SettlementId, UserID));
}
public DataSet GetSettlementWithSettlment(Int32 SettlementID)
{
return(SettlementDAL.GetSettlementWithSettlment(SettlementID));
}
public DataSet GetSettlementWithBL(Int32 BlNo)
{
return(SettlementDAL.GetSettlementWithBL(BlNo));
}
public List <ISettlement> GetSettlements(SearchCriteria searchCriteria, int locationId)
{
return(SettlementDAL.GetAllSettlements(searchCriteria, locationId));
}
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);
}
}
}
