//public string Password
//{
// get { return StrPasword; }
// set { StrPasword = value; }
//}
//public string RSerialNO
//{
// get { return Str_RSerialNo; }
// set { Str_RSerialNo = value; }
//}
//public string MSerialNO
//{
// get { return Str_MSerialNo; }
// set { Str_MSerialNo = value; }
//}
#endregion
#region "Methods"
public DataView GetAll(int flag)
{
switch (flag)
{
case 1:
objdbhims.Query = "select * from mi_tpreferencesetting where Status='Y'";
break;
case 2:
objdbhims.Query = "select * from mi_tresult where ResultID > '" + Strmaxid + "'";
//objdbhims.Query = objdbhims.Query + " Where Upper(t.GroupName) = '" + this._GroupName.ToUpper() + "'";
break;
case 3:
objdbhims.Query = "select max(ResultID) AS maxid from mi_tresult where ResultID>'" + Strmaxid + "'";
break;
case 4:
objdbhims.Query = "select max(maxresultid) as maxresultid from mi_taudit ";
break;
}
return(objTrans.DataTrigger_Get_All(objdbhims));
}
//public string Password
//{
// get { return StrPasword; }
// set { StrPasword = value; }
//}
//public string RSerialNO
//{
// get { return Str_RSerialNo; }
// set { Str_RSerialNo = value; }
//}
//public string MSerialNO
//{
// get { return Str_MSerialNo; }
// set { Str_MSerialNo = value; }
//}
#endregion
#region "Methods"
public DataView GetAll(int flag)
{
switch (flag)
{
case 1:
objdbhims.Query = "select * from ls_tinterface where MserialNo ='" + StrMMserialno + "' and AttributeID=" + StrAttributeID + "";
break;
case 2:
objdbhims.Query = "select * from mi_tresult where ResultID > '" + StrClientID + "'";
//objdbhims.Query = objdbhims.Query + " Where Upper(t.GroupName) = '" + this._GroupName.ToUpper() + "'";
break;
case 3:
objdbhims.Query = "select max(ResultID) AS maxid from mi_tresult where ResultID>'" + StrClientID + "'";
break;
case 4:
objdbhims.Query = "select max(maxresultid) as maxresultid from mi_taudit ";
break;
}
return(objTrans.DataTrigger_Get_All(objdbhims));
}