int select_id_where_xlsname(string name, string tablename, string like)
{
string zap = "Select ID from " + tablename + " where " + tablename + ".xls" + name + " like '%" + like + "%'";
object ob = SQL_Class.ReadValue(zap);
if (ob == null)
{
return(-1);
}
else
{
return(Convert.ToInt32(ob));
}
}
string select_name_where_id(string name, string tablename, int i)
{
string zap = "Select " + tablename + "." + name + " from " + tablename + " where ID= " + i;
object ob = SQL_Class.ReadValue(zap);
if (ob == null)
{
return("");
}
else
{
return(ob.ToString());
}
}
