static public void ShowMatListByWH3(BaseEntities db, WaybillList wb, String WID)
{
using (var f = new frmWhCatalog(1))
{
f.uc.xtraTabPage4.PageVisible = false;
f.uc.xtraTabPage5.PageVisible = false;
f.uc.xtraTabPage9.PageVisible = false;
f.uc.MatListTabPage.PageVisible = true;
f.uc.xtraTabControl1.SelectedTabPageIndex = 4;
f.uc.gridColumn49.Visible = false;
f.uc.gridColumn51.Visible = false;
f.uc.gridColumn52.Visible = false;
f.uc.MatListGridColumnWh.Visible = (WID == "*");
f.uc.bar3.Visible = false;
f.uc.ByWhBtn.Down = true;
f.uc.splitContainerControl1.SplitterPosition = 0;
using (var _db = new BaseEntities())
{
int wid;
if (int.TryParse(WID, out wid))
{
f.uc.WHTreeList.DataSource = _db.GetWhTree(DBHelper.CurrentUser.UserId, 2).Where(w => w.GType == 1 && w.Num == wid).ToList();
}
else
{
f.uc.WHTreeList.DataSource = _db.GetWhTree(DBHelper.CurrentUser.UserId, 2).Where(w => w.GType == 1).ToList();
}
f.uc.GrpNameGridColumn.GroupIndex = 0;
}
f.uc.wb = wb;
f.uc.isMatList = true;
if (f.ShowDialog() == DialogResult.OK)
{
foreach (var item in f.uc.custom_mat_list)
{
var wbd = db.WaybillDet.Add(new WaybillDet
{
WbillId = wb.WbillId,
OnDate = wb.OnDate,
MatId = item.MatId,
WId = (WID != "*") ? Convert.ToInt32(WID) : item.WId,
Amount = item.Amount,
Price = item.AvgPrice,// item.Price ,
Discount = wb.WType == -20 ? item.Amount : 0,
Nds = wb.Nds,
CurrId = wb.CurrId,
OnValue = wb.OnValue,
BasePrice = item.AvgPrice,// item.Price,
PosKind = 0,
PosParent = 0,
DiscountKind = 0
});
}
db.SaveChanges();
}
}
}
public frmAttEdit(WaybillList wb)
{
InitializeComponent();
_wb = wb;
WaybillListBS.DataSource = wb;
}
public frmCashboxCheckout(BaseEntities db, WaybillList wb)
{
InitializeComponent();
_db = db;
_wb = wb;
}
public frmWayBillTMCDet(BaseEntities db, int?PosId, WaybillList wb)
{
InitializeComponent();
_db = db;
_PosId = PosId;
_wb = wb;
}
static public void ShowMatListByWH(BaseEntities db, WaybillList wb, DiscCards disc_card = null)
{
var f = new frmWhCatalog(1, disc_card);
// f.uc.xtraTabPage3.PageVisible = false;
f.uc.xtraTabPage4.PageVisible = false;
f.uc.xtraTabPage5.PageVisible = false;
f.uc.xtraTabPage9.PageVisible = false;
f.uc.xtraTabPage11.PageVisible = false;
f.uc.MatListTabPage.PageVisible = true;
f.uc.xtraTabControl1.SelectedTabPageIndex = 4;
f.uc.wb = wb;
f.uc.isMatList = true;
if (f.ShowDialog() == DialogResult.OK)
{
var num = wb.WaybillDet.Count();
foreach (var item in f.uc.custom_mat_list)
{
var wbd = new WaybillDet
{
WbillId = wb.WbillId,
Num = ++num,
OnDate = wb.OnDate,
MatId = item.MatId,
WId = item.WId,
Amount = item.Amount,
Price = item.Price - (item.Price * item.Discount / 100),
PtypeId = item.PTypeId,
Discount = item.Discount,
Nds = wb.Nds,
CurrId = wb.CurrId,
OnValue = wb.OnValue,
BasePrice = item.Price + Math.Round(item.Price.Value * wb.Nds.Value / 100, 2),
PosKind = 0,
PosParent = 0,
DiscountKind = disc_card != null ? 2 : 0,
};
db.WaybillDet.Add(wbd);
db.SaveChanges();
if (wb.WType == 16)
{
db.WMatTurn.Add(new WMatTurn()
{
SourceId = wbd.PosId,
PosId = wbd.PosId,
WId = wbd.WId.Value,
MatId = wbd.MatId,
OnDate = wbd.OnDate.Value,
TurnType = 3,
Amount = wbd.Amount
});
}
}
db.SaveChanges();
}
}
public frmWBReturnDetOut(BaseEntities db, int?PosId, WaybillList wb, int ka_id)
{
InitializeComponent();
_db = db;
_PosId = PosId;
_wb = wb;
_ka_id = ka_id;
}
public frmWBMoveDet(BaseEntities db, int?PosId, WaybillList wb)
{
InitializeComponent();
_db = db;
_PosId = PosId;
_wb = wb;
_ka_id = 0;
}
public frmWBInventoryDet(BaseEntities db, int?PosId, WaybillList wb)
{
InitializeComponent();
_db = db;
_PosId = PosId;
_wb = wb;
WHComboBox.Properties.DataSource = DBHelper.WhList;
// MatComboBox.Properties.DataSource = db.MaterialsList.ToList();
}
public frmWayBillDetIn(BaseEntities db, int?PosId, WaybillList wb)
{
InitializeComponent();
_db = db;
_wb = wb;
_PosId = PosId;
WHComboBox.Properties.DataSource = DBHelper.WhList;
MatComboBox.Properties.DataSource = db.MaterialsList.ToList();
ProducerTextEdit.Properties.Items.AddRange(_db.WayBillDetAddProps.Where(w => w.Producer != null).Select(s => s.Producer).Distinct().ToList());
}
static public void ShowMatListByWH2(BaseEntities db, WaybillList wb, int ka_id)
{
//Не доделано
var f = new frmWhCatalog(1);
f.uc.xtraTabPage4.PageVisible = false;
f.uc.xtraTabPage5.PageVisible = false;
f.uc.xtraTabPage9.PageVisible = false;
f.uc.MatListTabPage.PageVisible = true;
f.uc.xtraTabControl1.SelectedTabPageIndex = 4;
f.uc.gridColumn49.Visible = false;
f.uc.gridColumn51.Visible = false;
f.uc.gridColumn52.Visible = false;
f.uc.bar3.Visible = false;
f.uc.ByWhBtn.Down = true;
f.uc.splitContainerControl1.SplitterPosition = 0;
f.uc.whKagentList.EditValue = ka_id;
f.uc.whKagentList.Enabled = false;
f.uc.WHTreeList.DataSource = new BaseEntities().GetWhTree(DBHelper.CurrentUser.UserId, 2).Where(w => w.GType == 1).ToList();
f.uc.GrpNameGridColumn.GroupIndex = 0;
f.uc.wb = wb;
f.uc.isMatList = true;
if (f.ShowDialog() == DialogResult.OK)
{
foreach (var item in f.uc.custom_mat_list)
{
var wbd = db.WaybillDet.Add(new WaybillDet
{
WbillId = wb.WbillId,
OnDate = wb.OnDate,
MatId = item.MatId,
WId = item.WId,
Amount = item.Amount,
Price = item.Price,
Discount = 0,
Nds = wb.Nds,
CurrId = wb.CurrId,
OnValue = wb.OnValue,
BasePrice = item.Price,
PosKind = 0,
PosParent = 0,
DiscountKind = 0
});
}
db.SaveChanges();
}
}
public frmWBReturnDetIn(BaseEntities db, int?PosId, WaybillList wb, int?wid, DateTime start_date)
{
InitializeComponent();
_db = db;
_PosId = PosId;
_wb = wb;
_def_wid = wid;
_start_date = start_date;
WHComboBox.Properties.DataSource = DBHelper.WhList;
com_port = new ComPortHelper(Settings.Default.com_port_name, Convert.ToInt32(Settings.Default.com_port_speed));
}
private void GetDocValue(WaybillList wb)
{
_wbill_id = wb.WbillId;
NumEdit.Text = wb.Num;
OnDateDBEdit.DateTime = wb.OnDate;
KagentComboBox.EditValue = wb.KaId;
PersonComboBox.EditValue = wb.PersonId;
TurnDocCheckBox.Checked = Convert.ToBoolean(wb.Checked);
ReasonEdit.Text = wb.Reason;
NotesEdit.Text = wb.Notes;
PersonComboBox.EditValue = wb.PersonId;
payDocUserControl1.OnLoad(_db, wb);
KagentComboBox.Enabled = !payDocUserControl1.IsPayDoc();
}
public frmWayBillDetOut(BaseEntities db, int?PosId, WaybillList wb, DiscCards cart)
{
InitializeComponent();
_db = db;
_PosId = PosId;
_wb = wb;
_cart = cart;
WHComboBox.Properties.DataSource = DBHelper.WhList;
MatComboBox.Properties.DataSource = db.MaterialsList.ToList();
PriceTypesEdit.Properties.DataSource = DB.SkladBase().PriceTypes.ToList();
ProducerTextEdit.Properties.Items.AddRange(_db.WayBillDetAddProps.Where(w => w.Producer != null).Select(s => s.Producer).Distinct().ToList());
panel3.Visible = barCheckItem1.Checked;
if (!barCheckItem1.Checked)
{
Height -= panel3.Height;
}
panel4.Visible = barCheckItem2.Checked;
if (!barCheckItem2.Checked)
{
Height -= panel4.Height;
}
panel5.Visible = barCheckItem3.Checked;
if (!barCheckItem3.Checked)
{
Height -= panel5.Height;
}
if (DBHelper.CurrentUser.ShowPrice == 0)
{
if (barCheckItem2.Checked)
{
barCheckItem2.PerformClick();
}
barCheckItem2.Visibility = BarItemVisibility.Never;
}
BasePriceEdit.Enabled = new UserSettingsRepository(DBHelper.CurrentUser.UserId, _db).AccessEditPrice;
PriceTypesEdit.Enabled = BasePriceEdit.Enabled;
panelControl4.Enabled = BasePriceEdit.Enabled;
}
public override IEnumerable <Waybill> GetAll()
{
connection.Command.Parameters.Clear();
connection.Command.CommandText = "select * from путевые_листы";
WaybillList list = new WaybillList();
using (MySqlDataReader reader = connection.Command.ExecuteReader())
{
if (reader.HasRows) // если есть данные
{
while (reader.Read())
{
list.Add(new Waybill((int)reader.GetValue(0), (double)reader.GetValue(3), (DateTime)reader.GetValue(4), (int)reader.GetValue(1), (int)reader.GetValue(2)));
}
}
}
return(list);
}
public frmSetCustomDiscount(BaseEntities db, WaybillList wb)
{
InitializeComponent();
_db = db;
_wb = wb;
}
public frmSetWBNote(WaybillList wb)
{
InitializeComponent();
_wb = wb;
}
public void OnLoad(BaseEntities db, WaybillList wb)
{
_db = db;
_wb = wb;
if (new int[] { -1, -6, 2, -16 }.Contains(_wb.WType)) // Вхідний платіж
{
_user_Access = _db.GetUserAccessTree(DBHelper.CurrentUser.UserId).ToList().FirstOrDefault(w => w.FunId == 26);
}
else
{
_user_Access = _db.GetUserAccessTree(DBHelper.CurrentUser.UserId).ToList().FirstOrDefault(w => w.FunId == 25); //Вихідні платежі
}
panelControl1.Visible = _user_Access.CanView == 1;
var rel = db.GetRelDocList(wb.Id).FirstOrDefault(w => w.DocType == -3 || w.DocType == 3);
if (rel != null)
{
try
{
var PayDocId = db.PayDoc.AsNoTracking().FirstOrDefault(f => f.Id == rel.Id).PayDocId;
_pd = db.Database.SqlQuery <PayDoc>("select * from PayDoc WITH (UPDLOCK, NOWAIT) where PayDocId = {0}", PayDocId).FirstOrDefault();
}
catch
{
panelControl1.Enabled = false;
}
if (_pd != null)
{
_db.Entry(_pd).State = System.Data.Entity.EntityState.Modified;
ExecPayCheckBox.EditValue = _pd.Checked;
NumEdit.EditValue = _pd.DocNum;
PTypeComboBox.EditValue = _pd.PTypeId;
CashEditComboBox.EditValue = _pd.CashId;
ChargeTypesEdit.EditValue = _pd.CTypeId;
SumEdit.EditValue = _pd.Total;
CurrencyLookUpEdit.EditValue = _pd.CurrId;
AccountEdit.EditValue = _pd.AccId;
}
}
else
{
ExecPayCheckBox.EditValue = 0;
PTypeComboBox.EditValue = 1;
CurrencyLookUpEdit.EditValue = DBHelper.Currency.Where(w => w.Def == 1).Select(s => s.CurrId).FirstOrDefault(); //Валюта по умолчанию
if (DBHelper.CashDesks.Any(w => w.Def == 1))
{
CashEditComboBox.EditValue = DBHelper.CashDesks.FirstOrDefault(w => w.Def == 1).CashId;
}
else if (DBHelper.CashDesks.Any())
{
CashEditComboBox.EditValue = DBHelper.CashDesks.FirstOrDefault().CashId;
}
}
panelControl1.Enabled = (_user_Access.CanModify == 1 || (_user_Access.CanInsert == 1 && _pd == null)) && DBHelper.CashDesks.Any() && DBHelper.CashDesks.Any(a => a.CashId == Convert.ToInt32(CashEditComboBox.EditValue));
ExecPayCheckBox.Enabled = _user_Access.CanPost == 1 || (_user_Access.CanInsert == 1 && _pd == null);
PTypeComboBox.Properties.DataSource = DBHelper.PayTypes;
CashEditComboBox.Properties.DataSource = panelControl1.Enabled ? DBHelper.CashDesks : DBHelper.AllCashDesks;
ChargeTypesEdit.Properties.DataSource = DBHelper.ChargeTypes;
if (DBHelper.ChargeTypes.Any(a => a.Def == 1))
{
ChargeTypesEdit.EditValue = DBHelper.ChargeTypes.FirstOrDefault(f => f.Def == 1).CTypeId;
}
CurrencyLookUpEdit.Properties.DataSource = _db.Currency.ToList();
var ent_id = DBHelper.Enterprise.KaId;
user_acc_list = _db.EnterpriseAccount.Where(w => w.KaId == ent_id).Select(s => new user_acc
{
AccId = s.AccId,
AccNum = s.AccNum,
Name = s.BankName,
ExtDocType = 1
}).ToList() /*.Concat(_db.KAgentAccount.Where(w => w.KAId == _wb.KaId).Select(s => new user_acc
* {
* AccId = s.AccId,
* AccNum = s.AccNum,
* Name = s.Kagent.Name,
* ExtDocType = -1
* }).ToList()).ToList()*/;
AccountEdit.Properties.DataSource = user_acc_list;
}
public double GetDistance(WaybillList WBList)
{
return(WBList.GetFullDistanceForDriverId(Id));
}
static public void ShowMatList(BaseEntities db, WaybillList wb)
{
var f = new frmCatalog(2);
f.uc.xtraTabPage3.PageVisible = false;
f.uc.xtraTabPage4.PageVisible = false;
f.uc.xtraTabPage5.PageVisible = false;
f.uc.xtraTabPage12.PageVisible = false;
f.uc.xtraTabPage13.PageVisible = false;
f.uc.xtraTabPage14.PageVisible = true;
f.uc.wb = wb;
f.uc.isMatList = true;
if (f.ShowDialog() == DialogResult.OK)
{
foreach (var item in f.uc.custom_mat_list.OrderBy(o => o.Num).ToList())
{
var price = (item.Price ?? 0);
var wbd = db.WaybillDet.Add(new WaybillDet
{
WbillId = wb.WbillId,
Num = wb.WaybillDet.Count(),
MatId = item.MatId,
WId = item.WId,
Amount = item.Amount,
Price = price,
Discount = 0,
Nds = wb.Nds,
CurrId = wb.CurrId,
OnDate = wb.OnDate,
OnValue = wb.OnValue,
BasePrice = price + Math.Round(price * wb.Nds.Value / 100, 2),
PosKind = 0,
PosParent = 0,
DiscountKind = 0
});
if (wb.WType == -16)
{
var dis = db.GetDiscount(wb.KaId, item.MatId).FirstOrDefault() ?? 0.00m;
wbd.Discount = dis;
wbd.Price = item.Price - Math.Round((item.Price.Value * dis / 100), 2);
wbd.BasePrice = item.Price + Math.Round(item.Price.Value * wb.Nds.Value / 100, 2);
}
db.SaveChanges();
if (wb.WType == 16)
{
db.WMatTurn.Add(new WMatTurn()
{
SourceId = wbd.PosId,
PosId = wbd.PosId,
WId = wbd.WId.Value,
MatId = wbd.MatId,
OnDate = wbd.OnDate.Value,
TurnType = 3,
Amount = wbd.Amount
});
}
}
db.Save(wb.WbillId);
}
}
public double GetDistance(WaybillList WBList)
{
return(WBList.GetFullDistanceForCarId(id));
}
