public string ValidaLogin(string sLogin, string sSenha)
{
sql.AppendFormat("EXEC SP_AUTENTICA_USUARIO @login = '******', @dc_senha = '{1}' ", sLogin.Trim(), sSenha.Trim());
return(cn.DataTableToJSON(cn.SelectAccessDBSqlServer(sql.ToString())));
}
public string InserePedido(int idCliente, int idLogin)
{
sql.AppendFormat("exec SP_PEDIDO @IDCLIENTE = {0}, @IDUSUARIO = {1};", idCliente, idLogin);
return(cn.DataTableToJSON(cn.SelectAccessDBSqlServer(sql.ToString())));
}
public string ListaMaterial()
{
sql.Append("SELECT id_material, cod_material, dc_material FROM TB_MATERIAL");
return(cn.DataTableToJSON(cn.SelectAccessDBSqlServer(sql.ToString())));
}