public static Feedbk GetOne(Int64 OID)
{
DBCon dBCon = new DBCon();
SqlCommand cmd = null;
SqlDataReader SDR = null;
Feedbk feedbk = new Feedbk();
try
{
string Quary = "Select TOP 1 * From FeedBk where OrderId=" + OID;
cmd = new SqlCommand(Quary, dBCon.Con);
SDR = cmd.ExecuteReader();
while (SDR.Read())
{
feedbk.FeedBkId = SDR.GetInt32(0);
feedbk.OrgId = SDR.GetInt32(1);
feedbk.OrderId = SDR.GetInt64(2);
feedbk.FeedbkFormId = SDR.GetInt32(3);
feedbk.CreateOn = SDR.GetDateTime(4);
}
}
catch (Exception e) { e.ToString(); }
finally { cmd.Dispose();; dBCon.Con.Close(); }
return(feedbk);
}
public static List <Feedbk> GetAll(int OrgId, DateTime Fdate, DateTime Tdate)
{
DBCon dBCon = new DBCon();
SqlCommand cmd = null;
SqlDataReader SDR = null;
List <Feedbk> listfeedbk = new List <Feedbk>();
try
{
string Quary = "Select * From FeedBk where OrgId=" + OrgId;
if (Fdate != null && Tdate != null)
{
Quary += "and CreateOn between '" + Fdate.ToString("MM/dd/yyyy") + "' and '" + Tdate.ToString("MM/dd/yyyy HH:mm:ss") + "";
}
cmd = new SqlCommand(Quary, dBCon.Con);
SDR = cmd.ExecuteReader();
while (SDR.Read())
{
Feedbk OBJfeedbk = new Feedbk();
OBJfeedbk.FeedBkId = SDR.GetInt32(0);
OBJfeedbk.OrgId = SDR.GetInt32(1);
OBJfeedbk.OrderId = SDR.GetInt64(2);
OBJfeedbk.FeedbkFormId = SDR.GetInt32(3);
OBJfeedbk.CreateOn = SDR.GetDateTime(4);
listfeedbk.Add(OBJfeedbk);
}
}
catch (Exception e) { e.ToString(); }
finally { cmd.Dispose();; dBCon.Con.Close(); }
return(listfeedbk);
}