public int SaveDocument(IdentityObject ident, string _tableName, string inDocNum, string inDocType, List <string> myData)
{
int retCode = 0;
// DocNum = inDocNum;
DocNum = Int32.Parse(inDocNum);
DocType = Int32.Parse(inDocType);
string cmdString = String.Format("insert into {0} Values ({1})", _tableName.Trim(), myData[0]); //where DocNum = {1} and DocType = {2}", _tableName, inDocNum, inDocType);
string retMessage = DataBaseUtility.Execute(cmdString, ident);
// 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 DocumentDetails where DucNum = {0} and DocType = {1}, inDocNum, inDocType");
// List<string> detailStrings = DbUtility.GetList(cmdString);
if (myData.Count < 2)
{
return(0);
}
for (int i = 1; i < myData.Count; i++)
{
string cmdString2 = String.Format("insert into {0}_Details Values ({1})", _tableName.Trim(), myData[i]);
string retMessage2 = DataBaseUtility.Execute(cmdString2, ident);
}
return(retCode);
}
//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 = DbUtility.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 = DbUtility.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 = 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 = 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);
}
