public ContactCorpCollection QueryAllCorpList(ValidState vState)
{
ContactCorpCollection corps = new ContactCorpCollection();
string sqlString = "select * from XPM_Basic_ContactCorp";
switch (vState)
{
case ValidState.InValid:
sqlString = sqlString + " where IsValid = 0 ";
break;
case ValidState.Valid:
sqlString = sqlString + " where IsValid = 1 ";
break;
}
using (DataTable table = publicDbOpClass.DataTableQuary(sqlString))
{
int count = table.Rows.Count;
for (int i = 0; i < count; i++)
{
corps.Add(this.DataRowToContactCorpInfo(table.Rows[i]));
}
}
return(corps);
}
public ContactCorpCollection QuerylistForguidandSta(string guidcode)
{
ContactCorpCollection corps = new ContactCorpCollection();
using (DataTable table = publicDbOpClass.DataTableQuary("select * from XPM_Basic_ContactCorp where flowguid='" + guidcode + "' and auditstate=0"))
{
int count = table.Rows.Count;
for (int i = 0; i < count; i++)
{
corps.Add(this.DataRowToContactCorpInfo(table.Rows[i]));
}
}
return(corps);
}
public ContactCorpCollection QueryCorpList3(int typeID)
{
ContactCorpCollection corps = new ContactCorpCollection();
using (DataTable table = publicDbOpClass.DataTableQuary("select * from XPM_Basic_ContactCorp where (CorpTypeID = " + typeID.ToString() + ")and(IsValid=1) and (AuditState<>1) "))
{
int count = table.Rows.Count;
for (int i = 0; i < count; i++)
{
corps.Add(this.DataRowToContactCorpInfo(table.Rows[i]));
}
}
return(corps);
}
public ContactCorpCollection QueryCorpList1(string strwhere)
{
ContactCorpCollection corps = new ContactCorpCollection();
using (DataTable table = publicDbOpClass.DataTableQuary("select * from XPM_Basic_ContactCorp where " + strwhere + " "))
{
int count = table.Rows.Count;
for (int i = 0; i < count; i++)
{
corps.Add(this.DataRowToContactCorpInfo(table.Rows[i]));
}
}
return(corps);
}
public ContactCorpCollection ShouDelQueryCorpList()
{
ContactCorpCollection corps = new ContactCorpCollection();
string sqlString = "select * from XPM_Basic_ContactCorp where (IsValid=0)";
using (DataTable table = publicDbOpClass.DataTableQuary(sqlString))
{
int count = table.Rows.Count;
for (int i = 0; i < count; i++)
{
corps.Add(this.DataRowToContactCorpInfo(table.Rows[i]));
}
}
return(corps);
}
public ContactCorpCollection QueryCorpList(int typeID)
{
string str;
ContactCorpCollection corps = new ContactCorpCollection();
if (((typeID == 5) || (typeID == 4)) || ((typeID == 0x13) || (typeID == 20)))
{
str = "select * from XPM_Basic_ContactCorp where (CorpTypeID = " + typeID.ToString() + ")and(IsValid=1) and (AuditState = 1)";
}
else
{
str = "select * from XPM_Basic_ContactCorp where (CorpTypeID = " + typeID.ToString() + ")and(IsValid=1)";
}
using (DataTable table = publicDbOpClass.DataTableQuary(str))
{
int count = table.Rows.Count;
for (int i = 0; i < count; i++)
{
corps.Add(this.DataRowToContactCorpInfo(table.Rows[i]));
}
}
return(corps);
}