本文整理汇总了C#中bycar.DataAccess.OverpricingOfferingGet方法的典型用法代码示例。如果您正苦于以下问题:C# DataAccess.OverpricingOfferingGet方法的具体用法?C# DataAccess.OverpricingOfferingGet怎么用?C# DataAccess.OverpricingOfferingGet使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类bycar.DataAccess
的用法示例。
在下文中一共展示了DataAccess.OverpricingOfferingGet方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: LoadOfferings
public decimal LoadOfferings()
{
if (Item != null)
{
da = new DataAccess();
List<SpareInOverpricingView> items = da.OverpricingOfferingGet(Item.id);
dgSpares.DataContext = items;
}
return 0;
}
示例2: Window_Activated
private void Window_Activated(object sender, EventArgs e)
{
if (Outgo == null)
return;
try
{
ReportDocument reportDocument = new ReportDocument();
StreamReader reader = new StreamReader(new FileStream(@"Templates\OverpricingReport.xaml", FileMode.Open, FileAccess.Read));
reportDocument.XamlData = reader.ReadToEnd();
reportDocument.XamlImagePath = System.IO.Path.Combine(Environment.CurrentDirectory, @"Templates\");
reader.Close();
ReportData data = new ReportData();
DataAccess da = new DataAccess();
// Таблица ТОВАРЫ В НАКЛАДНОЙ
DataTable dt = new DataTable("mtable");
// описываем столбцы таблицы
dt.Columns.Add("t1", typeof(string));
dt.Columns.Add("t2", typeof(string));
dt.Columns.Add("t3", typeof(string));
dt.Columns.Add("t4", typeof(string));
dt.Columns.Add("t5", typeof(string));
dt.Columns.Add("t6", typeof(string));
dt.Columns.Add("t7", typeof(string));
dt.Columns.Add("t8", typeof(string));
dt.Columns.Add("t9", typeof(string));
dt.Columns.Add("t10", typeof(string));
decimal sum1 = 0;
decimal sum2 = 0;
decimal sum3 = 0;
// забиваем таблицу данными
List<SpareInOverpricingView> LIST2 = da.OverpricingOfferingGet(ItemID);
try
{
string CompanyName = da.getProfileCurrent().CompanyName;
for (int i = 0; i < LIST2.Count; i++)
{
sum1 += LIST2[i].quantity.Value;
sum2 += LIST2[i].sumOld.Value;
sum3 += LIST2[i].sumNew.Value;
dt.Rows.Add(new object[] {
LIST2[i].SpareName,
LIST2[i].UnitName,
LIST2[i].quantity,
LIST2[i].purchasePrice,
LIST2[i].percentOld,
LIST2[i].priceOld,
LIST2[i].sumOld,
LIST2[i].percentNew,
LIST2[i].priceNew,
LIST2[i].sumNew
});
}
}
catch (Exception exc)
{
Marvin.Instance.Log(exc.Message);
throw exc;
}
string strDate = Outgo.createdOn.Value.Day.ToString();
string mnth = "";
switch (Outgo.createdOn.Value.Month)
{
case 1:
mnth = "января";
break;
case 2:
mnth = "февраля";
break;
case 3:
mnth = "марта";
break;
case 4:
mnth = "апреля";
break;
case 5:
mnth = "мая";
break;
case 6:
mnth = "июня";
break;
case 7:
mnth = "июля";
break;
case 8:
mnth = "августа";
break;
//.........这里部分代码省略.........