/// <summary>
/// 删除销售订单主表
/// </summary>
/// <param name="so">销售订单主表</param>
/// <returns></returns>
public bool DeleteSaleOrder(T_saleorder so)
{
using (MEMSContext db = new MEMSContext())
{
db.Entry(so).State = EntityState.Deleted;
return db.SaveChanges() > 0 ? true : false;
}
}
/// <summary>
/// 添加新销售订单主从表信息
/// </summary>
/// <param name="so">主表对象</param>
/// <param name="sdlist">从表对象</param>
/// <returns></returns>
public bool AddNewSaleOrder(T_saleorder so, List<T_saledetail> sdlist)
{
using (MEMSContext db = new MEMSContext())
{
db.Entry(so).State = EntityState.Added;
db.SaveChanges();
foreach (var sd in sdlist)
{
sd.soid = so.id;
db.Entry(sd).State = EntityState.Added;
}
return db.SaveChanges() > 0 ? true : false;
}
}
protected override void FormLoad()
{
base.FormLoad();
InitCustomerCmb();
//DisPlayEnum.ExtGetEnumDS(lkpPeriodUnit, typeof(periodUnit));
var pUds = DisPlayEnum.getEnumDS(typeof(periodUnit));
lkpPeriodUnit.ExtBindingDataSource(pUds, "key", "value");
//DisPlayEnum.ExtGetEnumDS(lkpRevType, typeof(receiveType));
var rtds = DisPlayEnum.getEnumDS(typeof(receiveType));
lkpRevType.ExtBindingDataSource(rtds, "key", "value");
this.barbtn1.Visibility = BarItemVisibility.Always;
this.barbtn1.LargeImageIndex = 8;
gcSaledetail.DataSource = m_saleProducts;
if (formmode == frmmodetype.add)
{
m_saleorder = new T_saleorder();
}
else if (formmode == frmmodetype.edit)
{
m_saleorder = m_ssclient.getSaleOrderbyId(m_soid);
SetData(m_saleorder);
m_saleProducts = m_ssclient.getSaleProductbysoid(m_soid);
gcSaledetail.DataSource = m_saleProducts;
gvSaledetail.RefreshData();
colpcode.OptionsColumn.AllowEdit = false;
colpname.OptionsColumn.AllowEdit = false;
colpspec.OptionsColumn.AllowEdit = false;
colpmodelprice.OptionsColumn.AllowEdit = false;
colpunitprice.OptionsColumn.AllowEdit = false;
colptotalprice.OptionsColumn.AllowEdit = false;
}
else if (formmode == frmmodetype.delete)
{
m_saleorder = m_ssclient.getSaleOrderbyId(m_soid);
SetData(m_saleorder);
readonlytxtbox(this.Controls, true);
gvSaledetail.OptionsBehavior.Editable = false;
m_saleProducts = m_ssclient.getSaleProductbysoid(m_soid);
gcSaledetail.RefreshDataSource();
}
}
/// <summary>
/// 设置数据至控件
/// </summary>
/// <param name="saleOrder"></param>
private void SetData(T_saleorder saleOrder)
{
txtSono.Text = saleOrder.saleno;
txtOrderAmt.Text = saleOrder.saletotalamount.HasValue ? saleOrder.saletotalamount.Value.ToString() : "";
txtPeriod.Text = saleOrder.receiveperiod.HasValue ? saleOrder.receiveperiod.Value.ToString() : "";
txtremarks.Text = saleOrder.remarks;
if (saleOrder.receiveamount.HasValue)
{
txtRevAmt.Text = saleOrder.receiveamount.Value.ToString();
}
//txtRevAmt.Text = saleOrder.receiveamount.HasValue ? saleOrder.receiveamount.Value.ToString() : "";
//txtRevRatio.Text = (saleOrder.receiveratio.HasValue ? saleOrder.receiveratio.Value.ToString() : "0") + "%";
txtRevRatio.Text = saleOrder.receiveratio;
//txtRevStatus.Text = DisPlayEnum.getEnumName(typeof(receiveState), saleOrder.receivestate);
txtRevStatus.Text = ((receiveState)saleOrder.receivestate).ToString();
//txtOrderStatus.Text = DisPlayEnum.getEnumName(typeof(orderState), saleOrder.orderstate);
txtOrderStatus.Text = ((orderState)saleOrder.orderstate).ToString();
dateSaleOrder.DateTime = saleOrder.saledate;
lkpPeriodUnit.EditValue = saleOrder.receiveperiodtype;
lkpRevType.EditValue = saleOrder.receivetype;
lkpcustomer.EditValue = saleOrder.customerid;
InitQt(saleOrder.customerid);
lkpqtno.EditValue = saleOrder.quotationid;
}
private void getData(T_saleorder saleOrder)
{
saleOrder.saleno = txtSono.Text;
if (lkpcustomer.EditValue == null)
{
throw new Exception("请选择客户");
}
saleOrder.customerid = (int)lkpcustomer.EditValue;
if (lkpqtno.EditValue == null)
{
throw new Exception("请选择报价单");
}
saleOrder.quotationid = (int)lkpqtno.EditValue;
saleOrder.saledate = dateSaleOrder.DateTime;
saleOrder.saletotalamount = txtOrderAmt.Text == "" ? 0 : Convert.ToDecimal(txtOrderAmt.Text);
//saleOrder.receiveamount = Convert.ToDecimal(txtRevAmt.Text);
//saleOrder.receiveratio = Convert.ToDecimal(txtRevRatio.Text);
if (lkpRevType.EditValue == null)
{
throw new Exception("请选择收款类型");
}
saleOrder.receivetype = (int)lkpRevType.EditValue;
if (lkpPeriodUnit.EditValue == null)
{
throw new Exception("请选择账期类型");
}
saleOrder.receiveperiodtype = (int)lkpPeriodUnit.EditValue;
saleOrder.receiveperiod = txtPeriod.Text == "" ? 0 : Convert.ToInt32(txtPeriod.Text);
saleOrder.remarks = txtremarks.Text;
}
protected override void FormLoad()
{
base.FormLoad();
var customerlst = m_crmclient.getCustomerList();
lkpcustomer.ExtBindingDataSource<T_Customer>(customerlst, "id", "customername");
var pUds = DisPlayEnum.getEnumDS(typeof(periodUnit));
lkpPeriodUnit.ExtBindingDataSource(pUds, "key", "value");
var rtds = DisPlayEnum.getEnumDS(typeof(receiveType));
lkpRevType.ExtBindingDataSource(rtds, "key", "value");
readonlytxtbox(this.Controls, true);
m_saleorder = m_ssclient.getSaleOrderbyId(m_soid);
SetData(m_saleorder);
if (m_saleorder.receivetype == (int)receiveType.按产品明细收款)
{
m_saleProducts = m_ssclient.getSaleProductbysoid(m_soid);
gcRecieve.DataSource = m_saleProducts;
gcRecieve.MainView = gvSaledetail;
//gvSaledetail.RefreshData();
colpcount.OptionsColumn.AllowEdit = false;
colpcode.OptionsColumn.AllowEdit = false;
colpname.OptionsColumn.AllowEdit = false;
colpspec.OptionsColumn.AllowEdit = false;
colpmodelprice.OptionsColumn.AllowEdit = false;
colpunitprice.OptionsColumn.AllowEdit = false;
colptotalprice.OptionsColumn.AllowEdit = false;
colpcount.OptionsColumn.AllowEdit = false;
}
else
{
this.barbtn1.Visibility = BarItemVisibility.Always;
this.barbtn1.LargeImageIndex = 8;
this.barbtn1.Caption = "收款登记";
this.ribbonPageGroup2.Visible = true;
m_saleRev = m_ssclient.getSaleRevbySoid(m_soid);
gcRecieve.DataSource = m_saleRev;
gcRecieve.MainView = gvSaleRev;
colsrid.Visible = false;
colsoid.Visible = false;
coluid.OptionsColumn.AllowEdit = false;
}
}