public DdsDnevnicItem()
{
ddsItemModel = new DdsItemModel();
}
public static DdsDnevnikModel LoadDenevnicItem(int contoId, int type)
{
DdsDnevnikModel result = new DdsDnevnikModel();
result.Num = contoId;
var dbman = new DBManager(DataProvider.Firebird);
dbman.ConnectionString = Entrence.ConnectionString;
try
{
bool master = false;
dbman.Open();
string command =
string.Format("SELECT * FROM DDSDNEV where NOM={0} and KINDACTIVITY={1}", contoId, type);
dbman.ExecuteReader(CommandType.Text, command);
if (dbman.DataReader.Read())
{
result.Id = int.Parse(dbman.DataReader["Id"].ToString());
result.Branch = dbman.DataReader["BRANCH"].ToString();
result.Date = DateTime.Parse(dbman.DataReader["DATADOC"].ToString());
result.DataF = DateTime.Parse(dbman.DataReader["DATAF"].ToString());
result.DocId = dbman.DataReader["DOCN"].ToString();
result.KindActivity = int.Parse(dbman.DataReader["KINDACTIVITY"].ToString());
result.KindDoc = int.Parse(dbman.DataReader["KINDDOC"].ToString());
result.Stoke = dbman.DataReader["STOKE"].ToString();
result.LookupElementID = int.Parse(dbman.DataReader["LOOKUPELEMENTID"].ToString());
result.LookupID = int.Parse(dbman.DataReader["LOOKUPID"].ToString());
result.Suma = Decimal.Parse(dbman.DataReader["SUMA"].ToString());
result.SumaDDS = Decimal.Parse(dbman.DataReader["DDSSUMA"].ToString());
result.NameKontr = dbman.DataReader["NAMEKONTR"].ToString();
result.CodeDoc = dbman.DataReader["CODEDOC"].ToString();
result.Nzdds = dbman.DataReader["NZDDS"].ToString();
result.Bulstat = dbman.DataReader["BULSTAD"].ToString();
result.ClNum = dbman.DataReader["CLNUM"].ToString();
int val;
result.A8 = int.TryParse(dbman.DataReader["A8"].ToString(), out val)?val:0;
result.IsSuma = int.TryParse(dbman.DataReader["ISSUMA"].ToString(), out val) ? val : 0;
master = true;
result.IsLinked = true;
}
dbman.DataReader.Close();
if (master)
{
string typednev = "DDSDNEVFIELDS";
if (type == 1)
{
typednev = "DDSDNEVSELLSFIELDS";
}
command =
string.Format("SELECT * FROM {0} a inner join DDSDNEVTOFIELDS m on a.ID=m.IDDDSFIELD where m.IDDDSDNEV={1}", typednev, result.Id);
dbman.ExecuteReader(CommandType.Text, command);
while (dbman.DataReader.Read())
{
var n = new DdsItemModel
{
Name = dbman.DataReader["NAME"].ToString(),
Id = int.Parse(dbman.DataReader["IDDDSFIELD"].ToString()),
Code = dbman.DataReader["CODE"].ToString(),
IsNotComputed = true,
In = true
};
n.DdsPercent = decimal.Parse(dbman.DataReader["DDSP"].ToString());
n.DdsSuma = decimal.Parse(dbman.DataReader["SUMADDS"].ToString());
n.Dds = decimal.Parse(dbman.DataReader["DDS"].ToString());
n.DdsTotal = decimal.Parse(dbman.DataReader["SUMAWITHDDS"].ToString());
n.IsNotComputed = false;
result.DetailItems.Add(n);
}
dbman.DataReader.Close();
}
else
{
string typednev = "DDSDNEVFIELDS";
if (type == 1)
{
typednev = "DDSDNEVSELLSFIELDS";
}
command = string.Format("SELECT * FROM {0}", typednev);
dbman.ExecuteReader(CommandType.Text, command);
while (dbman.DataReader.Read())
{
result.DetailItems.Add(new DdsItemModel
{
DdsPercent = int.Parse(dbman.DataReader["DDSPERCENT"].ToString()),
Name = dbman.DataReader["NAME"].ToString(),
Id = int.Parse(dbman.DataReader["ID"].ToString()),
Code = dbman.DataReader["CODE"].ToString(),
IsNotComputed = false,
});
}
//command =
//string.Format("SELECT * FROM DDSDNEVFIELDS a where a.\"TYPE\"={0}", typednev);
//dbman.ExecuteReader(CommandType.Text, command);
//while (dbman.DataReader.Read())
//{
// result.DetailItems.Add(new DdsItemModel
// {
// DdsPercent = int.Parse(dbman.DataReader["DDSPERCENT"].ToString()),
// DdsSuma =0,
// Name = dbman.DataReader["NAME"].ToString(),
// Id = int.Parse(dbman.DataReader["ID"].ToString())
// });
//}
dbman.DataReader.Close();
}
}
catch (Exception e)
{
Logger.Instance().WriteLogError(e.Message, "public static DdsDnevnikModel LoadDenevnicItem(int contoId,int type)");
}
finally
{
dbman.Dispose();
}
return(result);
}
public DdsDnevnicItem(DdsItemModel ddsItem)
{
ddsItemModel = ddsItem;
}
