public void Sel(System.Windows.Forms.ListView Alv)
{
string sql;
string [] lstitm = new string [4];
Alv.Columns.RemoveAt(2);
System.Windows.Forms.ColumnHeader Sel_dltt = new System.Windows.Forms.ColumnHeader();
System.Windows.Forms.ColumnHeader Sel_dlttid = new System.Windows.Forms.ColumnHeader();
Alv.Columns.AddRange(new System.Windows.Forms.ColumnHeader[] {
Sel_dlttid,
Sel_dltt
});
Sel_dlttid.Text = "Suppliertype ID";
Sel_dlttid.Width = 40;
Sel_dltt.Text = "Suppliertype";
Sel_dltt.Width = 180;
// get the first suiteable title and return it
CatV workDS = new CatV();
sql = String.Format("Select * from tdbadmin.tdbv_cat where s_id = {0} order by bez", tdb.User.Ulangid);
FillDs(workDS, sql, new string[] { "tdbv_cat" });
foreach (CatV.tdbv_catRow Rwork in workDS.tdbv_cat)
{
lstitm[0] = Convert.ToString(Rwork.CAT_ID);
lstitm[1] = Rwork.BEZ;
lstitm[2] = Convert.ToString(Rwork.SUPTYPID);
lstitm[3] = Rwork.SUPTYP;
Alv.Items.Add(new ListViewItem(lstitm));
}
}
public void Sel(System.Windows.Forms.ListView Alv)
{
string sql;
string [] lstitm = new string [4];
Alv.Columns.RemoveAt(2);
System.Windows.Forms.ColumnHeader Sel_dltt = new System.Windows.Forms.ColumnHeader();
System.Windows.Forms.ColumnHeader Sel_dlttid = new System.Windows.Forms.ColumnHeader();
Alv.Columns.AddRange(new System.Windows.Forms.ColumnHeader[] {
Sel_dlttid,
Sel_dltt});
Sel_dlttid.Text = "Suppliertype ID";
Sel_dlttid.Width = 40;
Sel_dltt.Text = "Suppliertype";
Sel_dltt.Width = 180;
// get the first suiteable title and return it
CatV workDS = new CatV();
sql = String.Format("Select * from tdbadmin.tdbv_cat where s_id = {0} order by bez", tdb.User.Ulangid);
FillDS(workDS, sql, new string[] { "tdbv_cat" });
foreach (CatV.tdbv_catRow Rwork in workDS.tdbv_cat)
{
lstitm[0] = Convert.ToString(Rwork.CAT_ID);
lstitm[1] = Rwork.BEZ;
lstitm[2] = Convert.ToString(Rwork.SUPTYPID);
lstitm[3] = Rwork.SUPTYP;
Alv.Items.Add(new ListViewItem(lstitm));
}
}
public override void Get(int Aid, ref int Arows)
{
string sql;
int rows;
CatV workDS;
// get the first suiteable title and return it
workDS = new CatV();
sql = String.Format("Select * from tdbadmin.tdbv_cat where cat_id = {0} and s_id = {1}", Aid, tdb.User.Ulangid);
FillDs(workDS, sql, new string[] { "tdbv_cat" });
Arows = workDS.tdbv_cat.Rows.Count;
CatV.tdbv_catRow Rwork = workDS.tdbv_cat[0];
// set variables now
id = Rwork.CAT_ID;
bez = Rwork.BEZ;
bez_id = Rwork.BEZ_ID;
hkat_id = Rwork.H_KAT_ID;
suptid = Rwork.SUPTYPID;
supt = Rwork.SUPTYP;
color = Rwork.GA;
text_id = Rwork.TEXTID;
if (text_id > 0)
{
rows = GetText();
}
else
{
text = "";
}
}
public override global::System.Data.DataSet Clone()
{
CatV cln = ((CatV)(base.Clone()));
cln.InitVars();
cln.SchemaSerializationMode = this.SchemaSerializationMode;
return(cln);
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
CatV ds = new CatV();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
public void SelTree(System.Windows.Forms.TreeView Atv)
{
string sql;
CatV workDS = new CatV();
sql = String.Format("Select * from tdbadmin.tdbv_cat where s_id = {0} and h_kat_id < 1 order by bez", tdb.User.Ulangid);
FillDS(workDS, sql, new string[] { "tdbv_cat" });
foreach (CatV.tdbv_catRow Rwork in workDS.tdbv_cat)
{
TreeNode RootNode = new TreeNode(Rwork.BEZ);
RootNode.Tag = Rwork.CAT_ID;
Atv.Nodes.Add(RootNode);
GetChild(Rwork.CAT_ID, RootNode);
}
}
public void SelTree(System.Windows.Forms.TreeView Atv)
{
string sql;
CatV workDS = new CatV();
sql = String.Format("Select * from tdbadmin.tdbv_cat where s_id = {0} and h_kat_id < 1 order by bez", tdb.User.Ulangid);
FillDs(workDS, sql, new string[] { "tdbv_cat" });
foreach (CatV.tdbv_catRow Rwork in workDS.tdbv_cat)
{
TreeNode RootNode = new TreeNode(Rwork.BEZ);
RootNode.Tag = Rwork.CAT_ID;
Atv.Nodes.Add(RootNode);
GetChild(Rwork.CAT_ID, RootNode);
}
}
private void GetChild(int Aparentid, TreeNode Aparentnode)
{
string sql;
int rows;
CatV workDS = new CatV();
sql = String.Format("Select * from tdbadmin.tdbv_cat where s_id = {0} and h_kat_id = {1} order by bez", tdb.User.Ulangid, Aparentid);
FillDs(workDS, sql, new string[] { "tdbv_cat" });
rows = workDS.tdbv_cat.Rows.Count;
if (rows < 1)
{
return;
}
foreach (CatV.tdbv_catRow Rwork in workDS.tdbv_cat)
{
TreeNode ChildNode = new TreeNode(Rwork.BEZ);
ChildNode.Tag = Rwork.CAT_ID;
Aparentnode.Nodes.Add(ChildNode);
GetChild(Rwork.CAT_ID, ChildNode);
}
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
CatV ds = new CatV();
global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "tdbv_catDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
private void GetChild(int Aparentid, TreeNode Aparentnode)
{
string sql;
int rows;
CatV workDS = new CatV();
sql = String.Format("Select * from tdbadmin.tdbv_cat where s_id = {0} and h_kat_id = {1} order by bez", tdb.User.Ulangid, Aparentid);
FillDS(workDS, sql, new string[] { "tdbv_cat" });
rows = workDS.tdbv_cat.Rows.Count;
if (rows < 1)
return;
foreach (CatV.tdbv_catRow Rwork in workDS.tdbv_cat)
{
TreeNode ChildNode = new TreeNode(Rwork.BEZ);
ChildNode.Tag = Rwork.CAT_ID;
Aparentnode.Nodes.Add(ChildNode);
GetChild(Rwork.CAT_ID, ChildNode);
}
}
public override void Get(int Aid, ref int Arows)
{
string sql;
int rows;
CatV workDS;
// get the first suiteable title and return it
workDS = new CatV();
sql = String.Format("Select * from tdbadmin.tdbv_cat where cat_id = {0} and s_id = {1}", Aid, tdb.User.Ulangid);
FillDS(workDS, sql, new string[] { "tdbv_cat" });
Arows = workDS.tdbv_cat.Rows.Count;
CatV.tdbv_catRow Rwork = workDS.tdbv_cat[0];
// set variables now
id = Rwork.CAT_ID;
bez = Rwork.BEZ;
bez_id = Rwork.BEZ_ID;
hkat_id = Rwork.H_KAT_ID;
suptid = Rwork.SUPTYPID;
supt = Rwork.SUPTYP;
color = Rwork.GA;
text_id = Rwork.TEXTID;
if (text_id > 0)
rows = GetText();
else
text = "";
}
static void Main(string[] args)
{
string age = String.Empty;
while (string.IsNullOrEmpty(age))
{
Console.WriteLine("Пожалуйста укажите возраст кошки:");
age = Console.ReadLine();
}
var CatV = new CatV(age);
var menuEnter = true;
while (menuEnter)
{
//Console.Clear();
if (string.IsNullOrEmpty(CatV.Cat.Name))
{
Console.WriteLine(@"
Имя кошки: {0} / Текущий цвет: {1} / Возраст: {2}
Введите номер пункта меню и нажмите Enter:
1 - Задать имя;
2 - Задать цвет;
3 - Ударить;
4 - Покормить;
5 - Выход.
", (string.IsNullOrEmpty(CatV.Cat.Name)) ? "[Значение не задано]" : CatV.Cat.Name, CatV.Cat.CurrentColor, CatV.Cat.Age);
}
else
{
Console.WriteLine(@"
Имя кошки: {0} / Текущий цвет: {1} / Возраст: {2}
Введите номер пункта меню и нажмите Enter:
2 - Задать цвет;
3 - Ударить;
4 - Покормить;
5 - Выход.
", (string.IsNullOrEmpty(CatV.Cat.Name)) ? "[Значение не задано]" : CatV.Cat.Name, CatV.Cat.CurrentColor, CatV.Cat.Age);
}
var choosedMenu = Console.ReadLine();
while (string.IsNullOrEmpty(choosedMenu))
{
Console.WriteLine("Выберите пункт меню!!!!!");
choosedMenu = Console.ReadLine();
}
switch (choosedMenu)
{
case "1":
if (string.IsNullOrEmpty(CatV.Cat.Name))
{
Console.WriteLine("Введите имя кошки:");
string name = Console.ReadLine();
while (string.IsNullOrEmpty(name))
{
Console.WriteLine("Введите не пустое имя кошки:");
name = Console.ReadLine();
}
CatV.Cat.Name = name;
}
else
{
Console.WriteLine("Имя уже задано");
}
break;
case "2":
Console.WriteLine("Введите цвет здоровой кошки (пусто, если не менять): ");
string heathyColor = Console.ReadLine();
Console.WriteLine("Введите цвет для больной кошки (пусто, если не менять): ");
string sickColor = Console.ReadLine();
CatV.ChangeColor(heathyColor, sickColor);
break;
case "3":
CatV.Cat.Punish();
Console.WriteLine("Животное наказано!=(");
break;
case "4":
CatV.Cat.Feed();
Console.WriteLine("Животное накормлено");
break;
case "5":
return;
break;
}
}
Console.ReadLine();
}
