public GenDoc(List<string> records)
{
int linecount = records.Count;
string[] field = records[0].Split(',');
DocNum = Int32.Parse(field[0]);
DocType = Int32.Parse(field[1]);
ExternalAgent = Int32.Parse(field[2]);
InternalAgent = Int32.Parse(field[3]);
Status = Int32.Parse(field[4]);
ProcessID = Int32.Parse(field[5]);
TextValue1 = (field[6]);
TextValue2 = (field[7]);
QuotedAmount = decimal.Parse(field[8]);
ActualAmount = decimal.Parse(field[9]);
Comment = field[10];
_docDetails = new List<DocDetailItem>();
for (int i = 2; i < linecount; i++)
{
string[] nextRecord = records[i].Split(',');
if (nextRecord.Length > 8)
{
// (" record longer than 8 fields");
continue;
}
DocDetailItem detailItem = new DocDetailItem(records[i]);
_docDetails.Add(detailItem);
}
}
public GenDoc(List <string> records)
{
int linecount = records.Count;
string[] field = records[0].Split(',');
DocNum = Int32.Parse(field[0]);
DocType = Int32.Parse(field[1]);
ExternalAgent = Int32.Parse(field[2]);
InternalAgent = Int32.Parse(field[3]);
Status = Int32.Parse(field[4]);
ProcessID = Int32.Parse(field[5]);
TextValue1 = (field[6]);
TextValue2 = (field[7]);
QuotedAmount = decimal.Parse(field[8]);
ActualAmount = decimal.Parse(field[9]);
Comment = field[10];
_docDetails = new List <DocDetailItem>();
for (int i = 1; i < linecount; i++)
{
string[] nextRecord = records[i].Split(',');
if (nextRecord.Length > 8)
{
// (" record longer than 8 fields");
continue;
}
DocDetailItem detailItem = new DocDetailItem(records[i]);
_docDetails.Add(detailItem);
}
}
public virtual List <string> GetDocument(string tablename, int inDocNum, int inDocType)
{
string cmdString = String.Format("select * from {0} where DucNum = {1} and DocType = {2}", tablename, inDocNum, inDocType);
List <string> mainString = new List <string>();
mainString = Utilities.DataBaseUtility.GetList(cmdString);
if (mainString.Count < 2)
{
return(mainString);
}
// if (mainString.Count > 2) return 3;
// count = 2, therefore found 1 data record and 1 string of names
new GenDoc(mainString[1]);
cmdString = String.Format("select * from DocumentDetails where DucNum = {0} and DocType = {1}, inDocNum, inDocType");
List <string> detailStrings = Utilities.DataBaseUtility.GetList(cmdString);
if (detailStrings.Count < 2)
{
return(mainString);
}
for (int i = 1; i < detailStrings.Count; i++)
{
DocDetailItem _item = new DocDetailItem(detailStrings[i]);
}
return(mainString);
}
public virtual int GetDocument(int inDocNum, int inDocType)
{
string docName = "GenDocs";
string cmdString = String.Format("select * from {0} where DucNum = {1} and DocType = {2}", docName, inDocNum, inDocType);
List <string> mainString = Utilities.DataBaseUtility.GetList(cmdString);
if (mainString.Count < 2)
{
return(0);
}
if (mainString.Count > 2)
{
return(3);
}
// count = 2, therefore found 1 data record and 1 string of names
new GenDoc(mainString[1]);
cmdString = String.Format("select * from {0}_Details where DucNum = {1} and DocType = {2}", docName, inDocNum, inDocType);
List <string> detailStrings = Utilities.DataBaseUtility.GetList(cmdString);
if (detailStrings.Count < 2)
{
return(0);
}
for (int i = 1; i < detailStrings.Count; i++)
{
DocDetailItem _item = new DocDetailItem(detailStrings[i]);
}
return(detailStrings.Count - 1);
}
public virtual List<string> GetDocument(string tablename, int inDocNum, int inDocType)
{
string cmdString = String.Format("select * from {0} where DucNum = {1} and DocType = {2}",tablename, inDocNum, inDocType);
List<string> mainString = new List<string>();
mainString = Utilities.DataBaseUtility.GetList(cmdString);
if (mainString.Count < 2)
{
return mainString;
}
// if (mainString.Count > 2) return 3;
// count = 2, therefore found 1 data record and 1 string of names
new GenDoc(mainString[1]);
cmdString = String.Format("select * from DocumentDetails where DucNum = {0} and DocType = {1}, inDocNum, inDocType");
List<string> detailStrings = Utilities.DataBaseUtility.GetList(cmdString);
if (detailStrings.Count < 2) return mainString ;
for (int i = 1; i < detailStrings.Count; i++)
{
DocDetailItem _item = new DocDetailItem(detailStrings[i]);
}
return mainString ;
}
public virtual int GetDocument(int inDocNum, int inDocType)
{
string docName = "GenDocs";
string cmdString = String.Format("select * from {0} where DucNum = {1} and DocType = {2}", docName, inDocNum, inDocType);
List<string> mainString = Utilities.DataBaseUtility.GetList(cmdString);
if (mainString.Count < 2) return 0;
if (mainString.Count > 2) return 3;
// count = 2, therefore found 1 data record and 1 string of names
new GenDoc(mainString[1]);
cmdString = String.Format("select * from {0}_Details where DucNum = {1} and DocType = {2}", docName, inDocNum, inDocType);
List<string> detailStrings = Utilities.DataBaseUtility.GetList(cmdString);
if (detailStrings.Count < 2) return 0;
for (int i = 1; i < detailStrings.Count; i++)
{
DocDetailItem _item = new DocDetailItem(detailStrings[i]);
}
return detailStrings.Count - 1;
}
private void button_Display_Click(object sender, EventArgs e)
{
List<string> _records = new List<string>();
try
{
// _documentValues = Utilities.DataBaseUtility.GetTable(cmdStr);
_records = Utilities.DataBaseUtility.GetList(textBox_Cmd.Text);
}
catch (Exception ex)
{
MessageBox.Show(" error in reading table : " + textBox_TableName.Text, ex.Message);
return;
}
if (_records.Count < 2)
{
MessageBox.Show(" error in reading table : " + textBox_TableName.Text);
return;
} _records.RemoveAt(0);
textBox_DataStrings.Text = _records[0];
string[] _documentValues = _records[0].Split(',');
//dataGridView1.DataSource = _documentValues;
textBox_DocNum.Text = _documentValues[0].ToString();
int docNumber = Int32.Parse(textBox_DocNum.Text);
textBox_DocType.Text = _documentValues[1].ToString();
int docType = Int32.Parse(textBox_DocType.Text);
textBox_ExtAgent.Text = _documentValues[2].ToString();
textBox_IntAgent.Text = _documentValues[3].ToString();
textBox_Status.Text = _documentValues[4].ToString();
// string tablename = "GenDocs";
textBox_ProcessID.Text = _documentValues[5].ToString();
textBox_TextValue1.Text = _documentValues[6].ToString();
textBox_TextValue2.Text = _documentValues[7].ToString(); // StatusDate
textBox_NumValue1.Text = _documentValues[8].ToString(); // quotedAmount
textBox_NumValue2.Text = _documentValues[9].ToString(); // actualAmount
textBox_Comment.Text = _documentValues[10].ToString();
string cmdStr2 = String.Format("select * from {0}_Details where docNum = {1} and doctype = {2}",
textBox_TableName.Text.Trim(), docNumber, docType);
_records = new List<string>();
try
{
// _documentValues = Utilities.DataBaseUtility.GetTable(cmdStr);
//_records = Utilities.DataBaseUtility.GetList(textBox_Cmd.Text);
_records = Utilities.DataBaseUtility.GetList(cmdStr2);
}
catch (Exception ) { }
if (_records.Count < 2) return;
for (int i = 1; i < _records.Count; i++)
{
DocDetailItem _detail = new DocDetailItem(_records[i]);
textBox_DataStrings.Text += "\r\n" + _records[i]; // _detail.ToString();
}
DataTable _documentTable = Utilities.DataBaseUtility.GetTable(cmdStr2);
dataGridView1.DataSource = _documentTable;
dataGridView1.Visible = true;
panel1.Visible = true;
}
protected void button_Display_Click(object sender, EventArgs e)
{
List <string> _records = new List <string>();
try
{
// _documentValues = Utilities.DataBaseUtility.GetTable(cmdStr);
_records = Utilities.DataBaseUtility.GetList(textBox_Cmd.Text);
}
catch (Exception ex)
{
MessageBox.Show(" error in reading table : " + textBox_TableName.Text, ex.Message);
return;
}
if (_records.Count < 2)
{
MessageBox.Show(" error in reading table : " + textBox_TableName.Text);
return;
}
_records.RemoveAt(0);
panel1.Visible = true;
textBox_DataStrings.Text = _records[0];
string[] _documentValues = _records[0].Split(',');
textBox_DocNum.Text = _documentValues[0].ToString();
int docNumber = Int32.Parse(textBox_DocNum.Text);
textBox_DocType.Text = _documentValues[1].ToString();
int docType = Int32.Parse(textBox_DocType.Text);
textBox_ExtAgent.Text = _documentValues[2].ToString();
textBox_IntAgent.Text = _documentValues[3].ToString();
textBox_Status.Text = _documentValues[4].ToString();
textBox_ProcessID.Text = _documentValues[5].ToString();
textBox_TextValue1.Text = _documentValues[6].ToString();
textBox_TextValue2.Text = _documentValues[7].ToString(); // StatusDate
textBox_NumValue1.Text = _documentValues[8].ToString(); // quotedAmount
textBox_NumValue2.Text = _documentValues[9].ToString(); // actualAmount
textBox_Comment.Text = _documentValues[10].ToString();
string cmdStr2 = String.Format("select * from {0}_Details where docNum = {1} and doctype = {2}",
textBox_TableName.Text.Trim(), docNumber, docType);
_records = new List <string>();
try
{
// _documentValues = Utilities.DataBaseUtility.GetTable(cmdStr);
//_records = Utilities.DataBaseUtility.GetList(textBox_Cmd.Text);
_records = Utilities.DataBaseUtility.GetList(cmdStr2);
}
catch (Exception) { }
if (_records.Count < 2)
{
return;
}
for (int i = 1; i < _records.Count; i++)
{
DocDetailItem _detail = new DocDetailItem(_records[i]);
textBox_DataStrings.Text += "\r\n" + _records[i]; // _detail.ToString();
}
DataTable _documentTable = Utilities.DataBaseUtility.GetTable(cmdStr2);
dataGridView1.DataSource = _documentTable;
dataGridView1.Visible = true;
panel1.Visible = true;
}
