public int Remarksstatus(string ccode, string pcode, string d1, string d2)
{
int satus;
string sqlstr = "SELECT Count(Remarkstatus) FROM ProcurementImport where Prdate between '" + d1.ToString() + "' and '" + d2.ToString() + "' and Plant_Code='" + pcode + "' And company_code='" + ccode + "' and Remarkstatus=1";
satus = userDA.ExecuteScalarint(sqlstr);
return(satus);
}